Oracle DB Analysis Tutorial — Part 2

Required Data

If you don’t have the OSW template, don’t worry, you can create a similar spreadsheet capturing the same information. The essential columns you need to have in your spreadsheet are:

# Host Information- Physical Cluster Name
- Physical Server Name
- Virtual Server Name
- Virtualisation
- Partitioning Technology
- DB Instance Name
- Environment
- DR Server
- DR Type
- Operating System

# CPU Information
- Server Model
- Processor Model
- Processors (Sockets)
- Cores per Processor
- Physical Cores
- Threads per Core
# Software Information- Product Version
- License Metric Allocated
- Restricted Use
- Application Name
- Application Vendor
- Application Type
- Architecture TypeUser Type
- Web/App Tier Server Name

We’ll go through how you can collect all this information later in this article.

Data Collection

So you have your spreadsheet and your scripts ready. Before you start tracking down the people that have the permissions to run the scripts for you, let’s get one more thing out of the way: collecting infrastructure data. Oracle license metrics are all processor related and so the licensing implications of the underlying infrastructure are major. One surprise VMWare cluster can seriously change your outlook on life. Especially if you find it during an audit.

Time to get in touch with your infrastructure teams. Most of the time they will have reports available that can provide a lot of the information you need. If you’re talking to virtualisation teams, make sure to capture the complete topology:



└─── POOL

└─── VM

This topology may be different depending on the types of virtualisation used and you may have to adjust your worksheet to hold all this information. Study the oracle partitioning policy and make sure you can provide reliable information for all required metrics.

To complete the infrastructure mapping process, begin by inserting every database host in the spreadsheet, along with the additional fields. The general principle when licensing Oracle is that the smallest hardware limited resource that can run the software should be licensed. A hardware limitation used to mean that a physical change would be required to increase the number of processors assigned to a partition. Nowadays, a hardware limitation is defined in Oracle’s hard partitioning policy. Make sure you capture any evidence needed to demonstrate that your resources are correctly partitioned (CPU Pools, VMware screenshots etc).

Disaster Recovery (DR) is another common pitfall, so make sure you include that in your reporting. You’ll need to know what the DR servers are, what resources they have allocated and the type of setup.

After you have completed this step, you can go ahead and start running the Oracle LMS script. Prioritize large servers and servers hosted on VMware clusters. Work your way through the spreadsheet and collect Review Lite outputs for all databases.

As you gather your script outputs, you’ll need to start analyzing them. This is where a tool or a consultant may be instrumental. However, if you feel you’re up for the challenge, you can start analyzing them manually. For a relatively small number of databases (less than 50) you can complete this step in a couple of weeks, also accounting for time spent running the scripts. Using a tool for the data crunching will at least half your hours spent analysing.

In our next post we’ll talk about the data analysis process, stay tunned.

Licenseware is a platform for software license management. We help organisations turn IT risk and wasted spend into growth, and new service opportunities.