Optimizing database performance while reducing resource usage
| Article:HOWTO74605 | | | Created: 2012-03-15 | | | Updated: 2012-03-15 | | | Article URL http://www.symantec.com/docs/HOWTO74605 |
Customer scenario | You are a DBA running several standalone databases on dedicated hosts wherein each host has 12 GB of memory. Each of these databases uses about 8 GB of memory (SGA) and these databases are used for report generation. These databases are loaded at different times of the day and the reporting jobs are scheduled at different times of the day. You want to consolidate four of these databases into a single host with 20 GB of memory and thus save on hardware cost without affecting the database performance. Since the reporting jobs are scheduled at different times of the day, you can use Cached ODM Advisor to identify data files that can be enable for caching. |
Solution | Symantec recommends the following solution for this scenario.
|
Detailed steps | Optimize the performance your Oracle database. See “To optimize database performance while reducing resource usage”. |
Use Cached ODM Advisor to optimize your database performance.
To optimize database performance while reducing resource usage
Identify candidate data files from each database.
$ /opt/VRTSdbed/bin/dbed_codm_adm -S $ORACLE_SID -H $ORACLE_HOME -o display File I/O statistics from Oracle V$FILESTAT view sorted on PHYRDS in descending order: Filename Number of Number of Number Number of Read Time Write Physical Physical of Blocks Time Read Write Blocks Physicall Requests Requests Physical y Written ly Read /snap_data11r2/FLAS11r2/system01. 8135 1584 12161 1992 3897 2469 dbf /snap_data11r2/FLAS11r2/sysaux01. 4331 28640 20787 62715 6003 34933 dbf /snap_arch11r2/FLAS11r2/undotbs01 44 4442 44 26633 10 1955 .dbf /hotfs/ccdata1_02.dbf 19 14 19 14 0 0 /hotfs/ccdata1_01.dbf 19 14 19 14 1 0 /hotfs/ccdata2_01.dbf 19 14 19 14 1 0 /snap_data11r2/FLAS11r2/ccdata04. 18 14 18 14 7 0 dbf /snap_data11r2/FLAS11r2/ccdata02. 18 14 18 14 3 0 dbf /snap_data11r2/FLAS11r2/ccdata01. 18 14 18 14 1 0 dbf /snap_data11r2/FLAS11r2/users01.d 18 14 18 14 8 0 bfEnable Cached ODM on the identified data files.
$ dbed_codm_adm -S $ORACLE_SID -H $ORACLE_HOME -o \ on /snap_data11r2/FLAS11r2/system01.dbf $ /opt/VRTSdbed/bin/dbed_codm_adm -S $ORACLE_SID -H $ORACLE_HOME -o display File I/O statistics from Oracle V$FILESTAT view sorted on PHYRDS in descending order: Filename Number of Number of Number Number of Read Time Write Physical Physical of Blocks Time Read Write Blocks Physicall Requests Requests Physical y Written ly Read /snap_data11r2/FLAS11r2/sysaux01. 4331 28964 20787 63400 6003 35227 dbf /snap_arch11r2/FLAS11r2/undotbs01 44 4495 44 26982 10 1974 .dbf /hotfs/ccdata1_02.dbf 19 14 19 14 0 0 /hotfs/ccdata1_01.dbf 19 14 19 14 1 0 /hotfs/ccdata2_01.dbf 19 14 19 14 1 0 /snap_data11r2/FLAS11r2/ccdata04. 18 14 18 14 7 0 dbf /snap_data11r2/FLAS11r2/ccdata02. 18 14 18 14 3 0 dbf /snap_data11r2/FLAS11r2/ccdata01. 18 14 18 14 1 0 dbf /snap_data11r2/FLAS11r2/users01.d 18 14 18 14 8 0 bf /snap_data11r2/FLAS11r2/ccdata03. 18 14 18 14 3 0 dbf
See About storage and availability management use cases for databases
|
|
Legacy ID
uxrt-60_v71153410_uxrt-60_v72974483
Article URL http://www.symantec.com/docs/HOWTO74605
Terms of use for this information are found in Legal Notices
Thank you.