oracle创建视图对性能的影响,oracle几个不常用但是会对性能有提升的视图

一、DBA_TABLESPACE_USAGE_METRICS

DBA_TABLESPACE_USAGE_METRICS describes tablespace usage metrics for all types of

tablespaces, including permanent, temporary, and undo tablespaces.

通过这个视图可以直接查出表空间的使用率。

二、V$ASM_DISKGROUP_STAT

V$ASM_DISKGROUP_STAT displays performance statistics in the same way that V$ASM_

DISKGROUP does, but without performing discovery of new disk groups. This results in

a less expensive operation. However, since discovery is not performed, the output of

this view does not include any data about disk groups that are new to the system.

三、V$ASM_DISK_STAT

V$ASM_DISK_STAT displays performance statistics in the same way that V$ASM_DISK

does, but without performing discovery of new disks. This results in a less expensive

operation. However, since discovery is not performed, the output of this view does not

include any data about disks that are new to the system.

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