gc buffer busy waits
Date: Wed, 09 Mar 2011 13:47:08 -0500
Not sure if this has been asked, but i just don't know what to do with the information that ADDM and ASH reports give me.
We have a large table DA.ST_INV_ITEMS_HS, almost 690,000 rows. Big table with lots of columns. The table takes up 632Meg. It has only 173 extents. 8k block database 10gR2 RAC 2 node cluster. Tons of cluster waits on that table. I always thought that that means that one session has queried off this table, locked those blocks or extents in memory on one node and a session on the other nodes is waiting for those blocks or extents to be unlocked.
can someone explain what the ASH report means about Top DB Objects?
Top DB Objects
With respect to Application, Cluster, User I/O and buffer busy waits only.
Object Name (Type)
gc buffer busy
DA.ST_INV_ITEMS_HS (TABLE) USERS gc cr multi block request
7.70Received on Wed Mar 09 2011 - 12:47:08 CST