相关链接

Oracle 脚本-查看物理读最多的对象

```sql
SQL> select *
  2   from(select owner, object_name,value
  3           from v$segment_statistics
  4          where statistic_name ='physical reads'
  5          order by value desc)
  6  where rownum<=10 ;

OWNER                          OBJECT_NAME                         VALUE
------------------------------ ------------------------------ ----------
SYS                            TYPE$                                2914
SYS                            IND$                                 1438
SYS                            IDL_UB1$                             1359
XDB                            XDB$RESOURCE                         1019
SYS                            OBJ$                                  936
SYS                            I_WRI$_OPTSTAT_H_ST                   895
SYS                            I_OBJ2                                760
SYS                            HISTGRM$                              617
SYS                            WRH$_SYSMETRIC_HISTORY_INDEX          561
SYS                            WRH$_SQL_PLAN                         515

10 rows selected 
```

上一篇：Oracle 脚本 -查看前十个热点文件|下一篇：Oracle脚本-查看那些用户有DBA权限