Re: Where did it go

From: Ram Raman <veeeraman_at_gmail.com>
Date: Wed, 18 Feb 2015 12:55:14 -0600
Message-ID: <CAHSa0M00j6N_AT0Mq3sqR5WDr88Q1iaRURWUf2_OpjJks=tACw_at_mail.gmail.com>

Thanks Tim. I thought 'DB Time' did not include idle wait events.

On Wed, Feb 18, 2015 at 1:16 AM, Tim Gorman <tim_at_evdbt.com> wrote:

> Haven't looked at STATSPACK in years, but it used to classify some events
> as "idle" (their names were stored in a table named STATS$IDLE_EVENTS, I
> think), and it wouldn't gather information about them.
>
> I'll bet the other 8 mins is in one of those untracked "idle" events like
> "SQL*Net message from client".
>
>
>
> On 2/17/15 17:23, Ram Raman wrote:
>
>> List
>>
>> Below is a copy and paste of a section of statspack from a DB on a v11.2
>> on windows. The DB Time of more than 17 mins compared to DB CPU of 2.4 mins
>> got me scratching my head. I feel that it means there is lots of wait
>> somewhere. But, the top most wait of dbf seq read is only about 7 mins.
>> Where did the other 8 mins go?
>>
>> ************************************************************
>> *******************
>> Snapshot Snap Id Snap Time Sessions Curs/Sess Comment
>> ~~~~~~~~ ---------- ------------------ -------- ---------
>> ------------------
>> Begin Snap: 4132 16-Feb-15 22:00:27 54 9.1
>> End Snap: 4143 16-Feb-15 23:00:27 51 10.1
>> Elapsed: 60.00 (mins) Av Act Sess: 0.3
>> DB time: 17.38 (mins) DB CPU: 2.44 (mins)
>>
>> Cache Sizes Begin End
>> ~~~~~~~~~~~ ---------- ----------
>> Buffer Cache: 3,696M Std Block Size: 8K
>> Shared Pool: 224M Log Buffer: 18,240K
>>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 

You can become a doctor and then websearch for solutions; You cannot
websearch and become a doctor

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

Received on Wed Feb 18 2015 - 19:55:14 CET