15、V$SYSSTAT V$SGA V$ROLLSTAT V@FILESTAT

记录几个视图的用处

[@more@]

1、V$SYSSTAT

The view contains instance-wide information regarding rollback segment,datafile I/O,parse data,and so on.

To locate information regareding memory-related problems in the database, you can use this view.

2、V$SGA

The view only contain information regarding the distribution of SGA memory into different SGA components.

3、V$SESSION

The view displays session-specific information

4、V$ROLLSTAT

The view contains information specific to rollback segments

5、V$FILESTAT

The view contains detailed I/O information specific to each datafile,including the number of I/Os on each file.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/248644/viewspace-931024/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/248644/viewspace-931024/