V$WAITSTAT视图

msdnchina

于 2017-07-12 21:22:41 发布

阅读量702

点赞数

CC 4.0 BY-SA版权

文章标签： VWAITSTAT block type class

本文链接：https://blog.youkuaiyun.com/msdnchina/article/details/75041308

Oracle DB 专栏收录该内容

772 篇文章

订阅专栏

V$WAITSTAT displays block contention statistics. This table is only updated when timed statistics are enabled.


Column	Datatype	Description
CLASS	VARCHAR2(18)	Class of the block
COUNT	NUMBER	        Number of waits by this OPERATION for this CLASS of block
TIME	NUMBER	        Sum of all wait times for all the waits by this OPERATION for this CLASS of block

[oracle@test ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.5.0 - Production on Mon Jul 10 09:17:37 2017

Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area  281018368 bytes
Fixed Size		    2095672 bytes
Variable Size		  150996424 bytes
Database Buffers	  121634816 bytes
Redo Buffers		    6291456 bytes
Database mounted.
Database opened.
SQL> desc v$waitstat ;
 Name					   Null?    Type
 ----------------------------------------- -------- ----------------------------
 CLASS						    VARCHAR2(18)
 COUNT						    NUMBER
 TIME						    NUMBER

SQL> set pages 300
SQL> select * from v$waitstat;  

CLASS			COUNT	    TIME
------------------ ---------- ----------
data block		   12	      16
sort block		    0	       0
save undo block 	    0	       0
segment header		    0	       0
save undo header	    0	       0
free list		    0	       0
extent map		    0	       0
1st level bmb		    0	       0
2nd level bmb		    0	       0
3rd level bmb		    0	       0
bitmap block		    0	       0
bitmap index block	    0	       0
file header block	    2	       1
unused			    0	       0
system undo header	    0	       0
system undo block	    0	       0
undo header		    0	       0
undo block		    0	       0

18 rows selected.

SQL> select * from v$waitstat order by class;

CLASS			COUNT	    TIME
------------------ ---------- ----------
1st level bmb		    0	       0
2nd level bmb		    0	       0
3rd level bmb		    0	       0
bitmap block		    0	       0
bitmap index block	    0	       0
data block		   12	      16
extent map		    0	       0
file header block	    2	       1
free list		    0	       0
save undo block 	    0	       0
save undo header	    0	       0
segment header		    0	       0
sort block		    0	       0
system undo block	    0	       0
system undo header	    0	       0
undo block		    0	       0
undo header		    0	       0
unused			    0	       0

18 rows selected.

SQL>