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.
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博客 ” ，链接：https://blog.itpub.net/29802484/viewspace-2135237/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
python3.x的异常处理
下一篇：
分区表之间隔分区（interval）
请登录后发表评论
登录
全部评论
