RE: DB Time in AWR report in 10g

From: <oracle-l-bounce_at_freelists.org>
Date: Mon, 2 Oct 2006 11:25:07 -0500
Message-ID: <C8C159860377BD4CB874629A9C1DEACB797DBF@scarlitnt640.alltel.com>

Mark - Thanks for looking into this.

The AWR snapshot over a 30 minutes duration is consistent with the 24 hour snapshot.

              Snap Id      Snap Time      Sessions Curs/Sess
            --------- ------------------- -------- ---------
Begin Snap:      1588 02-Oct-06 10:00:45       273       3.2
  End Snap:      1589 02-Oct-06 10:30:50       272       3.3
   Elapsed:               30.08 (mins)
   DB Time:                1.35 (mins)

This confirms my belief that the system is idle most of the time or optimally tuned. We may decide to put more workload on the system later on.

Thanks,
Govind

-----Original Message-----

From: Powell, Mark D [mailto:mark.powell_at_eds.com]
Sent: Monday, October 02, 2006 10:55 AM
To: Arumugam, Govind; oracle-l_at_freelists.org

Subject: RE: DB Time in AWR report in 10g

Yes, the report would indicate that overall your system was mostly idle, but understand that statspack reports over such a large time frame are mostly useless. Your problems are lost in the averages.

Mark D Powell -- Phone (313) 592-5148

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Govind.Arumugam_at_alltel.com
Sent: Monday, October 02, 2006 10:09 AM
To: oracle-l_at_freelists.org
Subject: DB Time in AWR report in 10g

> Dear Oracle Gurus,
>
> We upgraded one of our Production systems to 10g R1 recently. Here is
the AWR report for a 24 hour period.
>
>
> Snap Id Snap Time Sessions Curs/Sess
> --------- ------------------- -------- ---------
> Begin Snap: 1378 28-Sep-06 01:00:31 274 3.3
> End Snap: 1426 29-Sep-06 01:00:28 273 3.4
> Elapsed: 1,439.94 (mins)
> DB Time: 83.46 (mins)
>
> I am looking at the "DB Time" of 83 minutes; Does this mean that the
db was practically idle most of the time when compared to the total Elapsed time of 1440 minutes?
>
> Thanks,
> Govind
>
>

The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, Alltel requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else.

--
http://www.freelists.org/webpage/oracle-l



******************************************************************************************
The information contained in this message, including attachments, may contain 
privileged or confidential information that is intended to be delivered only to the 
person identified above. If you are not the intended recipient, or the person 
responsible for delivering this message to the intended recipient, Alltel requests 
that you immediately notify the sender and asks that you do not read the message or its 
attachments, and that you delete them without copying or sending them to anyone else. 


--
http://www.freelists.org/webpage/oracle-l

Received on Mon Oct 02 2006 - 11:25:07 CDT