ITPub博客

首页 > 应用开发 > IT综合 > 15、V$SYSSTAT V$SGA V$ROLLSTAT V@FILESTAT

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

原创 IT综合 作者:yyycxhtx 时间:2007-08-03 09:28:40 0 删除 编辑

记录几个视图的用处

[@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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
  • 博文量
    39
  • 访问量
    57701