Database Reference
In-Depth Information
4 gc current block 2-way 147 92425 Cluster
4 buffer busy waits 147 92427 Concurrency
4 gc current grant 2-way 147 92428 Cluster
4 buffer busy waits 147 92431 Concurrency
4 buffer busy waits 147 92431 Concurrency
4 buffer busy waits 147 92431 Concurrency
4 buffer busy waits 147 92431 Concurrency
5 gc current block busy 147 92554 Cluster
4 gc current block busy 147 92556 Cluster
4 gc current block busy 147 92564 Cluster
5 gc current block busy 147 92596 Cluster
4 buffer busy waits 147 92839 Concurrency
4 buffer busy waits 147 92839 Concurrency
4 buffer busy waits 147 92839 Concurrency
4 buffer busy waits 147 92839 Concurrency
4 gc current block 2-way 147 93004 Cluster
4 gc current block busy 1 94673 Cluster
4 enq: TX - index contention 1.42E+09 29622275 Concurrency
4 enq: TX - index contention 1.42E+09 29753347 Concurrency
4 enq: TX - index contention 1.42E+09 31916054 Concurrency
5 enq: TX - index contention 1.42E+09 46596103 Concurrency
5 enq: TX - index contention 1.42E+09 46596103 Concurrency
5 enq: TX - index contention 1.42E+09 95354892 Concurrency
4 library cache lock 5.53E+10 5.52E+10 Concurrency
4 library cache: mutex X 2.18E+09 1.84E+13 Concurrency
4 library cache: mutex X 4.23E+09 2.38E+13 Concurrency
4 library cache: mutex X 4.23E+09 2.38E+13 Concurrency
4 library cache: mutex X 4.23E+09 2.38E+13 Concurrency
The output from the query above (output formatted for legibility) indicates data files 145,146,147,148,149,150,
and 151 are accessed several times and several blocks are repeatedly accessed between instances. Different file
numbers indicate that there are several data files involved in the operation; verifying against V$DATAFILE , you see that
all these files belong to the same tablespace.
SQL> SELECT ts#,
file#,
name
FROM v$datafile
WHERE file# IN ( 145, 146, 147, 148,
149, 150, 151 );
TS# FILE# NAME
-------- -------- ----------------------------------------------
16 145 +SSKYDB__DATA/SSKYDB/datafile/data08.dbf
16 146 +SSKYDB__DATA/SSKYDB/datafile/data09.dbf
16 147 +SSKYDB__DATA/SSKYDB/datafile/data10.dbf
16 148 +SSKYDB__DATA/SSKYDB/datafile/data11.dbf
16 149 +SSKYDB__DATA/SSKYDB/datafile/data12.dbf
16 150 +SSKYDB__DATA/SSKYDB/datafile/data13.dbf
16 151 +SSKYDB__DATA/SSKYDB/datafile/data14.dbf
 
Search WWH ::




Custom Search