This article provides steps to collect database performance data necessary for VM sizing purposes.
Prerequisites
- Requires Oracle Database Diagnostics Pack.
- Supports database versions 11.2.0.4 onwards.
Collecting performance data
- Download a script db_metrics.sql
-
Run script via SQL*Plus:
sqlplus user/password@database @db_metrics.sql
-
The script can be run as SYS or SYSTEM users. For a different user, the minimum privileges required to run the script are listed below:
grant select on dba_hist_sysmetric_summary to <username>; grant select on gv_$database to <username>; grant select on gv_$instance to <username>; grant select on gv_$memory_dynamic_components to <username>; grant select on gv_$osstat to <username>; grant select on gv_$parameter to <username>;
-
In case of a multitenant database, run the script in the root container (CDB$ROOT).
-
The script will create an output file output.html. Please share this file with FlashGrid.