Improving the performance of single instance Oracle on file systems, January 2008

18
Figure B-1 Automation program excerpt
#!/usr/bin/ksh
• Reboot the SUT and reconfigure volume groups
• Remount file systems if necessary
server=sut1
• Establish links identifying Oracle data files
driver=driver1
• Enable or disable ODM, depending on the configuration
• Start and shut down the Oracle Database on the SUT
export RAW_LVM_DB=/dev/vgram_lvm
• Start and stop the Oracle listener for the database instance on
the SUT
export RAW_LVM_LOGS=/dev/vgram_lvm_logs
• Restore a gold (backup) copy of the database to the disk
array between each test point
:
• Get a run_id for a test data point to uniquely identify it
• Initiate a 60-minute test for a specific workload, allowing for a
25 minute warm-up period of the database
• Automatically collect STATSPACK statistics
reset_system_under_test()
• Automatically collect SARS statistics during the run
setup_database_links_and_set_odm()
set_vxfs_mount_options()
enable_odm()
disable_odm()
startup_database()
restore_data_from_gold()
block_until_dds_terminate()
shutdown_database()
get_next_run_id()
run_data_point()