Home » RDBMS Server » Server Administration » the mean of avrd(ms)
the mean of avrd(ms) [message #276482] Thu, 25 October 2007 04:56 Go to next message
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 #276508 is a reply to message #276482] Thu, 25 October 2007 06:32 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Average read time in milliseconds (for one read).

Regards
Michel

Re: the mean of avrd(ms) [message #276530 is a reply to message #276508] Thu, 25 October 2007 07:26 Go to previous messageGo to next message
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 #276538 is a reply to message #276530] Thu, 25 October 2007 07:53 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I think you do other things than reading.

Regards
Michel
Re: the mean of avrd(ms) [message #276549 is a reply to message #276538] Thu, 25 October 2007 08:22 Go to previous messageGo to next message
alantany
Messages: 115
Registered: July 2007
Senior Member

You mean writes on the tablespaces?
yes,it is!
and any thing else?

Regards!
Alan
Re: the mean of avrd(ms) [message #276559 is a reply to message #276549] Thu, 25 October 2007 08:45 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
cpu, waits on Oracle, waits on Os, waits on network, waits on user...

Regards
Michel
Re: the mean of avrd(ms) [message #276563 is a reply to message #276559] Thu, 25 October 2007 08:57 Go to previous messageGo to next message
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
Re: the mean of avrd(ms) [message #276568 is a reply to message #276563] Thu, 25 October 2007 09:06 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It includes all what is between the start marker and the end marker in Oracle code for a read or write.
This also can be greater than the overall time if you have multiple processes/sessions at the same during the period.

Regards
Michel

Re: the mean of avrd(ms) [message #276655 is a reply to message #276568] Thu, 25 October 2007 19:12 Go to previous messageGo to next message
alantany
Messages: 115
Registered: July 2007
Senior Member

A lot of thanks,Michel:
I am very curious where you get these info?It doesn't documented by ORACLE:)
Regards
Alan

[Updated on: Thu, 25 October 2007 19:13]

Report message to a moderator

Re: the mean of avrd(ms) [message #276696 is a reply to message #276655] Fri, 26 October 2007 00:45 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I have worked with Oracle since 19 years.

Regards
Michel
Re: the mean of avrd(ms) [message #276704 is a reply to message #276696] Fri, 26 October 2007 00:58 Go to previous messageGo to next message
alantany
Messages: 115
Registered: July 2007
Senior Member

Michel Cadot wrote on Fri, 26 October 2007 00:45

I have worked with Oracle since 19 years.


Cool~~,super man!

Regards
Alan
Re: the mean of avrd(ms) [message #276712 is a reply to message #276482] Fri, 26 October 2007 01:24 Go to previous messageGo to next message
trantuananh24hg
Messages: 668
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
Quote:


I have worked with Oracle since 19 years.



I've thought that you're seem about 40~45 years old.
Re: the mean of avrd(ms) [message #276713 is a reply to message #276712] Fri, 26 October 2007 01:38 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
My birth date is in my profile.

Regards
Michel

[Updated on: Fri, 26 October 2007 01:39]

Report message to a moderator

Re: the mean of avrd(ms) [message #276891 is a reply to message #276713] Fri, 26 October 2007 11:20 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Quote:

I have worked with Oracle since 19 years.


Your experiences and mine age 5 years difference only Wink


But you are doing good job Michel. Thumbs Up
Previous Topic: statspack
Next Topic: locks
Goto Forum:
  


Current Time: Sun Dec 04 08:46:21 CST 2016

Total time taken to generate the page: 0.12934 seconds