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
rkl1
Messages: 97
Registered: June 2005
Member
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
dzt52r
Messages: 19
Registered: July 2007
Location: PA
Junior Member
You may want to chekc this thread on Ask Tom.

http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:2109833600346625821
Previous Topic: to read the control.DBF
Next Topic: synonyms
Goto Forum:
  


Current Time: Sun Dec 11 02:18:53 CST 2016

Total time taken to generate the page: 0.20232 seconds