| the mean of avrd(ms) [message #276482] |
Thu, 25 October 2007 04:56  |
alantany
Messages: 115
Registered: July 2007
|
Senior Member |
|
|
Hello,all:
Could someone tell me what the mean of avrd(ms) column？
Tablespace IO Stats DB/Inst: IIMSPROD/IIMSPROD Snaps: 23-24
->ordered by IOs (Reads + Writes) desc
Tablespace
------------------------------
Av [B] Av [/B] Av Av Buffer Av Buf
Reads Reads/s [B]Rd(ms)[/B] Blks/Rd Writes Writes/s Waits Wt(ms)
-------------- ------- ------ ------- ------------ -------- ---------- ------
OMIS_REPOSITORY
30,228 9 7.3 1.0 18 0 444 15.2
The duration of statspack report is 54.33 minutes.
If it mean how many ms per read cost,so the total time all read cost is 30,228*7.3/1000=220s/60=3.7 minutes ,but the total time is 54.33 minutes.
another question,how can I get the sql that generates the statspack report?
Regards!
Alan
|
|
|
|
|
|
| Re: the mean of avrd(ms) [message #276530 is a reply to message #276508] |
Thu, 25 October 2007 07:26  |
alantany
Messages: 115
Registered: July 2007
|
Senior Member |
|
|
Hi Michel:
Thank you give many helps!
But kindly explain this:
| Quote: |
If it mean how many ms per read cost,so the total time all read cost is 30,228*7.3/1000=220s/60=3.7 minutes ,but the total time is 54.33 minutes.
|
Regards!
Alan
[Updated on: Thu, 25 October 2007 07:51] by Moderator Report message to a moderator |
|
|
|
|
|
|
|
|
|
| Re: the mean of avrd(ms) [message #276563 is a reply to message #276559] |
Thu, 25 October 2007 08:57 |
alantany
Messages: 115
Registered: July 2007
|
Senior Member |
|
|
But,Michel:
Because it was a average value，I think it will include cpu,wait time.
I have calculated it,I found total reads time+total writes time is nearly close to the duration time.
You comments.
Regards!
Alan
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
