| ASM performance Help [message #434352] |
Tue, 08 December 2009 16:58  |
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.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
