Home » RDBMS Server » Server Administration » ASM performance Help (11g, Linux)
ASM performance Help [message #434352] Tue, 08 December 2009 16:58 Go to next message
Messages: 97
Registered: June 2005
Dear All:

We got the 8 Luns of each 100GB distributed across a diskgroup for our data/index storage. We ran massive update/insert statements on the tables built with indexes so there were numerous dbfile sequential reads.

We run the ADDM reports based on snapshots taken during these updates and Oracle alerted on I/O throughputs.

***The average response time for single block reads was 99 milliseconds.

*** Average datafile I/O throughput was 720K per second per reads and 1.2M per second per writes.

*** Even we already implemented ASM, oracle recommendation was to engage ASM, which is confusing.

*** On some index files, the average response time is >500 Milliseconds for single block.

Now what is meant by average response time per single block ? Is it database block or the stripe size for the diskgroup (1 MB I assume).

On the dbconsole, ASM performance TAB, we could see the response time, throughput in MB per second. Is there any script to get those info ? And what is an ideal benchmark for ASM throughput, single block average response time.

Any help, advise, suggestion will be highly appreciated.

Re: ASM performance Help [message #434745 is a reply to message #434352] Thu, 10 December 2009 08:41 Go to previous message
Messages: 19
Registered: July 2007
Location: PA
Junior Member
You may want to chekc this thread on Ask Tom.

Previous Topic: to read the control.DBF
Next Topic: synonyms
Goto Forum:

Current Time: Thu Oct 27 18:33:36 CDT 2016

Total time taken to generate the page: 0.10698 seconds