Oracle Assessments Export

The OLA Assessments Export is a downloadable Zipper file available in the Assessment Reports section. It provides comprehensive data on Oracle instances, covering compatibility, sizing, and licensing details for cloud migration.

It is important to note that for the Oracle assessments export to be processed correctly, ensure to enable two packages on machines running Oracle DB: Statspack and Diagnostic Pack. Without these packages enabled, the report may not be processed correctly due to incomplete data collection.

Cloudamize supports exporting data gathered by our Windows and Linux agents from the Oracle Databases present on servers. Oracle data collection is now supported by the Windows and Linux agents, and even by the Cloudamize Agentless Data Collector.

Cloudamize Oracle Assessments export helps organizations plan cloud migrations for their Oracle databases. These reports gather detailed data on your current Oracle environment's performance and costs. Later on, it analyzes this data to recommend optimal cloud configurations, right-size resources (like CPU, RAM, storage) to match actual needs, and provide a Total Cost of Ownership (TCO) comparison between your on-premises setup and various cloud Service Providers (AWS, Azure, GCP).

The goal is to ensure cost efficiency, maintain performance, and simplify the migration process by identifying dependencies and suggesting suitable migration strategies for your Oracle workloads.

You can find the report in the Reports tab in the main results screen once your assessment results are published

Steps to Navigate to the Oracle Assessments Export:

Log in to the console https://console.cloudamize.com/#/
Navigate to the Analyze page of your completed assessment.
Click the View Details button beside your AWS results.
Click the Reports tab on the right-hand side of the screen to see the following:
Analyze > AWS View Details > Reports | Showing the Oracle Assessments Export

Column Name	Description
Server Name	Name of the server where the database resides.
DB Name	Name of the database.
AWR Report	Status or availability of the AWR (Automatic Workload Repository) report.
AWR Error	Any errors encountered while generating the AWR report.
Statspack Report	Status or availability of the Statspack report.
Statspack Error	Errors encountered in the Statspack report generation.
IP Address	IP address of the database server.
Report Collection Time	Timestamp when the report was generated or data collected.
Home Key	Identifier for Oracle Home.
Bundle Name	Name of the assessment or software bundle.
Group Name	Group or organizational identifier for the instance.
SID In Registry	Oracle System Identifier registered.
SID	Oracle System Identifier (SID).
Base Path	Base directory path for Oracle installation.
Home Path	ORACLE_HOME path for the database.
STATSPACK_MINER_VER	Version of the Statspack Miner utility used.
NUM_CPUS	Number of logical CPUs on the system.
NUM_CPU_CORES	Number of CPU cores on the system.
NUM_CPU_SOCKETS	Number of CPU sockets on the server.
PHYSICAL_MEMORY_GB	Physical RAM available on the server (in GB).
GLOBAL_CPU_COUNT	Global CPU count across the environment.
GLOBAL_CPU_CORE_COUNT	Global total of CPU cores.
GLOBAL_CPU_SOCKET_COUNT	Global total of CPU sockets.
PLATFORM_NAME	Operating system/platform name.
VERSION	Oracle database version.
DB_NAME	Database name.
DBID	Database ID.
BANNER	Oracle version banner (typically shows edition and version).
INSTANCES	Number of instances configured.
STATSPACK_SNAPSHOTS	Number of Statspack snapshots captured.
INSTANCES_CURRENT	Current active instance count.
HOSTS	Number of hosts involved.
HOSTS_CURRENT	Number of currently active hosts.
TOTAL_DB_SIZE_GB	Total size of the database (in GB).
TOTAL_DATAFILE_SIZE_GB	Total size of datafiles (in GB).
USED_DB_SIZE_GB	Currently used database space (in GB).
COUNT_DB_LINKS	Number of database links.
COUNT_LINES_PLSQL	Number of PL/SQL code lines.
COUNT_SCHEMAS	Number of schemas in the database.
COUNT_PDBS	Number of Pluggable Databases (PDBs).
COUNT_INDEX	Number of indexes in the database.
COUNT_PACKAGE	Number of PL/SQL packages.
COUNT_SEQUENCE	Number of sequences defined.
COUNT_TABLE	Number of tables in the database.
COUNT_VIEW	Number of views.
COUNT_BITMAP_INDEX	Number of bitmap indexes.
COUNT_MATVIEWS_REWRITE_ENABLED	Count of materialized views with query rewrite enabled.
FEATURE_Oracle Multitenant	Indicates if Oracle Multitenant feature is used.
FEATURE_Resource Manager	Indicates if Oracle Resource Manager is used.
DEBUG_MODULE	Debug setting/module name.
DEBUG_SQLPLUS	Debugging flag or setting related to SQL*Plus.
AWR_MINER_VER	Version of AWR Miner tool used.
NUM_CPUS	Number of logical CPUs.
NUM_CPU_CORES	Number of CPU cores.
NUM_CPU_SOCKETS	Number of CPU sockets.
PHYSICAL_MEMORY_GB	Physical memory.
GLOBAL_CPU_COUNT	Global CPU count.
GLOBAL_CPU_CORE_COUNT	Global CPU core count.
GLOBAL_CPU_SOCKET_COUNT	Global socket count.
PLATFORM_NAME	Platform name.
VERSION	Oracle version.
DB_NAME	Database name.
DBID	Database ID.
BANNER	Oracle banner.
INSTANCES	Total instances.
INSTANCES_CURRENT	Current instances.
HOSTS	Total hosts.
HOSTS_CURRENT	Current hosts.
TOTAL_DB_SIZE_GB	Total DB size.
TOTAL_DATAFILE_SIZE_GB	Total datafile size.
USED_DB_SIZE_GB	Used DB size.
COUNT_DB_LINKS	DB links count.
COUNT_LINES_PLSQL	PL/SQL lines.
COUNT_SCHEMAS	Schema count.
COUNT_PDBS	PDB count.
COUNT_INDEX	Index count.
COUNT_PACKAGE	Package count.
COUNT_SEQUENCE	Sequence count.
COUNT_TABLE	Table count.
COUNT_VIEW	View count.
COUNT_BITMAP_INDEX	Bitmap index count.
COUNT_MATVIEWS_REWRITE_ENABLED	Materialized views with rewrite enabled.
FEATURE_Oracle Multitenant	Use of Oracle Multitenant.
FEATURE_Resource Manager	Use of Resource Manager.
FEATURE_Parallel SQL Query Execution	Indicates if parallel SQL execution is enabled.
DEBUG_MODULE	Debug module.
DEBUG_CONTAINER	Debug setting for container (likely related to CDB/PDB).
DEBUG_SQLPLUS	SQL*Plus debug flag.
DEBUG_control_management_pack_access	Debug setting for Management Pack access control.
DEBUG_statistics_level	Debug flag for statistics level settings.
DEBUG_timed_statistics	Debug flag for timed statistics collection.

Example Report: oracle-assessment-master-report.xlsx