RE: Global Cache Converts & V$SYSSTAT "Time"
- From: "Marquez, Chris" <cmarquez@xxxxxxxxxxxxxxxx>
- To: "Kevin Closson" <kevinc@xxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 20 Oct 2005 22:42:31 -0400
This can not be good!?
Wait Events fine, but the gc times are sick.
This was a rather shot inverval between statspack.snap's (taken later at night
less busy).
Top 5 Timed Events
~~~~~~~~~~~~~~~~~~ % Total
Event Waits Time (s) Ela Time
-------------------------------------------- ------------ ----------- --------
CPU time 123 43.92
db file sequential read 10,004 89 31.82
db file scattered read 5,103 52 18.66
log file sync 867 6 2.08
control file sequential read 449 2 .86
-------------------------------------------------------------
Cluster Statistics for DB: Instance: Snaps: 11 -12
Global Cache Service - Workload Characteristics
-----------------------------------------------
Ave global cache get time (ms): 422.0
Ave global cache convert time (ms): 2,121.0
Chris Marquez
Oracle DBA
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx on behalf of Marquez, Chris
Sent: Thu 10/20/2005 6:24 PM
To: Kevin Closson; oracle-l@xxxxxxxxxxxxx
Subject: RE: Global Cache Converts & V$SYSSTAT "Time"
>>is this one of your top 5 wait events ?
I have not run a statspack recently and regarding sessions I have been seeing
all day, "No".
Very few RAC related waits today if any, but I have seen them inexplicably in
the past.
Node2 for us is always idle, no db sessions....so RAC waits should be NULL or
minimal always...but that is not always the case.
Also, things (load, waits, etc.) were much less in general with node 2 instance
down for the past few days.
Chris Marquez
Oracle DBA
-----Original Message-----
From: Kevin Closson [mailto:kevinc@xxxxxxxxxxxxx]
Sent: Thu 10/20/2005 6:17 PM
To: Marquez, Chris; oracle-l@xxxxxxxxxxxxx
Subject: RE: Global Cache Converts & V$SYSSTAT "Time"
is this one of your top 5 wait events ?
col "Average Time" format 999.999
SELECT V$SYSSTAT.VALUE*10 / (select value from v$sysstat where
name = 'global cache gets') "Average Time"
FROM V$SYSSTAT
WHERE V$SYSSTAT.NAME = 'global cache get time'
/
Average Time
------------
19.883
Other related posts:
