Query V$WAITSTAT for resource wait statistics. : V_Waitstat « System Tables Views « Oracle PL / SQL

1. Oracle PL / SQL
2. System Tables Views
3. V_Waitstat

Query V$WAITSTAT for resource wait statistics.

 


SQL>
SQL> select Class,
  2         Count
  3    from V$WAITSTAT;



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

18 rows selected.

SQL>

   
  

Related examples in the same category