Contact Us  |  Ask for Pricing  |  Partners

The World's Fastest Storage®
 

superSSD > Education > Oracle Performance Center > Code List

Oracle Performance Center - Code List


List of Code on Website

List Name Simple Insert Load test File
Name simple_load_test_insert.pl
Purpose This procedure is designed to create a heavy insert workload. This should not be run on a production system. This is designed to be loaded into the SCOTT schema, but any test schema will do. To use this test you would start a sqlplus session and execute the following sql command "exec make_load_no_del". This test will run for several hours. It can be stopped by killing the sqlplus session.

List Name Decimal Seconds Function
File Name dec_seconds.pl
Purpose This function is used to calculate the number of seconds between two timestamps. It is called internally by the stats collection procedures.

List Name Get An Individual AWR Statistic
File Name get_a_stat.pl
Purpose This procedure will list values between AWR snapshots for a range of snapshots for one particular AWR Statistic. Please see the header comments for more details.

List Name Get Read / Write Statistics from AWR
File Name track_perf_info.pl
Purpose This procedure will list in csv format all parameters from snapshots. Please see the header comments for more details.

List Name Script to get sizes of Oracle Physical Storage objects
File Name object_size.sql
Purpose This is used to report the physical sizes of storage objects.

Texas Memory Systems Sales - Call (713) 266-3200

Sign up for the RamSan Mailing List

Home  |  Company  |  Products  |  Support  |  Resources  |  Partners
 Contact Us  |  Legal  |   Library  |  Press  |  Success Stories  |  Privacy Policy

Copyright © 2006 Texas Memory Systems. All Rights Reserved.