该博客详细检查了一个Oracle数据库的健康状况，重点关注了表空间碎片过多的问题。检查内容包括数据库概要、参数文件、控制文件状态、表空间和数据文件、重做日志文件、内存分配、Library Cache和Data Dictionary的命中率、共享池建议、DB Buffer Cache的命中率、磁盘排序情况、Log Buffer latch Contention、表空间使用情况、I/O分布、等待事件、数据库大小、长事务、物理读取等。此外，还提供了数据库版本、组件、用户、角色、权限、索引、锁和闪回模式等信息。
Oralce Database Health Check (Performance)
--------------------------------------------------------------------------------
List Contents
1. 数据库概要
2. 参数文件(是spfile还是pfile)
3. 非默认的参数
4. 控制文件及其状态
5. 表空间及数据文件
6. 重做日志文件信息
7. 内存分配概况
8. Library Cache Reload Ratio(<1%)
9. Data Dictionary Miss Ratio(<15%)
10. 共享池建议
11. DB Buffer Cache(Default) Hit Ratio(>90%)
12. DB Buffer Cache Advice
13. 磁盘排序(<5%)
14. Log Buffer latch Contention(<1%)
15. 表空间状态及其大小使用情况
16. 数据文件状态及其大小使用情况
17. 不使用临时文件的临时表空间
18. 无效的数据文件(offline)
19. 处于恢复模式的文件
20. 含有50个以上的Extent且30%以上碎片的表空间
21. 表空间上的I/O分布
22. 数据文件上的I/O分布
23. Next Extent 相对于段当前已分配字节过大(>=2倍)或过小(<10%)的Segments
24. Max Extents(>1)已经有90%被使用了的Segments
25. 已经分配超过100 Extents的Segments
26. 因表空间空间不够将导致不能扩展的Objects
27. 没有主键的非系统表
28. 没有索引的外键
29. 建有6个以上索引的非系统表
30. 指向对象不存在的Public同义词
31. 指向对象不存在的非Public同义词
32. 没有授予给任何角色和用户的角色
33. 将System表空间作为临时表空间的用户(除Sys外)
34. 将System表空间作为默认表空间的用户(除Sys外)
35. 没有授予给任何用户的profiles
36. 没有和Package相关联的Package Body
37. 被Disabled的约束
38. 被Disabled的触发器
39. Invalid Objects
40. 执行失败或中断的Jobs
41. 当前未执行且下一执行日期已经过去的Jobs
42. 含有未分析的非系统表的Schemas
43. 含有未分析的非系统分区表的Schemas
44. 含有未分析的非系统索引的Schemas
45. 含有未分析的非系统分区索引的Schemas
46. 死锁检测
47. top I/O Wait
48. top 10 wait
49. Top 10 bad SQL
50. Top most expensive SQL (Buffer Gets by Executions)
51. Top most expensive SQL (Physical Reads by Executions)
52. Top most expensive SQL (Rows Processed by Executions)
53. Top most expensive SQL (Buffer Gets vs Rows Processed)
54. 数据库版本信息
55. 数据库组件(true:已安装，false：未安装)
56. 实例信息
57. 数据库临时文件状态
58. 表空间空闲块查询
59. 表空间碎片化程度分析（FSFI<30,破碎化程度高）
60. 回滚段空间配置
61. NLS参数设置
62. 用户角色查询
63. 最近7日联机日志切换频度
64. 表和索引在同一表空间（不包含USERS,SYSAUX,SYSMAN,SYSTEM,TEMP 表空间）
65. TOP 10 等待事件
66. 数据缓冲区高速缓存
67. 重做日至缓冲区
68. 数据字典高速缓存
69. 库高速缓存
70. 排序（磁盘/内存）
71. 单个用户大小估算
72. 系统表空间中非SYS的对象
73. 可传输表空间支持的操作系统和字节顺序
74. 锁信息
75. 具有dba角色用户
76. 具有sysdba权限用户
77. 检测system表空间里的用户对象
78. 已装载的产品选项
79. 数据库session连接数
80. 数据库的并发数
81. 最近7天归档日志的生成频率
82. 未建索引的表（不包含表空间为'SYSTEM', 'SYSAUX', 'SYSMAN', 'USERS', 'TEMP'下的用户）
83. sort_segment检查
84. 数据库总大小（Gb）
85. 超过2g的segment（单个表超过2g建议使用分区表）
86. 数据库长事务（执行超过6s）
87. 产生大量物理读的进程
88. 产生归档日志过快的进程
89. 等待事件对应的sql语句
90. 占用大量temp表空间的session和sql监控
91. 数据库服务器运行的操作系统
92. SGA Memory Map (overall)
93. SGA Memory Map (shared pool)
94. 定时任务（job）
95. 数据库dbid
96. 闪回模式的是否启动
97. rollback信息
98. 回滚段的争用情况
99. session等待事件
1. 数据库概要
DB Name Global Name Host Name Instance Name Restricted Mode Archive Log Mode
HDCARDS HDCARDS.REGRESS.RDBMS.DEV.US.ORACLE.COM FLEX3 hdcards NO ARCHIVELOG
1 rows selected.
Top
2. 参数文件(是spfile还是pfile)
Parameter_File
D:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE\SPFILEHDCARDS.ORA
1 rows selected.
Top
3. 非默认的参数
NAME pvalue
audit_file_dest D:\ORACLE\PRODUCT\10.2.0\ADMIN\HDCARDS\ADUMP
background_dump_dest D:\ORACLE\PRODUCT\10.2.0\ADMIN\HDCARDS\BDUMP
compatible 10.2.0.1.0
control_files E:\ORADATA\HDCARDS\CONTROL01.CTL, E:\ORADATA\HDCARDS\CONTROL02.CTL, E:\ORADATA\HDCARDS\CONTROL03.CTL
core_dump_dest D:\ORACLE\PRODUCT\10.2.0\ADMIN\HDCARDS\CDUMP
db_block_size 8192
db_domain
db_file_multiblock_read_count 8
db_name hdcards
dispatchers (PROTOCOL=TCP) (SERVICE=hdcardsXDB)
job_queue_processes 10
log_archive_dest_1 LOCATION=e:\oradata\hdcards\archive
log_archive_format ARC%S_%R.%T
nls_language SIMPLIFIED CHINESE
nls_territory CHINA
open_cursors 1000
pga_aggregate_target 2147483648
processes 2000
remote_login_passwordfile EXCLUSIVE
session_cached_cursors 1000
sessions 2205
sga_max_size 8589934592
sga_target 8589934592
undo_management AUTO
undo_tablespace UNDOTBS1
user_dump_dest D:\ORACLE\PRODUCT\10.2.0\ADMIN\HDCARDS\UDUMP
26 rows selected.
Top
4. 控制文件及其状态
NAME STATUS
E:\ORADATA\HDCARDS\CONTROL01.CTL
E:\ORADATA\HDCARDS\CONTROL02.CTL
E:\ORADATA\HDCARDS\CONTROL03.CTL
3 rows selected.
Top
5. 表空间及数据文件
TABLESPACE_NAME FILE_NAME Total Size(MB) Auto
HDCARDS E:\ORADATA\HDCARDS\HDCARDS01.DBF 2048 NO
HDCARDS E:\ORADATA\HDCARDS\HDCARDS02.DBF 2048 NO
HDCARDS E:\ORADATA\HDCARDS\HDCARDS03.DBF 2048 NO
HDCARDS E:\ORADATA\HDCARDS\HDCARDS04.DBF 2048 NO
HDCARDS E:\ORADATA\HDCARDS\HDCARDS05.DBF 2048 NO
HDCARDS E:\ORADATA\HDCARDS\HDCARDS06.DBF 2000 NO
HDCARDS E:\ORADATA\HDCARDS\HDCARDS07.DBF 2000 NO
HDCARDS E:\ORADATA\HDCARDS\HDCARDS08.DBF 2000 NO
HDCARDS E:\ORADATA\HDCARDS\HDCARDS09.DBF 2000 NO
HDCARDS E:\ORADATA\HDCARDS\HDCARDS10.DBF 2000 NO
HDCARDS E:\ORADATA\HDCARDS\HDCARDS11.DBF 2000 NO
HDCARDS E:\ORADATA\HDCARDS\HDCARDS12.DBF 2000 NO
HDCARDS E:\ORADATA\HDCARDS\HDCARDS13.DBF 2000 NO
HDCARDS E:\ORADATA\HDCARDS\HDCARDS14.DBF 2000 NO
HDCARDS E:\ORADATA\HDCARDS\HDCARDS15.DBF 2000 NO
HDCARDS E:\ORADATA\HDCARDS\HDCARDS16.DBF 2000 NO
HDCARDS E:\ORADATA\HDCARDS\HDCARDS17.DBF 2000 NO
HDCARDS E:\ORADATA\HDCARDS\HDCARDS18.DBF 2000 NO
HDCARDS E:\ORADATA\HDCARDS\HDCARDS19.DBF 2000 NO
HDCARDS E:\ORADATA\HDCARDS\HDCARDS20.DBF 2000 NO
SYSAUX E:\ORADATA\HDCARDS\SYSAUX01.DBF 700 YES
SYSTEM E:\ORADATA\HDCARDS\SYSTEM01.DBF 530 YES
UNDOTBS1 E:\ORADATA\HDCARDS\UNDOTBS01.DBF 2400 YES
USERS E:\ORADATA\HDCARDS\USERS01.DBF 5 YES
24 rows selected.
Top
6. 重做日志文件信息
GROUP# Redo File TYPE STATUS Size(MB)
8 E:\ORADATA\HDCARDS\REDO08.LOG ONLINE INACTIVE 100
7 E:\ORADATA\HDCARDS\REDO07.LOG ONLINE INACTIVE 100
6 E:\ORADATA\HDCARDS\REDO06.LOG ONLINE INACTIVE 100
5 E:\ORADATA\HDCARDS\REDO05.LOG ONLINE INACTIVE 100
4 E:\ORADATA\HDCARDS\REDO04.LOG ONLINE INACTIVE 100
3 E:\ORADATA\HDCARDS\REDO03.LOG ONLINE INACTIVE 100
2 E:\ORADATA\HDCARDS\REDO02.LOG ONLINE INACTIVE 100
1 E:\ORADATA\HDCARDS\REDO01.LOG ONLINE CURRENT 100
8 rows selected.
Top
7. 内存分配概况
NAME value(Byte)
Fixed Size 2079480
Variable Size 788530440
Database Buffers 7784628224
Redo Buffers 14696448
lock_sga FALSE
large_pool_size 0
java_pool_size 0
7 rows selected.
Top
8. Library Cache Reload Ratio(<1%)
LC_Reload_Ratio%
1.2895
1 rows selected.
Top
9. Data Dictionary Miss Ratio(<15%)
DC_Miss_Ratio%
0.6028
1 rows selected.
Top
10. 共享池建议
Shared Pool Size(estimate) Factor Libarary Cache Size time Saved
400 0.5556 90 18305256
480 0.6667 165 18336103
560 0.7778 243 18363914
640 0.8889 322 18391677
720 1 399 18419375
800 1.1111 458 18446996
880 1.2222 503 18474534
960 1.3333 548 18501989
1040 1.4444 593 18529363
1120 1.5556 638 18556663
1200 1.6667 683 18583895
1280 1.7778 728 18611068
1360 1.8889 769 18638191
1440 2 792 18665273
14 rows selected.
Top
11. DB Buffer Cache(Default) Hit Ratio(>90%)
BC_Hit_Ratio
91.8081
1 rows selected.
Top
12. DB Buffer Cache Advice
Pool Name BLOCK_SIZE Buffer Size Factor Phy_Read_Factor ESTD_PHY_READS
DEFAULT 8192 736 0.0991 1.3257 101015787
DEFAULT 8192 1472 0.1983 1.2267 93473993
DEFAULT 8192 2208 0.2974 1.1821 90069574
DEFAULT 8192 2944 0.3966 1.1451 87255536
DEFAULT 8192 3680 0.4957 1.1115 84692047
DEFAULT 8192 4416 0.5948 1.081 82370607
DEFAULT 8192 5152 0.694 1.0511 80092067
DEFAULT 8192 5888 0.7931 1.0286 78379772
DEFAULT 8192 6624 0.8922 1.0117 77086286
DEFAULT 8192 7360 0.9914 1.0009 76268668
DEFAULT 8192 7424 1 1 76196812
DEFAULT 8192 8096 1.0905 0.9901 75441141
DEFAULT 8192 8832 1.1897 0.9767 74417992
DEFAULT 8192 9568 1.2888 0.9455 72047610
DEFAULT 8192 10304 1.3879 0.9265 70596739
DEFAULT 8192 11040 1.4871 0.9078 69168824
DEFAULT 8192 11776 1.5862 0.8733 66539663
DEFAULT 8192 12512 1.6853 0.8509 64836665
DEFAULT 8192 13248 1.7845 0.8184 62359630
DEFAULT 8192 13984 1.8836 0.742 56537835
DEFAULT 8192 14720 1.9828 0.5479 41747795
21 rows selected.
Top
13. 磁盘排序(<5%)
Sort(Disk) Sort(Memory) Disk_Sort_Ratio％
177 6671021 0
1 rows selected.
Top
14. Log Buffer latch Contention(<1%)
Redo Name GETS MISSES IMMEDIATE_GETS IMMEDIATE_MISSES Miss_Ratio％ Immediate Misses Ratio%
redo copy 1600 0 52720847 30599 0 0.058
redo allocation 19437130 3171 52712215 21332 0.016 0.04
2 rows selected.
Top
15. 表空间状态及其大小使用情况
Name Status Type Size (MB) Used (MB) Used％
UNDOTBS1 ONLINE UNDO 2,400.000 167.875 6.99
SYSAUX ONLINE PERMANENT 700.000 661.000 94.43
USERS ONLINE PERMANENT 5.000 1.688 33.75
HDCARDS ONLINE PERMANENT 40,240.000 33,315.750 82.79
SYSTEM ONLINE PERMANENT 530.000 520.125 98.14
TEMP ONLINE TEMPORARY 0.000 0.000 0.00
6 rows selected.
Top
16. 数据文件状态及其大小使用情况
TableSpace Name File Name Status Auto Size (MB) Used (MB) Used %
HDCARDS E:\ORADATA\HDCARDS\HDCARDS01.DBF AVAILABLE NO 2,048.000 2,014.500 98.36
HDCARDS E:\ORADATA\HDCARDS\HDCARDS02.DBF AVAILABLE NO 2,048.000 2,005.438 97.92
HDCARDS E:\ORADATA\HDCARDS\HDCARDS03.DBF AVAILABLE NO 2,048.000 2,002.375 97.77
HDCARDS E:\ORADATA\HDCARDS\HDCARDS04.DBF AVAILABLE NO 2,048.000 2,005.250 97.91
HDCARDS E:\ORADATA\HDCARDS\HDCARDS05.DBF AVAILABLE NO 2,048.000 2,001.500 97.73
HDCARDS E:\ORADATA\HDCARDS\HDCARDS06.DBF AVAILABLE NO 2,000.000 1,874.438 93.72
HDCARDS E:\ORADATA\HDCARDS\HDCARDS07.DBF AVAILABLE NO 2,000.000 1,890.563 94.53
HDCARDS E:\ORADATA\HDCARDS\HDCARDS08.DBF AVAILABLE NO 2,000.000 1,893.313 94.67
HDCARDS E:\ORADATA\HDCARDS\HDCARDS09.DBF AVAILABLE NO 2,000.000 1,992.063 99.60
HDCARDS E:\ORADATA\HDCARDS\HDCARDS10.DBF AVAILABLE NO 2,000.000 1,994.063 99.70
HDCARDS E:\ORADATA\HDCARDS\HDCARDS11.DBF AVAILABLE NO 2,000.000 1,992.063 99.60
HDCARDS E:\ORADATA\HDCARDS\HDCARDS12.DBF AVAILABLE NO 2,000.000 1,995.000 99.75
HDCARDS E:\ORADATA\HDCARDS\HDCARDS13.DBF AVAILABLE NO 2,000.000 1,995.000 99.75
HDCARDS E:\ORADATA\HDCARDS\HDCARDS14.DBF AVAILABLE NO 2,000.000 1,994.750 99.74
HDCARDS E:\ORADATA\HDCARDS\HDCARDS15.DBF AVAILABLE NO 2,000.000 1,994.625 99.73
HDCARDS E:\ORADATA\HDCARDS\HDCARDS16.DBF AVAILABLE NO 2,000.000 1,478.563 73.93
HDCARDS E:\ORADATA\HDCARDS\HDCARDS17.DBF AVAILABLE NO 2,000.000 820.063 41.00
HDCARDS E:\ORADATA\HDCARDS\HDCARDS18.DBF AVAILABLE NO 2,000.000 716.063 35.80
HDCARDS E:\ORADATA\HDCARDS\HDCARDS19.DBF AVAILABLE NO 2,000.000 364.063 18.20
HDCARDS E:\ORADATA\HDCARDS\HDCARDS20.DBF AVAILABLE NO 2,000.000 292.063 14.60
SYSAUX E:\ORADATA\HDCARDS\SYSAUX01.DBF AVAILABLE YES 700.000 661.000 94.43
SYSTEM E:\ORADATA\HDCARDS\SYSTEM01.DBF AVAILABLE YES 530.000 520.125 98.14
UNDOTBS1 E:\ORADATA\HDCARDS\UNDOTBS01.DBF AVAILABLE YES 2,400.000 167.875 6.99
USERS E:\ORADATA\HDCARDS\USERS01.DBF AVAILABLE YES 5.000 1.688 33.75
24 rows selected.
Top
17. 不使用临时文件的临时表空间
TABLESPACE_NAME CONTENTS
0 rows selected.
Top
18. 无效的数据文件(offline)
TABLESPACE_NAME FILE_NAME STATUS
0 rows selected.
Top
19. 处于恢复模式的文件
TABLESPACE_NAME FILE_NAME
0 rows selected.
Top
20. 含有50个以上的Extent且30%以上碎片的表空间
TABLESPACE_NAME PCT_FRAGMENTED SEGMENTS HOLES
HDCARDS 74 163 465
1 rows selected.
Top
21. 表空间上的I/O分布
TS_NAME FILE_NAME PHY_READS PHY_BLOCKREADS PHY_WRITES PHY_BLOCKWRITES
HDCARDS E:\ORADATA\HDCARDS\HDCARDS02.DBF 2522628 13920290 923524 942042
HDCARDS E:\ORADATA\HDCARDS\HDCARDS03.DBF 2488428 13802338 858229 876130
HDCARDS E:\ORADATA\HDCARDS\HDCARDS01.DBF 2438806 13691600 939381 958303
HDCARDS E:\ORADATA\HDCARDS\HDCARDS04.DBF 2434843 13766881 916956 936866
HDCARDS E:\ORADATA\HDCARDS\HDCARDS05.DBF 2431652 13595399 939909 959904
HDCARDS E:\ORADATA\HDCARDS\HDCARDS16.DBF 2303409 11843800 512047 1446520
HDCARDS E:\ORADATA\HDCARDS\HDCARDS17.DBF 2216613 11582194 524711 1460025
HDCARDS E:\ORADATA\HDCARDS\HDCARDS06.DBF 1989662 12612560 397354 437064
HDCARDS E:\ORADATA\HDCARDS\HDCARDS18.DBF 1957941 10833293 417336 1341636
HDCARDS E:\ORADATA\HDCARDS\HDCARDS07.DBF 1770892 12134286 516892 556000
HDCARDS E:\ORADATA\HDCARDS\HDCARDS08.DBF 1678349 11710796 404673 434382
HDCARDS E:\ORADATA\HDCARDS\HDCARDS09.DBF 1537244 11285308 417842 561438
HDCARDS E:\ORADATA\HDCARDS\HDCARDS10.DBF 1380919 10494486 385632 543934
HDCARDS E:\ORADATA\HDCARDS\HDCARDS14.DBF 1275218 10211198 313820 471805
HDCARDS E:\ORADATA\HDCARDS\HDCARDS11.DBF 1269520 10163826 344521 461255
HDCARDS E:\ORADATA\HDCARDS\HDCARDS13.DBF 1224816 10182974 366853 503696
HDCARDS E:\ORADATA\HDCARDS\HDCARDS15.DBF 1201832 10100457 283491 415943
HDCARDS E:\ORADATA\HDCARDS\HDCARDS12.DBF 1192771 10102615 422932 506934
HDCARDS E:\ORADATA\HDCARDS\HDCARDS19.DBF 1107998 6487504 163964 769091
HDCARDS E:\ORADATA\HDCARDS\HDCARDS20.DBF 1075565 6419941 140192 731071
SYSAUX E:\ORADATA\HDCARDS\SYSAUX01.DBF 283964 3155251 510215 666839
UNDOTBS1 E:\ORADATA\HDCARDS\UNDOTBS01.DBF 155849 9227849 649232 3248147
SYSTEM E:\ORADATA\HDCARDS\SYSTEM01.DBF 99446 2121930 102096 140958
USERS E:\ORADATA\HDCARDS\USERS01.DBF 893 19835 556 556
24 rows selected.
Top
22. 数据文件上的I/O分布
Table Space File Name Phys Rds % Phys Rds Phys Wrts % Phys Wrts
SYSTEM E:\ORADATA\HDCARDS\SYSTEM01.DBF 99446 0.28 102096 0.89
UNDOTBS1 E:\ORADATA\HDCARDS\UNDOTBS01.DBF 155849 0.43 649232 5.67
SYSAUX E:\ORADATA\HDCARDS\SYSAUX01.DBF 283964 0.79 510215 4.46
USERS E:\ORADATA\HDCARDS\USERS01.DBF 893 0 556 0
HDCARDS E:\ORADATA\HDCARDS\HDCARDS01.DBF 2438806 6.77 939381 8.2
HDCARDS E:\ORADATA\HDCARDS\HDCARDS02.DBF 2522628 7 923524 8.06
HDCARDS E:\ORADATA\HDCARDS\HDCARDS03.DBF 2488428 6.9 858229 7.49
HDCARDS E:\ORADATA\HDCARDS\HDCARDS04.DBF 2434843 6.76 916956 8.01
HDCARDS E:\ORADATA\HDCARDS\HDCARDS05.DBF 2431652 6.75 939909 8.21
HDCARDS E:\ORADATA\HDCARDS\HDCARDS06.DBF 1989662 5.52 397354 3.47
HDCARDS E:\ORADATA\HDCARDS\HDCARDS07.DBF 1770892 4.91 516892 4.51
HDCARDS E:\ORADATA\HDCARDS\HDCARDS08.DBF 1678349 4.66 404673 3.53
HDCARDS E:\ORADATA\HDCARDS\HDCARDS09.DBF 1537244 4.27 417842 3.65
HDCARDS E:\ORADATA\HDCARDS\HDCARDS10.DBF 1380919 3.83 385632 3.37
HDCARDS E:\ORADATA\HDCARDS\HDCARDS11.DBF 1269520 3.52 344521 3.01
HDCARDS E:\ORADATA\HDCARDS\HDCARDS12.DBF 1192771 3.31 422932 3.69
HDCARDS E:\ORADATA\HDCARDS\HDCARDS13.DBF 1224816 3.4 366853 3.2
HDCARDS E:\ORADATA\HDCARDS\HDCARDS14.DBF 1275218 3.54 313820 2.74
HDCARDS E:\ORADATA\HDCARDS\HDCARDS15.DBF 1201832 3.33 283491 2.48
HDCARDS E:\ORADATA\HDCARDS\HDCARDS16.DBF 2303409 6.39 512047 4.47
HDCARDS E:\ORADATA\HDCARDS\HDCARDS17.DBF 2216613 6.15 524711 4.58
HDCARDS E:\ORADATA\HDCARDS\HDCARDS18.DBF 1957941 5.43 417336 3.64
HDCARDS E:\ORADATA\HDCARDS\HDCARDS19.DBF 1107998 3.07 163964 1.43
HDCARDS E:\ORADATA\HDCARDS\HDCARDS20.DBF 1075565 2.98 140192 1.22
24 rows selected.
Top
23. Next Extent 相对于段当前已分配字节过大(>=2倍)或过小(<10%)的Segments
Type OWNER SEGMENT_NAME BYTES NEXT_EXTENT Percent(Next/Bytes)
0 rows selected.
Top
24. Max Extents(>1)已经有90%被使用了的Segments
SEGMENT_TYPE OWNER SEGMENT_NAME TABLESPACE_NAME PARTITION_NAME Size(MB) EXTENTS MAX_EXTENTS
0 rows selected.
Top
25. 已经分配超过100 Extents的Segments
SEGMENT_TYPE OWNER SEGMENT_NAME EXTENTS PARTITION_NAME
TABLE HDCARDCTSZS CCMEMBERACCOUNT 210
INDEX HDCARDCTSZS SYS_C005229 107
TABLE HDCARDCTSZS CARDINFO 221
INDEX HDCARDCTSZS SYS_C005250 128
TABLE HDCARDCTSZS DESACCOUNT 174
INDEX HDCARDCTSZS SYS_C005257 136
TABLE HDCARDCTSZS DESACCOUNTCHECK 220
INDEX HDCARDCTSZS SYS_C005265 137
TABLE HDCARDCTSZS SCOSUBJECTACCOUNT 163
INDEX HDCARDCTSZS SYS_C005293 142
TABLE HDCARDCTSZS SCOSUBJECTACCOUNTCHECK 214
INDEX HDCARDCTSZS SYS_C005300 276
INDEX HDCARDCTSZS IDX_CARDINFO_1 108
INDEX HDCARDCTSZS IDX_SCOSUBJECTACCOUNT_1 117
INDEX HDCARDCTSZS IDX_SCOSUBJECTACCOUNTCHECK_1 167
INDEX HDCARDCTSZS IDX_CCMEMBERACCOUNT_ID 101
INDEX HDCARDCTSZS IDX_CARDINFO_ACCOUNTNO 141
INDEX HDCARDCTSZS INDEX_CARDINFO_LASTMODIFYTIME 158
TABLE HDCARDHQSZS CARDINFO 213
INDEX HDCARDHQSZS SYS_C005329 130
TABLE HDCARDHQSZS DESACCOUNT 163
INDEX HDCARDHQSZS SYS_C005336 131
TABLE HDCARDHQSZS DESACCOUNTCHECK 216
INDEX HDCARDHQSZS SYS_C005344 133
INDEX HDCARDHQSZS IDX_CARDINFO_1 103
INDEX HDCARDHQSZS IDX_CARDINFO_ACCOUNTNO 132
INDEX HDCARDHQSZS INDEX_CARDINFO_LASTMODIFYTIME 105
TABLE HDCARDCTSZS CARDUSEMRPT 127
TABLE HDCARDCTSZS HCCMEMBER_0311 212
TABLE HDCARDCTSZS HCCCARDMEMBER_0311 114
INDEX HDCARDHQSZS IDX_DESACCOUNTCHECK_1 131
INDEX HDCARDCTSZS IDX_DESACCOUNTCHECK_1 134
TABLE HDCARDCTSZS SCOSUBJECTACCOUNT_20130411 104
INDEX HDCARDCTSZS IDX_MEMBERACCOUNT_DESANDSTATE 112
TABLE HDCARDCTSZS HCCMEMBER_0326 213
TABLE HDCARDCTSZS HCCCARDMEMBER_0326 114
INDEX HDCARDCTSZS IDX_CARDINFO_MEMBERUUID 101
TABLE HDCARDCTSZS CARDINFO_BAK_20140214 214
38 rows selected.
Top
26. 因表空间空间不够将导致不能扩展的Objects
TABLESPACE_NAME OWNER Segment Name EXTENTS NEXT_EXTENT_KB TS_FREE_KB TS_GROWTH_MB
0 rows selected.
Top
27. 没有主键的非系统表
OWNER TABLE_NAME
DMSYS DM$P_MODEL
DMSYS DM$P_MODEL_TABLES
EXFSYS EXF$DEFIDXPARAM
EXFSYS EXF$ESETIDXPARAM
EXFSYS EXF$JAVAMSG
EXFSYS EXF$PREDATTRMAP
EXFSYS EXF$VALIDIOPER
EXFSYS EXF$VALIDPRIVS
EXFSYS EXF$VERSION
EXFSYS RLM$PARSEDCOND
EXFSYS RLM$SCHACTLIST
EXFSYS SYS_IOT_OVER_40415
EXFSYS SYS_IOT_OVER_42451
EXFSYS SYS_IOT_OVER_42458
EXFSYS SYS_IOT_OVER_42465
EXFSYS SYS_IOT_OVER_42468
EXFSYS SYS_IOT_OVER_42487
EXFSYS SYS_IOT_OVER_42490
EXFSYS SYS_IOT_OVER_42493
EXFSYS SYS_IOT_OVER_42496
HDCARDCTSZS CARDINFO_BAK_20140214
HDCARDCTSZS CARDINFO_BAK_2014021401
HDCARDCTSZS CARDINFO_IMP
HDCARDCTSZS CARDINFO_IMPNEW
HDCARDCTSZS CARDUSEMRPT
HDCARDCTSZS CCMEMBERACCOUNT_1
HDCARDCTSZS DESACCOUNTCHECK_IMPNEW
HDCARDCTSZS DESACCOUNT_IMP
HDCARDCTSZS DESACCOUNT_IMPNEW
HDCARDCTSZS HCCCARDMEMBER_0326
HDCARDCTSZS HCCMEMBER_0326
HDCARDCTSZS HCCMEMBER_0326_1
HDCARDCTSZS IMPDATARESULT
HDCARDCTSZS IMPTEMPINFO
HDCARDCTSZS SCOSUBJECTACCOUNTCHECK_IMPNEW
HDCARDCTSZS SCOSUBJECTACCOUNT_20130411
HDCARDCTSZS SCOSUBJECTACCOUNT_IMP
HDCARDCTSZS SCOSUBJECTACCOUNT_IMPNEW
HDCARDCTSZS TABLE_SCORE1
HDCARDCTSZS TABLE_SCORE2
HDCARDCTSZS TEMPIMPINFO
HDCARDCTSZS TEMP_0411
HDCARDCTSZS TEMP_0626
HDCARDCTSZS TEMP_SCOSUBJECTACCOUNT_0411
HDCARDCTSZS TEMP_SCOSUBJECTACCOUNT_0626
HDCARDCTSZS TMP_CARDNUMRETAIL
HDCARDCTSZS TMP_CARDNUMRETAIL1
HDCARDCTSZS TMP_SCOREDIFF_0713
HDCARDCTSZS TMP_SCOREDIFF_0715
HDCARDCTSZS TMP_TABLE_1
HDCARDCTSZS WXF_ANALYZE_LOG
HDCARDHQSZS CARDINFO_IMP
HDCARDHQSZS CARDINFO_IMPNEW
HDCARDHQSZS DESACCOUNTCHECK_IMPNEW
HDCARDHQSZS DESACCOUNT_IMP
HDCARDHQSZS DESACCOUNT_IMPNEW
HDCARDHQSZS IMPDATARESULT
HDCARDHQSZS IMPINFO
HDCARDHQSZS IMPINFONEW
HDCARDHQSZS IMPINFO_BAK
HDCARDHQSZS IMPINFO_BAK1
HDCARDHQSZS IMPINFO_SCORE
HDCARDHQSZS IMPINFO_ZHENGSHI
HDCARDHQSZS SCOSUBJECTACCOUNTCHECK_IMPNEW
HDCARDHQSZS SCOSUBJECTACCOUNT_IMP
HDCARDHQSZS TEMPIMPINFO
OLAPSYS CWM2$AWCUBECREATEACCESS
OLAPSYS CWM2$AWDIMCREATEACCESS
OLAPSYS CWM2$AWVIEWCOLS
OLAPSYS CWM2$CLASSIFICATIONVALUEPAIR
OLAPSYS CWM2$HIERCUSTOMSORT
OLAPSYS CWM2$MRALL_AWVIEWCOLS
OLAPSYS CWM2$MRALL_AWVIEWS
OLAPSYS CWM2$MRALL_CATALOGS
OLAPSYS CWM2$MRALL_CATALOG_ENTITY_USES
OLAPSYS CWM2$MRALL_CUBE_MEASURES
OLAPSYS CWM2$MRALL_CWM1_AGGOP
OLAPSYS CWM2$MRALL_CWM1_AGGORD
OLAPSYS CWM2$MRALL_DESCRIPTORS
OLAPSYS CWM2$MRALL_DIM_ATTRIBUTES
OLAPSYS CWM2$MRALL_DIM_HIERS
OLAPSYS CWM2$MRALL_DIM_HIER_LEVEL_USES
OLAPSYS CWM2$MRALL_DIM_LEVEL_ATTR_MAPS
OLAPSYS CWM2$MRALL_ENTITY_DESC_USES
OLAPSYS CWM2$MRALL_ENTITY_EXT_PARMS
OLAPSYS CWM2$MRALL_ENTITY_PARAMETERS
OLAPSYS CWM2$MRALL_FACTTBLFCTMAPS
OLAPSYS CWM2$MRALL_FACTTBLKEYMAPS
OLAPSYS CWM2$MRALL_HIERDIMS
OLAPSYS CWM2$MRALL_HIERDIM_KEYCOL_MAP
OLAPSYS CWM2$MRALL_HIER_CUSTOM_SORT
OLAPSYS CWM2$MRALL_JOIN_KEY_COL_USES
OLAPSYS CWM2$MRALL_LISTDIMS
OLAPSYS CWM2$MRALL_OLAP2_AGG_USES
OLAPSYS CWM2$MRFACTTBLFCTMAPS
OLAPSYS CWM2$MRFACTTBLKEYMAPS
OLAPSYS CWM2$OLAPEXPORTCOMMANDTABLE
OLAPSYS CWM2$OLAPEXPORTOBJECTTABLE
OLAPSYS CWM2$OLAPMANAGERTABLE
OLAPSYS CWM2$OLAPVALIDATETABLE
OLAPSYS CWM2$STOREDDIMLVLTPLS
OLAPSYS CWM2$STOREDDIMLVLTPLSDTL
OLAPSYS CWM2$_AW_NEXT_PERM_CUST_MEAS
OLAPSYS CWM2$_AW_NEXT_TEMP_CUST_MEAS
OLAPSYS CWM2$_AW_PERM_CUST_MEAS_MAP
OLAPSYS CWM2$_AW_TEMP_CUST_MEAS_MAP
OLAPSYS CWM2$_TEMP_VALUES
OLAPSYS MRAC_OLAP2_AWS_T
OLAPSYS MRAC_OLAP2_AW_ATTRIBUTES_T
OLAPSYS MRAC_OLAP2_AW_CUBES_T
OLAPSYS MRAC_OLAP2_AW_CUBE_AGG_LVL_T
OLAPSYS MRAC_OLAP2_AW_CUBE_AGG_MEAS_T
OLAPSYS MRAC_OLAP2_AW_CUBE_AGG_OP_T
OLAPSYS MRAC_OLAP2_AW_CUBE_AGG_SPECS_T
OLAPSYS MRAC_OLAP2_AW_CUBE_DIM_USES_T
OLAPSYS MRAC_OLAP2_AW_CUBE_MEASURES_T
OLAPSYS MRAC_OLAP2_AW_DIMENSIONS_T
OLAPSYS MRAC_OLAP2_AW_DIM_LEVELS_T
OLAPSYS MRAC_OLAP2_AW_HIER_LVL_ORD_T
OLAPSYS MRAC_OLAP2_AW_MAP_ATTR_USE_T
OLAPSYS MRAC_OLAP2_AW_MAP_DIM_USE_T
OLAPSYS MRAC_OLAP2_AW_MAP_MEAS_USE_T
OLAPSYS MRAC_OLAP2_AW_PHYS_OBJ_PROP_T
OLAPSYS MRAC_OLAP2_AW_PHYS_OBJ_T
OLAPSYS OLAP_SESSION_CUBES
OLAPSYS OLAP_SESSION_DIMS
OLAPSYS OLAP_SESSION_OBJECTS
SCOTT BONUS
SCOTT SALGRADE
SPOTLIGHT QUEST_SOO_BUFFER_BUSY
SPOTLIGHT QUEST_SOO_EVENT_CATEGORIES
SPOTLIGHT QUEST_SOO_LOCK_TREE
SPOTLIGHT QUEST_SOO_PARSE_TIME_TRACK
SPOTLIGHT QUEST_SOO_PLAN_TABLE
SPOTLIGHT QUEST_SOO_SB_BUFFER_BUSY
SPOTLIGHT QUEST_SOO_SB_EVENT
SPOTLIGHT QUEST_SOO_SB_IO_STAT
SPOTLIGHT QUEST_SOO_VERSION
SYSMAN MGMT_ADMIN_METRIC_THRESHOLDS
SYSMAN MGMT_ARU_CREDENTIALS
SYSMAN MGMT_BACKUP_CONFIGURATION
SYSMAN MGMT_BCN_AVAIL_DEF
SYSMAN MGMT_BCN_AVAIL_JOB
SYSMAN MGMT_BCN_AVAIL_LOG
SYSMAN MGMT_BCN_TARGET
SYSMAN MGMT_BCN_TARGET_LOCK
SYSMAN MGMT_BCN_TARGET_TXN
SYSMAN MGMT_BCN_TXN_DEFN
SYSMAN MGMT_BCN_TXN_HTTP
SYSMAN MGMT_BCN_TXN_HTTP_PARAM
SYSMAN MGMT_BCN_TXN_PING
SYSMAN MGMT_BLACKOUT_REASON
SYSMAN MGMT_COMP_RESULT_TO_JOB_MAP
SYSMAN MGMT_COMP_TARGET_DEF
SYSMAN MGMT_DBNET_TNS_ADMINS
SYSMAN MGMT_DELTA_COMP_PROPERTIES
SYSMAN MGMT_DELTA_ENTRY
SYSMAN MGMT_DELTA_IDS
SYSMAN MGMT_DELTA_SUMMARY_ERRORS
SYSMAN MGMT_E2E_DETAILS
SYSMAN MGMT_E2E_DETAILS_1DAY
SYSMAN MGMT_E2E_DETAILS_1HOUR
SYSMAN MGMT_E2E_JDBC
SYSMAN MGMT_E2E_JDBC_1DAY
SYSMAN MGMT_E2E_JDBC_1HOUR
SYSMAN MGMT_E2E_SQL
SYSMAN MGMT_E2E_SQL_1DAY
SYSMAN MGMT_E2E_SQL_1HOUR
SYSMAN MGMT_E2E_SQL_CONN
SYSMAN MGMT_E2E_SQL_STMT
SYSMAN MGMT_E2E_SUMMARY
SYSMAN MGMT_E2E_SUMMARY_1DAY
SYSMAN MGMT_E2E_SUMMARY_1HOUR
SYSMAN MGMT_ECM_CSA_COOKIES
SYSMAN MGMT_ECM_CSA_CUSTOM
SYSMAN MGMT_ECM_HW_CPU
SYSMAN MGMT_ECM_HW_IOCARD
SYSMAN MGMT_ECM_HW_NIC
SYSMAN MGMT_ECM_OS_COMPONENT
SYSMAN MGMT_ECM_OS_FILESYSTEM
SYSMAN MGMT_ECM_OS_REGISTERED_SW
SYSMAN MGMT_ECM_OS_REGISTERED_SW_COMP
SYSMAN MGMT_FAILOVER_CALLBACKS
SYSMAN MGMT_FLAT_ROLE_GRANTS
SYSMAN MGMT_HC_CPU_DETAILS
SYSMAN MGMT_HC_FS_MOUNT_DETAILS
SYSMAN MGMT_HC_IOCARD_DETAILS
SYSMAN MGMT_HC_NIC_DETAILS
SYSMAN MGMT_HC_OS_COMPONENTS
SYSMAN MGMT_HC_VENDOR_SW_COMPONENTS
SYSMAN MGMT_JOB_EMD_STATUS_QUEUE
SYSMAN MGMT_JOB_EXEC_LOCKS
SYSMAN MGMT_JOB_LOCK_TARGETS
SYSMAN MGMT_JOB_NESTED_JOB_TARGETS
SYSMAN MGMT_JOB_PURGE_CRITERIA
SYSMAN MGMT_JOB_PURGE_TARGETS
SYSMAN MGMT_JOB_PURGE_VALUES
SYSMAN MGMT_JOB_SEC_INFO
SYSMAN MGMT_JOB_STEP_TARGETS
SYSMAN MGMT_JOB_TARGET
SYSMAN MGMT_JOB_TYPE_DISPLAY_INFO
SYSMAN MGMT_JOB_TYPE_DISPLAY_PARAM
SYSMAN MGMT_JOB_TYPE_URI_INFO
SYSMAN MGMT_LICENSES
SYSMAN MGMT_NOTIFICATION_LOG
SYSMAN MGMT_NOTIFY_DEVICE_PARAMS
SYSMAN MGMT_NOTIFY_REQUEUE
SYSMAN MGMT_NOTIFY_RULE_CONFIGS
SYSMAN MGMT_OB_ADMIN_CLIENT_DB
SYSMAN MGMT_OB_ADMIN_HOSTS
SYSMAN MGMT_OMS_PARAMETERS
SYSMAN MGMT_POLICY_ERRORS
SYSMAN MGMT_POLICY_PARAMS
SYSMAN MGMT_POLICY_RULE_CRITERIA
SYSMAN MGMT_POLICY_RULE_DEF_COLUMNS
SYSMAN MGMT_POLICY_RULE_DEF_PARAMS
SYSMAN MGMT_POLICY_SNAPSHOT_CRITERIA
SYSMAN MGMT_POLICY_TARGET_CRITERIA
SYSMAN MGMT_RCVCAT_CONFIG
SYSMAN MGMT_RCVCAT_REPOS
SYSMAN MGMT_REPOS_TIME_COEFFICIENT
SYSMAN MGMT_SEC_INFO
SYSMAN MGMT_SYSTEM_ERROR_LOG
SYSMAN MGMT_SYSTEM_PERFORMANCE_LOG
SYSMAN MGMT_TARGET_DELETE_CALLBACKS
SYSMAN MGMT_USER_CALLBACKS
SYSMAN MGMT_USER_FOLDERS
SYSMAN MGMT_VERSIONS
SYSMAN MGMT_VIEW_USER_CREDENTIALS
SYSMAN SYS_IOT_OVER_49772
SYSMAN SYS_IOT_OVER_49875
SYSMAN SYS_IOT_OVER_49878
TSMSYS SRS$
WMSYS SYS_IOT_OVER_10099
WMSYS WM$BATCH_COMPRESSIBLE_TABLES
WMSYS WM$CONS_COLUMNS
WMSYS WM$HINT_TABLE
WMSYS WM$LOCKROWS_INFO
WMSYS WM$MW_TABLE
WMSYS WM$NEXTVER_TABLE
WMSYS WM$REPLICATION_DETAILS_TABLE
WMSYS WM$RIC_LOCKING_TABLE
WMSYS WM$TMP_DBA_CONSTRAINTS
WMSYS WM$WORKSPACE_PRIV_TABLE
XUJM QUEST_SOO_BUFFER_BUSY
XUJM QUEST_SOO_EVENT_CATEGORIES
XUJM QUEST_SOO_LOCK_TREE
XUJM QUEST_SOO_PARSE_TIME_TRACK
XUJM QUEST_SOO_PLAN_TABLE
XUJM QUEST_SOO_SB_BUFFER_BUSY
XUJM QUEST_SOO_SB_EVENT
XUJM QUEST_SOO_SB_IO_STAT
XUJM QUEST_SOO_VERSION
253 rows selected.
Top
28. 没有索引的外键
OWNER TABLE_NAME CONSTRAINT_NAME COLUMN_NAME
DBSNMP MGMT_BSLN_INTERVALS BSLN_INTERVALS_FK1 BSLN_GUID
DBSNMP MGMT_BSLN_STATISTICS BSLN_STATISTICS_FK1 BSLN_GUID
DBSNMP MGMT_BSLN_THRESHOLD_PARMS BSLN_THRESHOLDS_FK2 DATASOURCE_GUID
EXFSYS EXF$EXPRSET REF_EXPRSET_ATTRSET EXSATSNM
EXFSYS RLM$JOBQUEUE RLM$JOINQREF RSET_NAME
EXFSYS RLM$JOBQUEUE RLM$JOINQREF RSET_OWNER
EXFSYS RLM$RULESET RLM$RSET_STATUS_REF RSET_STATUS
EXFSYS RLM$SCHACTLIST RLM$SCHACTFKEY RSET_NAME
EXFSYS RLM$SCHACTLIST RLM$SCHACTFKEY RSET_OWNER
EXFSYS RLM4J$RULESET RLM4JREFSRLMES DBEVSNM
MDSYS OGIS_GEOMETRY_COLUMNS FK_SRID SRID
MDSYS SDO_COORD_AXES COORD_AXIS_FOREIGN_AXIS COORD_AXIS_NAME_ID
MDSYS SDO_COORD_AXES COORD_AXIS_FOREIGN_UOM UOM_ID
MDSYS SDO_COORD_OPS COORD_OPERATION_FOREIGN_LEGACY LEGACY_CODE
MDSYS SDO_COORD_OPS COORD_OPERATION_FOREIGN_METHOD COORD_OP_METHOD_ID
MDSYS SDO_COORD_OPS COORD_OPERATION_FOREIGN_SOURCE SOURCE_SRID
MDSYS SDO_COORD_OPS COORD_OPERATION_FOREIGN_TARGET TARGET_SRID
MDSYS SDO_COORD_OP_PARAM_USE COORD_OP_PARA_USE_FOREIGN_PARA PARAMETER_ID
MDSYS SDO_COORD_OP_PARAM_VALS COORD_OP_PARA_VAL_FOREIGN_METH COORD_OP_METHOD_ID
MDSYS SDO_COORD_OP_PARAM_VALS COORD_OP_PARA_VAL_FOREIGN_PARA PARAMETER_ID
MDSYS SDO_COORD_OP_PARAM_VALS COORD_OP_PARA_VAL_FOREIGN_UOM UOM_ID
MDSYS SDO_COORD_OP_PATHS COORD_OP_PATH_FOREIGN_SOURCE SINGLE_OP_SOURCE_ID
MDSYS SDO_COORD_OP_PATHS COORD_OP_PATH_FOREIGN_TARGET SINGLE_OP_TARGET_ID
MDSYS SDO_COORD_REF_SYS COORD_REF_SYS_FOREIGN_CS COORD_SYS_ID
MDSYS SDO_COORD_REF_SYS COORD_REF_SYS_FOREIGN_DATUM DATUM_ID
MDSYS SDO_COORD_REF_SYS COORD_REF_SYS_FOREIGN_GEOG SOURCE_GEOG_SRID
MDSYS SDO_COORD_REF_SYS COORD_REF_SYS_FOREIGN_HORIZ CMPD_HORIZ_SRID
MDSYS SDO_COORD_REF_SYS COORD_REF_SYS_FOREIGN_LEGACY LEGACY_CODE
MDSYS SDO_COORD_REF_SYS COORD_REF_SYS_FOREIGN_PROJ PROJECTION_CONV_ID
MDSYS SDO_COORD_REF_SYS COORD_REF_SYS_FOREIGN_VERT CMPD_VERT_SRID
MDSYS SDO_DATUMS DATUM_FOREIGN_ELLIPSOID ELLIPSOID_ID
MDSYS SDO_DATUMS DATUM_FOREIGN_LEGACY LEGACY_CODE
MDSYS SDO_DATUMS DATUM_FOREIGN_MERIDIAN PRIME_MERIDIAN_ID
MDSYS SDO_ELLIPSOIDS ELLIPSOID_FOREIGN_UOM UOM_ID
MDSYS SDO_PRIME_MERIDIANS PRIME_MERIDIAN_FOREIGN_UOM UOM_ID
MDSYS SDO_UNITS_OF_MEASURE ELLIPSOID_FOREIGN_LEGACY LEGACY_CODE
MDSYS SDO_UNITS_OF_MEASURE UNIT_OF_MEASURE_FOREIGN_LEGACY LEGACY_CODE
MDSYS SDO_UNITS_OF_MEASURE UNIT_OF_MEASURE_FOREIGN_UOM TARGET_UOM_ID
OLAPSYS CWM$ARGUMENT CWM$ARGUMENT_FK PARAMETER_IRID
OLAPSYS CWM$CLASSIFICATION CWM$CLASSIFICATION_FK PROJECT_IRID
OLAPSYS CWM$CLASSIFICATIONENTRY CWM$CLASSIFICATIONENTRY_FK CLASSIFICATION_IRID
OLAPSYS CWM$CLASSIFICATIONTYPE CWM$CLASSIFICATIONTYPE_FK PROJECT_IRID
OLAPSYS CWM$CUBE CWM$CUBE_FK DATAMODEL_IRID
OLAPSYS CWM$DIMENSION CWM$DIMENSION_FK DATAMODEL_IRID
OLAPSYS CWM$DIMENSIONATTRIBUTE CWM$DIMENSIONATTRIBUTE_FK ITEMCONTAINER_IRID
OLAPSYS CWM$DOMAIN CWM$DOMAIN_FK DEFINITIONMODEL_IRID
OLAPSYS CWM$FACTLEVELGROUP CWM$FACTLEVELGROUP_FK FACTUSE_IRID
OLAPSYS CWM$FACTLEVELUSE CWM$FACTLEVELUSE_FK FACTLEVELGROUP_IRID
OLAPSYS CWM$FUNCTION CWM$FUNCTION_FK PROCESSMODEL_IRID
OLAPSYS CWM$HIERARCHY CWM$HIERARCHY_FK DIMENSION_IRID
OLAPSYS CWM$LEVEL CWM$LEVEL_FK DIMENSION_IRID
OLAPSYS CWM$MODEL CWM$MODEL_FK PROJECT_IRID
OLAPSYS CWM$MODEL CWM$MODEL_FK_1 MODEL_IRID
OLAPSYS CWM$OBJECTTYPE CWM$OBJECTTYPE_FK PROJECT_IRID
OLAPSYS CWM$OBJECTTYPE CWM$OBJECTTYPE_FK_1 CLASSIFICATIONTYPE_IRID
OLAPSYS CWM$PARAMETER CWM$PARAMETER_FK OPERATION_IRID
OLAPSYS CWM2$AWCOMPSPECMEMBERSHIP CWM2$AWCOMPSPECMEMBERSHIP_FK2 COMPOSITE_IRID
OLAPSYS CWM2$AWCUBECOMPPLAN CWM2$AWCUBECOMPPLAN_FK2 CUBECOMPSPEC_IRID
OLAPSYS CWM2$AWCUBELOADAGGPLAN CWM2$AWCUBELOADAGGPLAN_FK2 CUBEAGG_IRID
OLAPSYS CWM2$CLASSIFICATIONVALUEPAIR CWM2$CLASSVALUEPAIR_FK CLASSENTRY_IRID
OLAPSYS CWM2$CUBEDIMENSIONUSE CWM2$CUBEDIMENSIONUSE_CUBE_FK CUBE_IRID
OLAPSYS CWM2$CUBEDIMENSIONUSE CWM2$CUBEDIMENSIONUSE_DIM_FK DIMENSION_IRID
OLAPSYS CWM2$DIMHIERLVLMAP CWM2$DIMHIERLVLMAP_DHL_FK DIMHIERLVL_IRID
OLAPSYS CWM2$FACTDIMHIERTPLSDTL CWM2$FACTDIMHTD_CUBE_FK CUBE_IRID
OLAPSYS CWM2$FACTKEYDIMHIERLVLMAP CWM2$FACTKEYD_H_L_MAP_HIER_FK HIERARCHY_IRID
OLAPSYS CWM2$FACTKEYDIMHIERLVLMAP CWM2$FACTKEYD_H_L_MAP_LVL_FK LEVEL_IRID
OLAPSYS CWM2$FACTKEYDIMHIERMAP CWM2$FACTKEYDIMHIERMAP_DIM_FK DIMENSION_IRID
OLAPSYS CWM2$HIERLEVELREL CWM2$HIERLEVELREL_CLEVEL_FK CHILDLEVEL_IRID
OLAPSYS CWM2$HIERLEVELREL CWM2$HIERLEVELREL_DIM_FK DIMENSION_IRID
OLAPSYS CWM2$HIERLEVELREL CWM2$HIERLEVELREL_HIER_FK HIERARCHY_IRID
OLAPSYS CWM2$HIERLEVELREL CWM2$HIERLEVELREL_PLEVEL_FK PARENTLEVEL_IRID
OLAPSYS CWM2$LEVELATTRIBUTE CWM2$LEVELATTR_DIMATTR_FK DIMATTR_IRID
OLAPSYS CWM2$LEVELATTRIBUTE CWM2$LEVELATTR_DIM_FK DIMENSION_IRID
OLAPSYS CWM2$LEVELATTRIBUTEMAP CWM2$LVLATTRMAP_HIERLVLREL_FK HIERLVLREL_IRID
OLAPSYS CWM2$LEVELATTRIBUTEMAP CWM2$LVLATTRMAP_LVLATTR_FK LEVELATTR_IRID
OLAPSYS CWM2$MEASURETABLEMAP CWM2$MEASURETABLEMAP_FDHM_FK FACTDIMHIER_IRID
OLAPSYS CWM2$MEASURETABLEMAP CWM2$MEASURETABLEMAP_MEAS_FK MEASURE_IRID
SCOTT EMP FK_DEPTNO DEPTNO
SYSMAN MGMT_ECM_SNAPSHOT_MD_COLUMNS SMC_SMC_FK LINK_COLUMN_NAME
SYSMAN MGMT_ECM_SNAPSHOT_MD_TABLES SMT_SMT_FK PARENT_TABLE_NAME
SYSMAN MGMT_FLAT_ROLE_GRANTS MGMT_FLAT_ROLE_GRANTS_FK ROLE_NAME
SYSMAN MGMT_JOB_LOCK_TARGETS FK_JOB_LOCK_TARGETS JOB_TYPE
SYSMAN MGMT_JOB_LOCK_TARGETS FK_JOB_LOCK_TARGETS LOCK_GUID
SYSMAN MGMT_NOTIFY_DEVICES MGMT_NOTIFY_DEVICES_FK PROFILE_NAME
SYSMAN MGMT_NOTIFY_DEV_SCHEDULES MGMT_NOTIFY_DEV_SCHEDULES_DFK DEVICE_NAME
SYSMAN MGMT_NOTIFY_DEV_SCHEDULES MGMT_NOTIFY_DEV_SCHEDULES_DFK DEVICE_OWNER
SYSMAN MGMT_NOTIFY_NOTIFYEES MGMT_NOTIFY_NOTIFYEES_FKDEVICE DEVICE_NAME
SYSMAN MGMT_NOTIFY_NOTIFYEES MGMT_NOTIFY_NOTIFYEES_FKDEVICE PROFILE_NAME
SYSMAN MGMT_NOTIFY_PROFILES MGMT_NOTIFY_PROFILES_FK ESCALATION_PROFILE_NAME
SYSMAN MGMT_NOTIFY_RULES MGMT_NOTIFY_RULES_FK OWNER
SYSMAN MGMT_PLANPROBLEM_FACTORS SQL_PLAN_PROBFAC_EVAL_FK ADDRESS
SYSMAN MGMT_PLANPROBLEM_FACTORS SQL_PLAN_PROBFAC_EVAL_FK HASH_VALUE
SYSMAN MGMT_PLANPROBLEM_FACTORS SQL_PLAN_PROBFAC_EVAL_FK PLAN_HASH_VALUE
SYSMAN MGMT_PLANPROBLEM_FACTORS SQL_PLAN_PROBFAC_EVAL_FK REASON_CODE
SYSMAN MGMT_PRIV_GRANTS MGMT_PRIV_GRANTS_FK_PRIV_NAME PRIV_NAME
SYSMAN MGMT_PRIV_INCLUDES MGMT_PRIV_INCLUDES_FK_IPRIVNAM IPRIV_NAME
SYSMAN MGMT_ROLE_GRANTS MGMT_ROLE_GRANTS_FK_ROLE_NAME ROLE_NAME
SYSMAN MGMT_SQLPROBLEM_FACTORS SQL_PROBFAC_EVAL_FK ADDRESS
SYSMAN MGMT_SQLPROBLEM_FACTORS SQL_PROBFAC_EVAL_FK HASH_VALUE
SYSMAN MGMT_SQLPROBLEM_FACTORS SQL_PROBFAC_EVAL_FK PLAN_HASH_VALUE
SYSMAN MGMT_SQLPROBLEM_FACTORS SQL_PROBFAC_EVAL_FK REASON_CODE
101 rows selected.
Top
29. 建有6个以上索引的非系统表
TABLE_OWNER TABLE_NAME INDEX_COUNT
HDCARDHQSZS CARDINFO 8
HDCARDCTSZS CARDINFO 8
2 rows selected.
Top
30. 指向对象不存在的Public同义词
SYNONYM_NAME TABLE_OWNER TABLE_NAME
DBMS_AW_UTILITIES OLAPSYS DBMS_AW_UTILITIES
GV$DB_TRANSPORTABLE_PLATFORM SYS GV$_DB_TRANSPORTABLE_PLATFORM
GV$SESSION_FIX_CONTROL SYS GV$SESSION_FIX_CONTROL
GV$SYSTEM_FIX_CONTROL SYS GV$SYSTEM_FIX_CONTROL
GV$TRANSPORTABLE_PLATFORM SYS GV$_TRANSPORTABLE_PLATFORM
SDO_AVAILABLE_ELEM_OPS MDSYS SDO_AVAILABLE_ELEMENTARY_OPS
6 rows selected.
Top
31. 指向对象不存在的非Public同义词
OWNER SYNONYM_NAME TABLE_OWNER TABLE_NAME
SYS DEF$_SCHEDULE SYSTEM DEF$_SCHEDULE
1 rows selected.
Top
32. 没有授予给任何角色和用户的角色
ROLE
0 rows selected.
Top
33. 将System表空间作为临时表空间的用户(除Sys外)
USERNAME
0 rows selected.
Top
34. 将System表空间作为默认表空间的用户(除Sys外)
USERNAME
MGMT_VIEW
SYSTEM
OUTLN
3 rows selected.
Top
35. 没有授予给任何用户的profiles
PROFILE
0 rows selected.
Top
36. 没有和Package相关联的Package Body
OWNER OBJECT_NAME
0 rows selected.
Top
37. 被Disabled的约束
OWNER TABLE_NAME CONSTRAINT_NAME CONSTRAINT_TYPE
OLAPSYS CWM$DOMAIN CWM$DOMAIN_UK U
SYSTEM LOGMNR_ATTRCOL$ LOGMNR_ATTRCOL$_PK P
SYSTEM LOGMNR_ATTRIBUTE$ LOGMNR_ATTRIBUTE$_PK P
SYSTEM LOGMNR_CCOL$ LOGMNR_CCOL$_PK P
SYSTEM LOGMNR_CDEF$ LOGMNR_CDEF$_PK P
SYSTEM LOGMNR_COL$ LOGMNR_COL$_PK P
SYSTEM LOGMNR_COLTYPE$ LOGMNR_COLTYPE$_PK P
SYSTEM LOGMNR_DICTIONARY$ LOGMNR_DICTIONARY$_PK P
SYSTEM LOGMNR_DICTSTATE$ LOGMNR_DICTSTATE$_PK P
SYSTEM LOGMNR_ICOL$ LOGMNR_ICOL$_PK P
SYSTEM LOGMNR_IND$ LOGMNR_IND$_PK P
SYSTEM LOGMNR_INDCOMPART$ LOGMNR_INDCOMPART$_PK P
SYSTEM LOGMNR_INDPART$ LOGMNR_INDPART$_PK P
SYSTEM LOGMNR_INDSUBPART$ LOGMNR_INDSUBPART$_PK P
SYSTEM LOGMNR_LOB$ LOGMNR_LOB$_PK P
SYSTEM LOGMNR_LOBFRAG$ LOGMNR_LOBFRAG$_PK P
SYSTEM LOGMNR_OBJ$ LOGMNR_OBJ$_PK P
SYSTEM LOGMNR_TAB$ LOGMNR_TAB$_PK P
SYSTEM LOGMNR_TABCOMPART$ LOGMNR_TABCOMPART$_PK P
SYSTEM LOGMNR_TABPART$ LOGMNR_TABPART$_PK P
SYSTEM LOGMNR_TABSUBPART$ LOGMNR_TABSUBPART$_PK P
SYSTEM LOGMNR_TS$ LOGMNR_TS$_PK P
SYSTEM LOGMNR_TYPE$ LOGMNR_TYPE$_PK P
SYSTEM LOGMNR_USER$ LOGMNR_USER$_PK P
24 rows selected.
Top
38. 被Disabled的触发器
OWNER TABLE_NAME TRIGGER_NAME
EXFSYS EXPFIL_ALTEREXPTAB_MAINT
EXFSYS EXPFIL_DROPOBJ_MAINT
EXFSYS EXPFIL_DROPUSR_MAINT
EXFSYS EXPFIL_RESTRICT_TYPEEVOLVE
EXFSYS RLMGR_TRUNCATE_MAINT
SYS AURORA$SERVER$SHUTDOWN
SYS AURORA$SERVER$STARTUP
SYS CDC_ALTER_CTABLE_BEFORE
SYS CDC_CREATE_CTABLE_AFTER
SYS CDC_CREATE_CTABLE_BEFORE
SYS CDC_DROP_CTABLE_BEFORE
WMSYS NO_VM_DDL
WMSYS NO_VM_DROP_A
13 rows selected.
Top
39. Invalid Objects
OWNER OBJECT_NAME OBJECT_TYPE
EXFSYS EXPRESSIONINDEXMETHODS TYPE BODY
HDCARDHQSZS PIMP_CARD_HQS PACKAGE BODY
MDSYS SDO_GEOR_TRIG_DEL1 TRIGGER
MDSYS SDO_GEOR_TRIG_INS1 TRIGGER
MDSYS SDO_GEOR_TRIG_UPD1 TRIGGER
MDSYS SDO_LRS_TRIG_DEL TRIGGER
MDSYS SDO_LRS_TRIG_INS TRIGGER
MDSYS SDO_LRS_TRIG_UPD TRIGGER
PUBLIC ALL_APPLY SYNONYM
PUBLIC ALL_APPLY_ENQUEUE SYNONYM
PUBLIC ALL_APPLY_ERROR SYNONYM
PUBLIC ALL_APPLY_PARAMETERS SYNONYM
PUBLIC ALL_APPLY_PROGRESS SYNONYM
PUBLIC ALL_CAPTURE SYNONYM
PUBLIC ALL_CAPTURE_EXTRA_ATTRIBUTES SYNONYM
PUBLIC ALL_CAPTURE_PARAMETERS SYNONYM
PUBLIC ALL_PROPAGATION SYNONYM
PUBLIC ALL_QUEUES SYNONYM
PUBLIC ALL_QUEUE_TABLES SYNONYM
PUBLIC ALL_STREAMS_GLOBAL_RULES SYNONYM
PUBLIC ALL_STREAMS_MESSAGE_CONSUMERS SYNONYM
PUBLIC ALL_STREAMS_MESSAGE_RULES SYNONYM
PUBLIC ALL_STREAMS_RULES SYNONYM
PUBLIC ALL_STREAMS_SCHEMA_RULES SYNONYM
PUBLIC ALL_STREAMS_TABLE_RULES SYNONYM
PUBLIC DBA_JOBS_RUNNING SYNONYM
PUBLIC DBA_QUEUES SYNONYM
PUBLIC USER_QUEUES SYNONYM
PUBLIC X$BH SYNONYM
PUBLIC X$KGLOB SYNONYM
PUBLIC X$KSMLRU SYNONYM
PUBLIC X$KSUSE SYNONYM
XDB XDB_PV_TRIG TRIGGER
33 rows selected.
Top
40. 执行失败或中断的Jobs
JOB Last Date This Date BROKEN FAILURES SCHEMA_USER WHAT
0 rows selected.
Top
41. 当前未执行且下一执行日期已经过去的Jobs
JOB Last Date This Date BROKEN FAILURES SCHEMA_USER WHAT
0 rows selected.
Top
42. 含有未分析的非系统表的Schemas
Schema
EXFSYS
HDCARDCTSZS
HDCARDHQSZS
OLAPSYS
SYSMAN
WMSYS
6 rows selected.
Top
43. 含有未分析的非系统分区表的Schemas
Schema
0 rows selected.
Top
44. 含有未分析的非系统索引的Schemas
Schema
EXFSYS
OLAPSYS
SYSMAN
TSMSYS
WMSYS
5 rows selected.
Top
45. 含有未分析的非系统分区索引的Schemas
Schema
0 rows selected.
Top
46. 死锁检测
TABLE_NAME SESSION_ID SERIAL# ACTION OSUSER AP_PROCESS_ID DB_PROCESS_ID
0 rows selected.
Top
47. top I/O Wait
EVENT SEGMENT_TYPE SEGMENT_NAME FILE_ID BLOCK_ID BLOCKS
0 rows selected.
Top
48. top 10 wait
EVENT Prev Curr Total
SQL*Net message from client 0 29 29
rdbms ipc message 0 14 14
jobq slave wait 0 1 1
smon timer 0 1 1
pmon timer 0 1 1
Streams AQ: qmn slave idle wait 0 1 1
SQL*Net message to client 1 0 1
Streams AQ: qmn coordinator idle wait 0 1 1
Streams AQ: waiting for time management or cleanup tasks 0 1 1
9 rows selected.
Top
49. Top 10 bad SQL
EXECUTIONS SORTS COMMAND_TYPE DISK_READS SQL_TEXT
57 0 3 2925164 S
--------------------------------------------------------------------------------
List Contents
1. 数据库概要
2. 参数文件(是spfile还是pfile)
3. 非默认的参数
4. 控制文件及其状态
5. 表空间及数据文件
6. 重做日志文件信息
7. 内存分配概况
8. Library Cache Reload Ratio(<1%)
9. Data Dictionary Miss Ratio(<15%)
10. 共享池建议
11. DB Buffer Cache(Default) Hit Ratio(>90%)
12. DB Buffer Cache Advice
13. 磁盘排序(<5%)
14. Log Buffer latch Contention(<1%)
15. 表空间状态及其大小使用情况
16. 数据文件状态及其大小使用情况
17. 不使用临时文件的临时表空间
18. 无效的数据文件(offline)
19. 处于恢复模式的文件
20. 含有50个以上的Extent且30%以上碎片的表空间
21. 表空间上的I/O分布
22. 数据文件上的I/O分布
23. Next Extent 相对于段当前已分配字节过大(>=2倍)或过小(<10%)的Segments
24. Max Extents(>1)已经有90%被使用了的Segments
25. 已经分配超过100 Extents的Segments
26. 因表空间空间不够将导致不能扩展的Objects
27. 没有主键的非系统表
28. 没有索引的外键
29. 建有6个以上索引的非系统表
30. 指向对象不存在的Public同义词
31. 指向对象不存在的非Public同义词
32. 没有授予给任何角色和用户的角色
33. 将System表空间作为临时表空间的用户(除Sys外)
34. 将System表空间作为默认表空间的用户(除Sys外)
35. 没有授予给任何用户的profiles
36. 没有和Package相关联的Package Body
37. 被Disabled的约束
38. 被Disabled的触发器
39. Invalid Objects
40. 执行失败或中断的Jobs
41. 当前未执行且下一执行日期已经过去的Jobs
42. 含有未分析的非系统表的Schemas
43. 含有未分析的非系统分区表的Schemas
44. 含有未分析的非系统索引的Schemas
45. 含有未分析的非系统分区索引的Schemas
46. 死锁检测
47. top I/O Wait
48. top 10 wait
49. Top 10 bad SQL
50. Top most expensive SQL (Buffer Gets by Executions)
51. Top most expensive SQL (Physical Reads by Executions)
52. Top most expensive SQL (Rows Processed by Executions)
53. Top most expensive SQL (Buffer Gets vs Rows Processed)
54. 数据库版本信息
55. 数据库组件(true:已安装，false：未安装)
56. 实例信息
57. 数据库临时文件状态
58. 表空间空闲块查询
59. 表空间碎片化程度分析（FSFI<30,破碎化程度高）
60. 回滚段空间配置
61. NLS参数设置
62. 用户角色查询
63. 最近7日联机日志切换频度
64. 表和索引在同一表空间（不包含USERS,SYSAUX,SYSMAN,SYSTEM,TEMP 表空间）
65. TOP 10 等待事件
66. 数据缓冲区高速缓存
67. 重做日至缓冲区
68. 数据字典高速缓存
69. 库高速缓存
70. 排序（磁盘/内存）
71. 单个用户大小估算
72. 系统表空间中非SYS的对象
73. 可传输表空间支持的操作系统和字节顺序
74. 锁信息
75. 具有dba角色用户
76. 具有sysdba权限用户
77. 检测system表空间里的用户对象
78. 已装载的产品选项
79. 数据库session连接数
80. 数据库的并发数
81. 最近7天归档日志的生成频率
82. 未建索引的表（不包含表空间为'SYSTEM', 'SYSAUX', 'SYSMAN', 'USERS', 'TEMP'下的用户）
83. sort_segment检查
84. 数据库总大小（Gb）
85. 超过2g的segment（单个表超过2g建议使用分区表）
86. 数据库长事务（执行超过6s）
87. 产生大量物理读的进程
88. 产生归档日志过快的进程
89. 等待事件对应的sql语句
90. 占用大量temp表空间的session和sql监控
91. 数据库服务器运行的操作系统
92. SGA Memory Map (overall)
93. SGA Memory Map (shared pool)
94. 定时任务（job）
95. 数据库dbid
96. 闪回模式的是否启动
97. rollback信息
98. 回滚段的争用情况
99. session等待事件
1. 数据库概要
DB Name Global Name Host Name Instance Name Restricted Mode Archive Log Mode
HDCARDS HDCARDS.REGRESS.RDBMS.DEV.US.ORACLE.COM FLEX3 hdcards NO ARCHIVELOG
1 rows selected.
Top
2. 参数文件(是spfile还是pfile)
Parameter_File
D:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE\SPFILEHDCARDS.ORA
1 rows selected.
Top
3. 非默认的参数
NAME pvalue
audit_file_dest D:\ORACLE\PRODUCT\10.2.0\ADMIN\HDCARDS\ADUMP
background_dump_dest D:\ORACLE\PRODUCT\10.2.0\ADMIN\HDCARDS\BDUMP
compatible 10.2.0.1.0
control_files E:\ORADATA\HDCARDS\CONTROL01.CTL, E:\ORADATA\HDCARDS\CONTROL02.CTL, E:\ORADATA\HDCARDS\CONTROL03.CTL
core_dump_dest D:\ORACLE\PRODUCT\10.2.0\ADMIN\HDCARDS\CDUMP
db_block_size 8192
db_domain
db_file_multiblock_read_count 8
db_name hdcards
dispatchers (PROTOCOL=TCP) (SERVICE=hdcardsXDB)
job_queue_processes 10
log_archive_dest_1 LOCATION=e:\oradata\hdcards\archive
log_archive_format ARC%S_%R.%T
nls_language SIMPLIFIED CHINESE
nls_territory CHINA
open_cursors 1000
pga_aggregate_target 2147483648
processes 2000
remote_login_passwordfile EXCLUSIVE
session_cached_cursors 1000
sessions 2205
sga_max_size 8589934592
sga_target 8589934592
undo_management AUTO
undo_tablespace UNDOTBS1
user_dump_dest D:\ORACLE\PRODUCT\10.2.0\ADMIN\HDCARDS\UDUMP
26 rows selected.
Top
4. 控制文件及其状态
NAME STATUS
E:\ORADATA\HDCARDS\CONTROL01.CTL
E:\ORADATA\HDCARDS\CONTROL02.CTL
E:\ORADATA\HDCARDS\CONTROL03.CTL
3 rows selected.
Top
5. 表空间及数据文件
TABLESPACE_NAME FILE_NAME Total Size(MB) Auto
HDCARDS E:\ORADATA\HDCARDS\HDCARDS01.DBF 2048 NO
HDCARDS E:\ORADATA\HDCARDS\HDCARDS02.DBF 2048 NO
HDCARDS E:\ORADATA\HDCARDS\HDCARDS03.DBF 2048 NO
HDCARDS E:\ORADATA\HDCARDS\HDCARDS04.DBF 2048 NO
HDCARDS E:\ORADATA\HDCARDS\HDCARDS05.DBF 2048 NO
HDCARDS E:\ORADATA\HDCARDS\HDCARDS06.DBF 2000 NO
HDCARDS E:\ORADATA\HDCARDS\HDCARDS07.DBF 2000 NO
HDCARDS E:\ORADATA\HDCARDS\HDCARDS08.DBF 2000 NO
HDCARDS E:\ORADATA\HDCARDS\HDCARDS09.DBF 2000 NO
HDCARDS E:\ORADATA\HDCARDS\HDCARDS10.DBF 2000 NO
HDCARDS E:\ORADATA\HDCARDS\HDCARDS11.DBF 2000 NO
HDCARDS E:\ORADATA\HDCARDS\HDCARDS12.DBF 2000 NO
HDCARDS E:\ORADATA\HDCARDS\HDCARDS13.DBF 2000 NO
HDCARDS E:\ORADATA\HDCARDS\HDCARDS14.DBF 2000 NO
HDCARDS E:\ORADATA\HDCARDS\HDCARDS15.DBF 2000 NO
HDCARDS E:\ORADATA\HDCARDS\HDCARDS16.DBF 2000 NO
HDCARDS E:\ORADATA\HDCARDS\HDCARDS17.DBF 2000 NO
HDCARDS E:\ORADATA\HDCARDS\HDCARDS18.DBF 2000 NO
HDCARDS E:\ORADATA\HDCARDS\HDCARDS19.DBF 2000 NO
HDCARDS E:\ORADATA\HDCARDS\HDCARDS20.DBF 2000 NO
SYSAUX E:\ORADATA\HDCARDS\SYSAUX01.DBF 700 YES
SYSTEM E:\ORADATA\HDCARDS\SYSTEM01.DBF 530 YES
UNDOTBS1 E:\ORADATA\HDCARDS\UNDOTBS01.DBF 2400 YES
USERS E:\ORADATA\HDCARDS\USERS01.DBF 5 YES
24 rows selected.
Top
6. 重做日志文件信息
GROUP# Redo File TYPE STATUS Size(MB)
8 E:\ORADATA\HDCARDS\REDO08.LOG ONLINE INACTIVE 100
7 E:\ORADATA\HDCARDS\REDO07.LOG ONLINE INACTIVE 100
6 E:\ORADATA\HDCARDS\REDO06.LOG ONLINE INACTIVE 100
5 E:\ORADATA\HDCARDS\REDO05.LOG ONLINE INACTIVE 100
4 E:\ORADATA\HDCARDS\REDO04.LOG ONLINE INACTIVE 100
3 E:\ORADATA\HDCARDS\REDO03.LOG ONLINE INACTIVE 100
2 E:\ORADATA\HDCARDS\REDO02.LOG ONLINE INACTIVE 100
1 E:\ORADATA\HDCARDS\REDO01.LOG ONLINE CURRENT 100
8 rows selected.
Top
7. 内存分配概况
NAME value(Byte)
Fixed Size 2079480
Variable Size 788530440
Database Buffers 7784628224
Redo Buffers 14696448
lock_sga FALSE
large_pool_size 0
java_pool_size 0
7 rows selected.
Top
8. Library Cache Reload Ratio(<1%)
LC_Reload_Ratio%
1.2895
1 rows selected.
Top
9. Data Dictionary Miss Ratio(<15%)
DC_Miss_Ratio%
0.6028
1 rows selected.
Top
10. 共享池建议
Shared Pool Size(estimate) Factor Libarary Cache Size time Saved
400 0.5556 90 18305256
480 0.6667 165 18336103
560 0.7778 243 18363914
640 0.8889 322 18391677
720 1 399 18419375
800 1.1111 458 18446996
880 1.2222 503 18474534
960 1.3333 548 18501989
1040 1.4444 593 18529363
1120 1.5556 638 18556663
1200 1.6667 683 18583895
1280 1.7778 728 18611068
1360 1.8889 769 18638191
1440 2 792 18665273
14 rows selected.
Top
11. DB Buffer Cache(Default) Hit Ratio(>90%)
BC_Hit_Ratio
91.8081
1 rows selected.
Top
12. DB Buffer Cache Advice
Pool Name BLOCK_SIZE Buffer Size Factor Phy_Read_Factor ESTD_PHY_READS
DEFAULT 8192 736 0.0991 1.3257 101015787
DEFAULT 8192 1472 0.1983 1.2267 93473993
DEFAULT 8192 2208 0.2974 1.1821 90069574
DEFAULT 8192 2944 0.3966 1.1451 87255536
DEFAULT 8192 3680 0.4957 1.1115 84692047
DEFAULT 8192 4416 0.5948 1.081 82370607
DEFAULT 8192 5152 0.694 1.0511 80092067
DEFAULT 8192 5888 0.7931 1.0286 78379772
DEFAULT 8192 6624 0.8922 1.0117 77086286
DEFAULT 8192 7360 0.9914 1.0009 76268668
DEFAULT 8192 7424 1 1 76196812
DEFAULT 8192 8096 1.0905 0.9901 75441141
DEFAULT 8192 8832 1.1897 0.9767 74417992
DEFAULT 8192 9568 1.2888 0.9455 72047610
DEFAULT 8192 10304 1.3879 0.9265 70596739
DEFAULT 8192 11040 1.4871 0.9078 69168824
DEFAULT 8192 11776 1.5862 0.8733 66539663
DEFAULT 8192 12512 1.6853 0.8509 64836665
DEFAULT 8192 13248 1.7845 0.8184 62359630
DEFAULT 8192 13984 1.8836 0.742 56537835
DEFAULT 8192 14720 1.9828 0.5479 41747795
21 rows selected.
Top
13. 磁盘排序(<5%)
Sort(Disk) Sort(Memory) Disk_Sort_Ratio％
177 6671021 0
1 rows selected.
Top
14. Log Buffer latch Contention(<1%)
Redo Name GETS MISSES IMMEDIATE_GETS IMMEDIATE_MISSES Miss_Ratio％ Immediate Misses Ratio%
redo copy 1600 0 52720847 30599 0 0.058
redo allocation 19437130 3171 52712215 21332 0.016 0.04
2 rows selected.
Top
15. 表空间状态及其大小使用情况
Name Status Type Size (MB) Used (MB) Used％
UNDOTBS1 ONLINE UNDO 2,400.000 167.875 6.99
SYSAUX ONLINE PERMANENT 700.000 661.000 94.43
USERS ONLINE PERMANENT 5.000 1.688 33.75
HDCARDS ONLINE PERMANENT 40,240.000 33,315.750 82.79
SYSTEM ONLINE PERMANENT 530.000 520.125 98.14
TEMP ONLINE TEMPORARY 0.000 0.000 0.00
6 rows selected.
Top
16. 数据文件状态及其大小使用情况
TableSpace Name File Name Status Auto Size (MB) Used (MB) Used %
HDCARDS E:\ORADATA\HDCARDS\HDCARDS01.DBF AVAILABLE NO 2,048.000 2,014.500 98.36
HDCARDS E:\ORADATA\HDCARDS\HDCARDS02.DBF AVAILABLE NO 2,048.000 2,005.438 97.92
HDCARDS E:\ORADATA\HDCARDS\HDCARDS03.DBF AVAILABLE NO 2,048.000 2,002.375 97.77
HDCARDS E:\ORADATA\HDCARDS\HDCARDS04.DBF AVAILABLE NO 2,048.000 2,005.250 97.91
HDCARDS E:\ORADATA\HDCARDS\HDCARDS05.DBF AVAILABLE NO 2,048.000 2,001.500 97.73
HDCARDS E:\ORADATA\HDCARDS\HDCARDS06.DBF AVAILABLE NO 2,000.000 1,874.438 93.72
HDCARDS E:\ORADATA\HDCARDS\HDCARDS07.DBF AVAILABLE NO 2,000.000 1,890.563 94.53
HDCARDS E:\ORADATA\HDCARDS\HDCARDS08.DBF AVAILABLE NO 2,000.000 1,893.313 94.67
HDCARDS E:\ORADATA\HDCARDS\HDCARDS09.DBF AVAILABLE NO 2,000.000 1,992.063 99.60
HDCARDS E:\ORADATA\HDCARDS\HDCARDS10.DBF AVAILABLE NO 2,000.000 1,994.063 99.70
HDCARDS E:\ORADATA\HDCARDS\HDCARDS11.DBF AVAILABLE NO 2,000.000 1,992.063 99.60
HDCARDS E:\ORADATA\HDCARDS\HDCARDS12.DBF AVAILABLE NO 2,000.000 1,995.000 99.75
HDCARDS E:\ORADATA\HDCARDS\HDCARDS13.DBF AVAILABLE NO 2,000.000 1,995.000 99.75
HDCARDS E:\ORADATA\HDCARDS\HDCARDS14.DBF AVAILABLE NO 2,000.000 1,994.750 99.74
HDCARDS E:\ORADATA\HDCARDS\HDCARDS15.DBF AVAILABLE NO 2,000.000 1,994.625 99.73
HDCARDS E:\ORADATA\HDCARDS\HDCARDS16.DBF AVAILABLE NO 2,000.000 1,478.563 73.93
HDCARDS E:\ORADATA\HDCARDS\HDCARDS17.DBF AVAILABLE NO 2,000.000 820.063 41.00
HDCARDS E:\ORADATA\HDCARDS\HDCARDS18.DBF AVAILABLE NO 2,000.000 716.063 35.80
HDCARDS E:\ORADATA\HDCARDS\HDCARDS19.DBF AVAILABLE NO 2,000.000 364.063 18.20
HDCARDS E:\ORADATA\HDCARDS\HDCARDS20.DBF AVAILABLE NO 2,000.000 292.063 14.60
SYSAUX E:\ORADATA\HDCARDS\SYSAUX01.DBF AVAILABLE YES 700.000 661.000 94.43
SYSTEM E:\ORADATA\HDCARDS\SYSTEM01.DBF AVAILABLE YES 530.000 520.125 98.14
UNDOTBS1 E:\ORADATA\HDCARDS\UNDOTBS01.DBF AVAILABLE YES 2,400.000 167.875 6.99
USERS E:\ORADATA\HDCARDS\USERS01.DBF AVAILABLE YES 5.000 1.688 33.75
24 rows selected.
Top
17. 不使用临时文件的临时表空间
TABLESPACE_NAME CONTENTS
0 rows selected.
Top
18. 无效的数据文件(offline)
TABLESPACE_NAME FILE_NAME STATUS
0 rows selected.
Top
19. 处于恢复模式的文件
TABLESPACE_NAME FILE_NAME
0 rows selected.
Top
20. 含有50个以上的Extent且30%以上碎片的表空间
TABLESPACE_NAME PCT_FRAGMENTED SEGMENTS HOLES
HDCARDS 74 163 465
1 rows selected.
Top
21. 表空间上的I/O分布
TS_NAME FILE_NAME PHY_READS PHY_BLOCKREADS PHY_WRITES PHY_BLOCKWRITES
HDCARDS E:\ORADATA\HDCARDS\HDCARDS02.DBF 2522628 13920290 923524 942042
HDCARDS E:\ORADATA\HDCARDS\HDCARDS03.DBF 2488428 13802338 858229 876130
HDCARDS E:\ORADATA\HDCARDS\HDCARDS01.DBF 2438806 13691600 939381 958303
HDCARDS E:\ORADATA\HDCARDS\HDCARDS04.DBF 2434843 13766881 916956 936866
HDCARDS E:\ORADATA\HDCARDS\HDCARDS05.DBF 2431652 13595399 939909 959904
HDCARDS E:\ORADATA\HDCARDS\HDCARDS16.DBF 2303409 11843800 512047 1446520
HDCARDS E:\ORADATA\HDCARDS\HDCARDS17.DBF 2216613 11582194 524711 1460025
HDCARDS E:\ORADATA\HDCARDS\HDCARDS06.DBF 1989662 12612560 397354 437064
HDCARDS E:\ORADATA\HDCARDS\HDCARDS18.DBF 1957941 10833293 417336 1341636
HDCARDS E:\ORADATA\HDCARDS\HDCARDS07.DBF 1770892 12134286 516892 556000
HDCARDS E:\ORADATA\HDCARDS\HDCARDS08.DBF 1678349 11710796 404673 434382
HDCARDS E:\ORADATA\HDCARDS\HDCARDS09.DBF 1537244 11285308 417842 561438
HDCARDS E:\ORADATA\HDCARDS\HDCARDS10.DBF 1380919 10494486 385632 543934
HDCARDS E:\ORADATA\HDCARDS\HDCARDS14.DBF 1275218 10211198 313820 471805
HDCARDS E:\ORADATA\HDCARDS\HDCARDS11.DBF 1269520 10163826 344521 461255
HDCARDS E:\ORADATA\HDCARDS\HDCARDS13.DBF 1224816 10182974 366853 503696
HDCARDS E:\ORADATA\HDCARDS\HDCARDS15.DBF 1201832 10100457 283491 415943
HDCARDS E:\ORADATA\HDCARDS\HDCARDS12.DBF 1192771 10102615 422932 506934
HDCARDS E:\ORADATA\HDCARDS\HDCARDS19.DBF 1107998 6487504 163964 769091
HDCARDS E:\ORADATA\HDCARDS\HDCARDS20.DBF 1075565 6419941 140192 731071
SYSAUX E:\ORADATA\HDCARDS\SYSAUX01.DBF 283964 3155251 510215 666839
UNDOTBS1 E:\ORADATA\HDCARDS\UNDOTBS01.DBF 155849 9227849 649232 3248147
SYSTEM E:\ORADATA\HDCARDS\SYSTEM01.DBF 99446 2121930 102096 140958
USERS E:\ORADATA\HDCARDS\USERS01.DBF 893 19835 556 556
24 rows selected.
Top
22. 数据文件上的I/O分布
Table Space File Name Phys Rds % Phys Rds Phys Wrts % Phys Wrts
SYSTEM E:\ORADATA\HDCARDS\SYSTEM01.DBF 99446 0.28 102096 0.89
UNDOTBS1 E:\ORADATA\HDCARDS\UNDOTBS01.DBF 155849 0.43 649232 5.67
SYSAUX E:\ORADATA\HDCARDS\SYSAUX01.DBF 283964 0.79 510215 4.46
USERS E:\ORADATA\HDCARDS\USERS01.DBF 893 0 556 0
HDCARDS E:\ORADATA\HDCARDS\HDCARDS01.DBF 2438806 6.77 939381 8.2
HDCARDS E:\ORADATA\HDCARDS\HDCARDS02.DBF 2522628 7 923524 8.06
HDCARDS E:\ORADATA\HDCARDS\HDCARDS03.DBF 2488428 6.9 858229 7.49
HDCARDS E:\ORADATA\HDCARDS\HDCARDS04.DBF 2434843 6.76 916956 8.01
HDCARDS E:\ORADATA\HDCARDS\HDCARDS05.DBF 2431652 6.75 939909 8.21
HDCARDS E:\ORADATA\HDCARDS\HDCARDS06.DBF 1989662 5.52 397354 3.47
HDCARDS E:\ORADATA\HDCARDS\HDCARDS07.DBF 1770892 4.91 516892 4.51
HDCARDS E:\ORADATA\HDCARDS\HDCARDS08.DBF 1678349 4.66 404673 3.53
HDCARDS E:\ORADATA\HDCARDS\HDCARDS09.DBF 1537244 4.27 417842 3.65
HDCARDS E:\ORADATA\HDCARDS\HDCARDS10.DBF 1380919 3.83 385632 3.37
HDCARDS E:\ORADATA\HDCARDS\HDCARDS11.DBF 1269520 3.52 344521 3.01
HDCARDS E:\ORADATA\HDCARDS\HDCARDS12.DBF 1192771 3.31 422932 3.69
HDCARDS E:\ORADATA\HDCARDS\HDCARDS13.DBF 1224816 3.4 366853 3.2
HDCARDS E:\ORADATA\HDCARDS\HDCARDS14.DBF 1275218 3.54 313820 2.74
HDCARDS E:\ORADATA\HDCARDS\HDCARDS15.DBF 1201832 3.33 283491 2.48
HDCARDS E:\ORADATA\HDCARDS\HDCARDS16.DBF 2303409 6.39 512047 4.47
HDCARDS E:\ORADATA\HDCARDS\HDCARDS17.DBF 2216613 6.15 524711 4.58
HDCARDS E:\ORADATA\HDCARDS\HDCARDS18.DBF 1957941 5.43 417336 3.64
HDCARDS E:\ORADATA\HDCARDS\HDCARDS19.DBF 1107998 3.07 163964 1.43
HDCARDS E:\ORADATA\HDCARDS\HDCARDS20.DBF 1075565 2.98 140192 1.22
24 rows selected.
Top
23. Next Extent 相对于段当前已分配字节过大(>=2倍)或过小(<10%)的Segments
Type OWNER SEGMENT_NAME BYTES NEXT_EXTENT Percent(Next/Bytes)
0 rows selected.
Top
24. Max Extents(>1)已经有90%被使用了的Segments
SEGMENT_TYPE OWNER SEGMENT_NAME TABLESPACE_NAME PARTITION_NAME Size(MB) EXTENTS MAX_EXTENTS
0 rows selected.
Top
25. 已经分配超过100 Extents的Segments
SEGMENT_TYPE OWNER SEGMENT_NAME EXTENTS PARTITION_NAME
TABLE HDCARDCTSZS CCMEMBERACCOUNT 210
INDEX HDCARDCTSZS SYS_C005229 107
TABLE HDCARDCTSZS CARDINFO 221
INDEX HDCARDCTSZS SYS_C005250 128
TABLE HDCARDCTSZS DESACCOUNT 174
INDEX HDCARDCTSZS SYS_C005257 136
TABLE HDCARDCTSZS DESACCOUNTCHECK 220
INDEX HDCARDCTSZS SYS_C005265 137
TABLE HDCARDCTSZS SCOSUBJECTACCOUNT 163
INDEX HDCARDCTSZS SYS_C005293 142
TABLE HDCARDCTSZS SCOSUBJECTACCOUNTCHECK 214
INDEX HDCARDCTSZS SYS_C005300 276
INDEX HDCARDCTSZS IDX_CARDINFO_1 108
INDEX HDCARDCTSZS IDX_SCOSUBJECTACCOUNT_1 117
INDEX HDCARDCTSZS IDX_SCOSUBJECTACCOUNTCHECK_1 167
INDEX HDCARDCTSZS IDX_CCMEMBERACCOUNT_ID 101
INDEX HDCARDCTSZS IDX_CARDINFO_ACCOUNTNO 141
INDEX HDCARDCTSZS INDEX_CARDINFO_LASTMODIFYTIME 158
TABLE HDCARDHQSZS CARDINFO 213
INDEX HDCARDHQSZS SYS_C005329 130
TABLE HDCARDHQSZS DESACCOUNT 163
INDEX HDCARDHQSZS SYS_C005336 131
TABLE HDCARDHQSZS DESACCOUNTCHECK 216
INDEX HDCARDHQSZS SYS_C005344 133
INDEX HDCARDHQSZS IDX_CARDINFO_1 103
INDEX HDCARDHQSZS IDX_CARDINFO_ACCOUNTNO 132
INDEX HDCARDHQSZS INDEX_CARDINFO_LASTMODIFYTIME 105
TABLE HDCARDCTSZS CARDUSEMRPT 127
TABLE HDCARDCTSZS HCCMEMBER_0311 212
TABLE HDCARDCTSZS HCCCARDMEMBER_0311 114
INDEX HDCARDHQSZS IDX_DESACCOUNTCHECK_1 131
INDEX HDCARDCTSZS IDX_DESACCOUNTCHECK_1 134
TABLE HDCARDCTSZS SCOSUBJECTACCOUNT_20130411 104
INDEX HDCARDCTSZS IDX_MEMBERACCOUNT_DESANDSTATE 112
TABLE HDCARDCTSZS HCCMEMBER_0326 213
TABLE HDCARDCTSZS HCCCARDMEMBER_0326 114
INDEX HDCARDCTSZS IDX_CARDINFO_MEMBERUUID 101
TABLE HDCARDCTSZS CARDINFO_BAK_20140214 214
38 rows selected.
Top
26. 因表空间空间不够将导致不能扩展的Objects
TABLESPACE_NAME OWNER Segment Name EXTENTS NEXT_EXTENT_KB TS_FREE_KB TS_GROWTH_MB
0 rows selected.
Top
27. 没有主键的非系统表
OWNER TABLE_NAME
DMSYS DM$P_MODEL
DMSYS DM$P_MODEL_TABLES
EXFSYS EXF$DEFIDXPARAM
EXFSYS EXF$ESETIDXPARAM
EXFSYS EXF$JAVAMSG
EXFSYS EXF$PREDATTRMAP
EXFSYS EXF$VALIDIOPER
EXFSYS EXF$VALIDPRIVS
EXFSYS EXF$VERSION
EXFSYS RLM$PARSEDCOND
EXFSYS RLM$SCHACTLIST
EXFSYS SYS_IOT_OVER_40415
EXFSYS SYS_IOT_OVER_42451
EXFSYS SYS_IOT_OVER_42458
EXFSYS SYS_IOT_OVER_42465
EXFSYS SYS_IOT_OVER_42468
EXFSYS SYS_IOT_OVER_42487
EXFSYS SYS_IOT_OVER_42490
EXFSYS SYS_IOT_OVER_42493
EXFSYS SYS_IOT_OVER_42496
HDCARDCTSZS CARDINFO_BAK_20140214
HDCARDCTSZS CARDINFO_BAK_2014021401
HDCARDCTSZS CARDINFO_IMP
HDCARDCTSZS CARDINFO_IMPNEW
HDCARDCTSZS CARDUSEMRPT
HDCARDCTSZS CCMEMBERACCOUNT_1
HDCARDCTSZS DESACCOUNTCHECK_IMPNEW
HDCARDCTSZS DESACCOUNT_IMP
HDCARDCTSZS DESACCOUNT_IMPNEW
HDCARDCTSZS HCCCARDMEMBER_0326
HDCARDCTSZS HCCMEMBER_0326
HDCARDCTSZS HCCMEMBER_0326_1
HDCARDCTSZS IMPDATARESULT
HDCARDCTSZS IMPTEMPINFO
HDCARDCTSZS SCOSUBJECTACCOUNTCHECK_IMPNEW
HDCARDCTSZS SCOSUBJECTACCOUNT_20130411
HDCARDCTSZS SCOSUBJECTACCOUNT_IMP
HDCARDCTSZS SCOSUBJECTACCOUNT_IMPNEW
HDCARDCTSZS TABLE_SCORE1
HDCARDCTSZS TABLE_SCORE2
HDCARDCTSZS TEMPIMPINFO
HDCARDCTSZS TEMP_0411
HDCARDCTSZS TEMP_0626
HDCARDCTSZS TEMP_SCOSUBJECTACCOUNT_0411
HDCARDCTSZS TEMP_SCOSUBJECTACCOUNT_0626
HDCARDCTSZS TMP_CARDNUMRETAIL
HDCARDCTSZS TMP_CARDNUMRETAIL1
HDCARDCTSZS TMP_SCOREDIFF_0713
HDCARDCTSZS TMP_SCOREDIFF_0715
HDCARDCTSZS TMP_TABLE_1
HDCARDCTSZS WXF_ANALYZE_LOG
HDCARDHQSZS CARDINFO_IMP
HDCARDHQSZS CARDINFO_IMPNEW
HDCARDHQSZS DESACCOUNTCHECK_IMPNEW
HDCARDHQSZS DESACCOUNT_IMP
HDCARDHQSZS DESACCOUNT_IMPNEW
HDCARDHQSZS IMPDATARESULT
HDCARDHQSZS IMPINFO
HDCARDHQSZS IMPINFONEW
HDCARDHQSZS IMPINFO_BAK
HDCARDHQSZS IMPINFO_BAK1
HDCARDHQSZS IMPINFO_SCORE
HDCARDHQSZS IMPINFO_ZHENGSHI
HDCARDHQSZS SCOSUBJECTACCOUNTCHECK_IMPNEW
HDCARDHQSZS SCOSUBJECTACCOUNT_IMP
HDCARDHQSZS TEMPIMPINFO
OLAPSYS CWM2$AWCUBECREATEACCESS
OLAPSYS CWM2$AWDIMCREATEACCESS
OLAPSYS CWM2$AWVIEWCOLS
OLAPSYS CWM2$CLASSIFICATIONVALUEPAIR
OLAPSYS CWM2$HIERCUSTOMSORT
OLAPSYS CWM2$MRALL_AWVIEWCOLS
OLAPSYS CWM2$MRALL_AWVIEWS
OLAPSYS CWM2$MRALL_CATALOGS
OLAPSYS CWM2$MRALL_CATALOG_ENTITY_USES
OLAPSYS CWM2$MRALL_CUBE_MEASURES
OLAPSYS CWM2$MRALL_CWM1_AGGOP
OLAPSYS CWM2$MRALL_CWM1_AGGORD
OLAPSYS CWM2$MRALL_DESCRIPTORS
OLAPSYS CWM2$MRALL_DIM_ATTRIBUTES
OLAPSYS CWM2$MRALL_DIM_HIERS
OLAPSYS CWM2$MRALL_DIM_HIER_LEVEL_USES
OLAPSYS CWM2$MRALL_DIM_LEVEL_ATTR_MAPS
OLAPSYS CWM2$MRALL_ENTITY_DESC_USES
OLAPSYS CWM2$MRALL_ENTITY_EXT_PARMS
OLAPSYS CWM2$MRALL_ENTITY_PARAMETERS
OLAPSYS CWM2$MRALL_FACTTBLFCTMAPS
OLAPSYS CWM2$MRALL_FACTTBLKEYMAPS
OLAPSYS CWM2$MRALL_HIERDIMS
OLAPSYS CWM2$MRALL_HIERDIM_KEYCOL_MAP
OLAPSYS CWM2$MRALL_HIER_CUSTOM_SORT
OLAPSYS CWM2$MRALL_JOIN_KEY_COL_USES
OLAPSYS CWM2$MRALL_LISTDIMS
OLAPSYS CWM2$MRALL_OLAP2_AGG_USES
OLAPSYS CWM2$MRFACTTBLFCTMAPS
OLAPSYS CWM2$MRFACTTBLKEYMAPS
OLAPSYS CWM2$OLAPEXPORTCOMMANDTABLE
OLAPSYS CWM2$OLAPEXPORTOBJECTTABLE
OLAPSYS CWM2$OLAPMANAGERTABLE
OLAPSYS CWM2$OLAPVALIDATETABLE
OLAPSYS CWM2$STOREDDIMLVLTPLS
OLAPSYS CWM2$STOREDDIMLVLTPLSDTL
OLAPSYS CWM2$_AW_NEXT_PERM_CUST_MEAS
OLAPSYS CWM2$_AW_NEXT_TEMP_CUST_MEAS
OLAPSYS CWM2$_AW_PERM_CUST_MEAS_MAP
OLAPSYS CWM2$_AW_TEMP_CUST_MEAS_MAP
OLAPSYS CWM2$_TEMP_VALUES
OLAPSYS MRAC_OLAP2_AWS_T
OLAPSYS MRAC_OLAP2_AW_ATTRIBUTES_T
OLAPSYS MRAC_OLAP2_AW_CUBES_T
OLAPSYS MRAC_OLAP2_AW_CUBE_AGG_LVL_T
OLAPSYS MRAC_OLAP2_AW_CUBE_AGG_MEAS_T
OLAPSYS MRAC_OLAP2_AW_CUBE_AGG_OP_T
OLAPSYS MRAC_OLAP2_AW_CUBE_AGG_SPECS_T
OLAPSYS MRAC_OLAP2_AW_CUBE_DIM_USES_T
OLAPSYS MRAC_OLAP2_AW_CUBE_MEASURES_T
OLAPSYS MRAC_OLAP2_AW_DIMENSIONS_T
OLAPSYS MRAC_OLAP2_AW_DIM_LEVELS_T
OLAPSYS MRAC_OLAP2_AW_HIER_LVL_ORD_T
OLAPSYS MRAC_OLAP2_AW_MAP_ATTR_USE_T
OLAPSYS MRAC_OLAP2_AW_MAP_DIM_USE_T
OLAPSYS MRAC_OLAP2_AW_MAP_MEAS_USE_T
OLAPSYS MRAC_OLAP2_AW_PHYS_OBJ_PROP_T
OLAPSYS MRAC_OLAP2_AW_PHYS_OBJ_T
OLAPSYS OLAP_SESSION_CUBES
OLAPSYS OLAP_SESSION_DIMS
OLAPSYS OLAP_SESSION_OBJECTS
SCOTT BONUS
SCOTT SALGRADE
SPOTLIGHT QUEST_SOO_BUFFER_BUSY
SPOTLIGHT QUEST_SOO_EVENT_CATEGORIES
SPOTLIGHT QUEST_SOO_LOCK_TREE
SPOTLIGHT QUEST_SOO_PARSE_TIME_TRACK
SPOTLIGHT QUEST_SOO_PLAN_TABLE
SPOTLIGHT QUEST_SOO_SB_BUFFER_BUSY
SPOTLIGHT QUEST_SOO_SB_EVENT
SPOTLIGHT QUEST_SOO_SB_IO_STAT
SPOTLIGHT QUEST_SOO_VERSION
SYSMAN MGMT_ADMIN_METRIC_THRESHOLDS
SYSMAN MGMT_ARU_CREDENTIALS
SYSMAN MGMT_BACKUP_CONFIGURATION
SYSMAN MGMT_BCN_AVAIL_DEF
SYSMAN MGMT_BCN_AVAIL_JOB
SYSMAN MGMT_BCN_AVAIL_LOG
SYSMAN MGMT_BCN_TARGET
SYSMAN MGMT_BCN_TARGET_LOCK
SYSMAN MGMT_BCN_TARGET_TXN
SYSMAN MGMT_BCN_TXN_DEFN
SYSMAN MGMT_BCN_TXN_HTTP
SYSMAN MGMT_BCN_TXN_HTTP_PARAM
SYSMAN MGMT_BCN_TXN_PING
SYSMAN MGMT_BLACKOUT_REASON
SYSMAN MGMT_COMP_RESULT_TO_JOB_MAP
SYSMAN MGMT_COMP_TARGET_DEF
SYSMAN MGMT_DBNET_TNS_ADMINS
SYSMAN MGMT_DELTA_COMP_PROPERTIES
SYSMAN MGMT_DELTA_ENTRY
SYSMAN MGMT_DELTA_IDS
SYSMAN MGMT_DELTA_SUMMARY_ERRORS
SYSMAN MGMT_E2E_DETAILS
SYSMAN MGMT_E2E_DETAILS_1DAY
SYSMAN MGMT_E2E_DETAILS_1HOUR
SYSMAN MGMT_E2E_JDBC
SYSMAN MGMT_E2E_JDBC_1DAY
SYSMAN MGMT_E2E_JDBC_1HOUR
SYSMAN MGMT_E2E_SQL
SYSMAN MGMT_E2E_SQL_1DAY
SYSMAN MGMT_E2E_SQL_1HOUR
SYSMAN MGMT_E2E_SQL_CONN
SYSMAN MGMT_E2E_SQL_STMT
SYSMAN MGMT_E2E_SUMMARY
SYSMAN MGMT_E2E_SUMMARY_1DAY
SYSMAN MGMT_E2E_SUMMARY_1HOUR
SYSMAN MGMT_ECM_CSA_COOKIES
SYSMAN MGMT_ECM_CSA_CUSTOM
SYSMAN MGMT_ECM_HW_CPU
SYSMAN MGMT_ECM_HW_IOCARD
SYSMAN MGMT_ECM_HW_NIC
SYSMAN MGMT_ECM_OS_COMPONENT
SYSMAN MGMT_ECM_OS_FILESYSTEM
SYSMAN MGMT_ECM_OS_REGISTERED_SW
SYSMAN MGMT_ECM_OS_REGISTERED_SW_COMP
SYSMAN MGMT_FAILOVER_CALLBACKS
SYSMAN MGMT_FLAT_ROLE_GRANTS
SYSMAN MGMT_HC_CPU_DETAILS
SYSMAN MGMT_HC_FS_MOUNT_DETAILS
SYSMAN MGMT_HC_IOCARD_DETAILS
SYSMAN MGMT_HC_NIC_DETAILS
SYSMAN MGMT_HC_OS_COMPONENTS
SYSMAN MGMT_HC_VENDOR_SW_COMPONENTS
SYSMAN MGMT_JOB_EMD_STATUS_QUEUE
SYSMAN MGMT_JOB_EXEC_LOCKS
SYSMAN MGMT_JOB_LOCK_TARGETS
SYSMAN MGMT_JOB_NESTED_JOB_TARGETS
SYSMAN MGMT_JOB_PURGE_CRITERIA
SYSMAN MGMT_JOB_PURGE_TARGETS
SYSMAN MGMT_JOB_PURGE_VALUES
SYSMAN MGMT_JOB_SEC_INFO
SYSMAN MGMT_JOB_STEP_TARGETS
SYSMAN MGMT_JOB_TARGET
SYSMAN MGMT_JOB_TYPE_DISPLAY_INFO
SYSMAN MGMT_JOB_TYPE_DISPLAY_PARAM
SYSMAN MGMT_JOB_TYPE_URI_INFO
SYSMAN MGMT_LICENSES
SYSMAN MGMT_NOTIFICATION_LOG
SYSMAN MGMT_NOTIFY_DEVICE_PARAMS
SYSMAN MGMT_NOTIFY_REQUEUE
SYSMAN MGMT_NOTIFY_RULE_CONFIGS
SYSMAN MGMT_OB_ADMIN_CLIENT_DB
SYSMAN MGMT_OB_ADMIN_HOSTS
SYSMAN MGMT_OMS_PARAMETERS
SYSMAN MGMT_POLICY_ERRORS
SYSMAN MGMT_POLICY_PARAMS
SYSMAN MGMT_POLICY_RULE_CRITERIA
SYSMAN MGMT_POLICY_RULE_DEF_COLUMNS
SYSMAN MGMT_POLICY_RULE_DEF_PARAMS
SYSMAN MGMT_POLICY_SNAPSHOT_CRITERIA
SYSMAN MGMT_POLICY_TARGET_CRITERIA
SYSMAN MGMT_RCVCAT_CONFIG
SYSMAN MGMT_RCVCAT_REPOS
SYSMAN MGMT_REPOS_TIME_COEFFICIENT
SYSMAN MGMT_SEC_INFO
SYSMAN MGMT_SYSTEM_ERROR_LOG
SYSMAN MGMT_SYSTEM_PERFORMANCE_LOG
SYSMAN MGMT_TARGET_DELETE_CALLBACKS
SYSMAN MGMT_USER_CALLBACKS
SYSMAN MGMT_USER_FOLDERS
SYSMAN MGMT_VERSIONS
SYSMAN MGMT_VIEW_USER_CREDENTIALS
SYSMAN SYS_IOT_OVER_49772
SYSMAN SYS_IOT_OVER_49875
SYSMAN SYS_IOT_OVER_49878
TSMSYS SRS$
WMSYS SYS_IOT_OVER_10099
WMSYS WM$BATCH_COMPRESSIBLE_TABLES
WMSYS WM$CONS_COLUMNS
WMSYS WM$HINT_TABLE
WMSYS WM$LOCKROWS_INFO
WMSYS WM$MW_TABLE
WMSYS WM$NEXTVER_TABLE
WMSYS WM$REPLICATION_DETAILS_TABLE
WMSYS WM$RIC_LOCKING_TABLE
WMSYS WM$TMP_DBA_CONSTRAINTS
WMSYS WM$WORKSPACE_PRIV_TABLE
XUJM QUEST_SOO_BUFFER_BUSY
XUJM QUEST_SOO_EVENT_CATEGORIES
XUJM QUEST_SOO_LOCK_TREE
XUJM QUEST_SOO_PARSE_TIME_TRACK
XUJM QUEST_SOO_PLAN_TABLE
XUJM QUEST_SOO_SB_BUFFER_BUSY
XUJM QUEST_SOO_SB_EVENT
XUJM QUEST_SOO_SB_IO_STAT
XUJM QUEST_SOO_VERSION
253 rows selected.
Top
28. 没有索引的外键
OWNER TABLE_NAME CONSTRAINT_NAME COLUMN_NAME
DBSNMP MGMT_BSLN_INTERVALS BSLN_INTERVALS_FK1 BSLN_GUID
DBSNMP MGMT_BSLN_STATISTICS BSLN_STATISTICS_FK1 BSLN_GUID
DBSNMP MGMT_BSLN_THRESHOLD_PARMS BSLN_THRESHOLDS_FK2 DATASOURCE_GUID
EXFSYS EXF$EXPRSET REF_EXPRSET_ATTRSET EXSATSNM
EXFSYS RLM$JOBQUEUE RLM$JOINQREF RSET_NAME
EXFSYS RLM$JOBQUEUE RLM$JOINQREF RSET_OWNER
EXFSYS RLM$RULESET RLM$RSET_STATUS_REF RSET_STATUS
EXFSYS RLM$SCHACTLIST RLM$SCHACTFKEY RSET_NAME
EXFSYS RLM$SCHACTLIST RLM$SCHACTFKEY RSET_OWNER
EXFSYS RLM4J$RULESET RLM4JREFSRLMES DBEVSNM
MDSYS OGIS_GEOMETRY_COLUMNS FK_SRID SRID
MDSYS SDO_COORD_AXES COORD_AXIS_FOREIGN_AXIS COORD_AXIS_NAME_ID
MDSYS SDO_COORD_AXES COORD_AXIS_FOREIGN_UOM UOM_ID
MDSYS SDO_COORD_OPS COORD_OPERATION_FOREIGN_LEGACY LEGACY_CODE
MDSYS SDO_COORD_OPS COORD_OPERATION_FOREIGN_METHOD COORD_OP_METHOD_ID
MDSYS SDO_COORD_OPS COORD_OPERATION_FOREIGN_SOURCE SOURCE_SRID
MDSYS SDO_COORD_OPS COORD_OPERATION_FOREIGN_TARGET TARGET_SRID
MDSYS SDO_COORD_OP_PARAM_USE COORD_OP_PARA_USE_FOREIGN_PARA PARAMETER_ID
MDSYS SDO_COORD_OP_PARAM_VALS COORD_OP_PARA_VAL_FOREIGN_METH COORD_OP_METHOD_ID
MDSYS SDO_COORD_OP_PARAM_VALS COORD_OP_PARA_VAL_FOREIGN_PARA PARAMETER_ID
MDSYS SDO_COORD_OP_PARAM_VALS COORD_OP_PARA_VAL_FOREIGN_UOM UOM_ID
MDSYS SDO_COORD_OP_PATHS COORD_OP_PATH_FOREIGN_SOURCE SINGLE_OP_SOURCE_ID
MDSYS SDO_COORD_OP_PATHS COORD_OP_PATH_FOREIGN_TARGET SINGLE_OP_TARGET_ID
MDSYS SDO_COORD_REF_SYS COORD_REF_SYS_FOREIGN_CS COORD_SYS_ID
MDSYS SDO_COORD_REF_SYS COORD_REF_SYS_FOREIGN_DATUM DATUM_ID
MDSYS SDO_COORD_REF_SYS COORD_REF_SYS_FOREIGN_GEOG SOURCE_GEOG_SRID
MDSYS SDO_COORD_REF_SYS COORD_REF_SYS_FOREIGN_HORIZ CMPD_HORIZ_SRID
MDSYS SDO_COORD_REF_SYS COORD_REF_SYS_FOREIGN_LEGACY LEGACY_CODE
MDSYS SDO_COORD_REF_SYS COORD_REF_SYS_FOREIGN_PROJ PROJECTION_CONV_ID
MDSYS SDO_COORD_REF_SYS COORD_REF_SYS_FOREIGN_VERT CMPD_VERT_SRID
MDSYS SDO_DATUMS DATUM_FOREIGN_ELLIPSOID ELLIPSOID_ID
MDSYS SDO_DATUMS DATUM_FOREIGN_LEGACY LEGACY_CODE
MDSYS SDO_DATUMS DATUM_FOREIGN_MERIDIAN PRIME_MERIDIAN_ID
MDSYS SDO_ELLIPSOIDS ELLIPSOID_FOREIGN_UOM UOM_ID
MDSYS SDO_PRIME_MERIDIANS PRIME_MERIDIAN_FOREIGN_UOM UOM_ID
MDSYS SDO_UNITS_OF_MEASURE ELLIPSOID_FOREIGN_LEGACY LEGACY_CODE
MDSYS SDO_UNITS_OF_MEASURE UNIT_OF_MEASURE_FOREIGN_LEGACY LEGACY_CODE
MDSYS SDO_UNITS_OF_MEASURE UNIT_OF_MEASURE_FOREIGN_UOM TARGET_UOM_ID
OLAPSYS CWM$ARGUMENT CWM$ARGUMENT_FK PARAMETER_IRID
OLAPSYS CWM$CLASSIFICATION CWM$CLASSIFICATION_FK PROJECT_IRID
OLAPSYS CWM$CLASSIFICATIONENTRY CWM$CLASSIFICATIONENTRY_FK CLASSIFICATION_IRID
OLAPSYS CWM$CLASSIFICATIONTYPE CWM$CLASSIFICATIONTYPE_FK PROJECT_IRID
OLAPSYS CWM$CUBE CWM$CUBE_FK DATAMODEL_IRID
OLAPSYS CWM$DIMENSION CWM$DIMENSION_FK DATAMODEL_IRID
OLAPSYS CWM$DIMENSIONATTRIBUTE CWM$DIMENSIONATTRIBUTE_FK ITEMCONTAINER_IRID
OLAPSYS CWM$DOMAIN CWM$DOMAIN_FK DEFINITIONMODEL_IRID
OLAPSYS CWM$FACTLEVELGROUP CWM$FACTLEVELGROUP_FK FACTUSE_IRID
OLAPSYS CWM$FACTLEVELUSE CWM$FACTLEVELUSE_FK FACTLEVELGROUP_IRID
OLAPSYS CWM$FUNCTION CWM$FUNCTION_FK PROCESSMODEL_IRID
OLAPSYS CWM$HIERARCHY CWM$HIERARCHY_FK DIMENSION_IRID
OLAPSYS CWM$LEVEL CWM$LEVEL_FK DIMENSION_IRID
OLAPSYS CWM$MODEL CWM$MODEL_FK PROJECT_IRID
OLAPSYS CWM$MODEL CWM$MODEL_FK_1 MODEL_IRID
OLAPSYS CWM$OBJECTTYPE CWM$OBJECTTYPE_FK PROJECT_IRID
OLAPSYS CWM$OBJECTTYPE CWM$OBJECTTYPE_FK_1 CLASSIFICATIONTYPE_IRID
OLAPSYS CWM$PARAMETER CWM$PARAMETER_FK OPERATION_IRID
OLAPSYS CWM2$AWCOMPSPECMEMBERSHIP CWM2$AWCOMPSPECMEMBERSHIP_FK2 COMPOSITE_IRID
OLAPSYS CWM2$AWCUBECOMPPLAN CWM2$AWCUBECOMPPLAN_FK2 CUBECOMPSPEC_IRID
OLAPSYS CWM2$AWCUBELOADAGGPLAN CWM2$AWCUBELOADAGGPLAN_FK2 CUBEAGG_IRID
OLAPSYS CWM2$CLASSIFICATIONVALUEPAIR CWM2$CLASSVALUEPAIR_FK CLASSENTRY_IRID
OLAPSYS CWM2$CUBEDIMENSIONUSE CWM2$CUBEDIMENSIONUSE_CUBE_FK CUBE_IRID
OLAPSYS CWM2$CUBEDIMENSIONUSE CWM2$CUBEDIMENSIONUSE_DIM_FK DIMENSION_IRID
OLAPSYS CWM2$DIMHIERLVLMAP CWM2$DIMHIERLVLMAP_DHL_FK DIMHIERLVL_IRID
OLAPSYS CWM2$FACTDIMHIERTPLSDTL CWM2$FACTDIMHTD_CUBE_FK CUBE_IRID
OLAPSYS CWM2$FACTKEYDIMHIERLVLMAP CWM2$FACTKEYD_H_L_MAP_HIER_FK HIERARCHY_IRID
OLAPSYS CWM2$FACTKEYDIMHIERLVLMAP CWM2$FACTKEYD_H_L_MAP_LVL_FK LEVEL_IRID
OLAPSYS CWM2$FACTKEYDIMHIERMAP CWM2$FACTKEYDIMHIERMAP_DIM_FK DIMENSION_IRID
OLAPSYS CWM2$HIERLEVELREL CWM2$HIERLEVELREL_CLEVEL_FK CHILDLEVEL_IRID
OLAPSYS CWM2$HIERLEVELREL CWM2$HIERLEVELREL_DIM_FK DIMENSION_IRID
OLAPSYS CWM2$HIERLEVELREL CWM2$HIERLEVELREL_HIER_FK HIERARCHY_IRID
OLAPSYS CWM2$HIERLEVELREL CWM2$HIERLEVELREL_PLEVEL_FK PARENTLEVEL_IRID
OLAPSYS CWM2$LEVELATTRIBUTE CWM2$LEVELATTR_DIMATTR_FK DIMATTR_IRID
OLAPSYS CWM2$LEVELATTRIBUTE CWM2$LEVELATTR_DIM_FK DIMENSION_IRID
OLAPSYS CWM2$LEVELATTRIBUTEMAP CWM2$LVLATTRMAP_HIERLVLREL_FK HIERLVLREL_IRID
OLAPSYS CWM2$LEVELATTRIBUTEMAP CWM2$LVLATTRMAP_LVLATTR_FK LEVELATTR_IRID
OLAPSYS CWM2$MEASURETABLEMAP CWM2$MEASURETABLEMAP_FDHM_FK FACTDIMHIER_IRID
OLAPSYS CWM2$MEASURETABLEMAP CWM2$MEASURETABLEMAP_MEAS_FK MEASURE_IRID
SCOTT EMP FK_DEPTNO DEPTNO
SYSMAN MGMT_ECM_SNAPSHOT_MD_COLUMNS SMC_SMC_FK LINK_COLUMN_NAME
SYSMAN MGMT_ECM_SNAPSHOT_MD_TABLES SMT_SMT_FK PARENT_TABLE_NAME
SYSMAN MGMT_FLAT_ROLE_GRANTS MGMT_FLAT_ROLE_GRANTS_FK ROLE_NAME
SYSMAN MGMT_JOB_LOCK_TARGETS FK_JOB_LOCK_TARGETS JOB_TYPE
SYSMAN MGMT_JOB_LOCK_TARGETS FK_JOB_LOCK_TARGETS LOCK_GUID
SYSMAN MGMT_NOTIFY_DEVICES MGMT_NOTIFY_DEVICES_FK PROFILE_NAME
SYSMAN MGMT_NOTIFY_DEV_SCHEDULES MGMT_NOTIFY_DEV_SCHEDULES_DFK DEVICE_NAME
SYSMAN MGMT_NOTIFY_DEV_SCHEDULES MGMT_NOTIFY_DEV_SCHEDULES_DFK DEVICE_OWNER
SYSMAN MGMT_NOTIFY_NOTIFYEES MGMT_NOTIFY_NOTIFYEES_FKDEVICE DEVICE_NAME
SYSMAN MGMT_NOTIFY_NOTIFYEES MGMT_NOTIFY_NOTIFYEES_FKDEVICE PROFILE_NAME
SYSMAN MGMT_NOTIFY_PROFILES MGMT_NOTIFY_PROFILES_FK ESCALATION_PROFILE_NAME
SYSMAN MGMT_NOTIFY_RULES MGMT_NOTIFY_RULES_FK OWNER
SYSMAN MGMT_PLANPROBLEM_FACTORS SQL_PLAN_PROBFAC_EVAL_FK ADDRESS
SYSMAN MGMT_PLANPROBLEM_FACTORS SQL_PLAN_PROBFAC_EVAL_FK HASH_VALUE
SYSMAN MGMT_PLANPROBLEM_FACTORS SQL_PLAN_PROBFAC_EVAL_FK PLAN_HASH_VALUE
SYSMAN MGMT_PLANPROBLEM_FACTORS SQL_PLAN_PROBFAC_EVAL_FK REASON_CODE
SYSMAN MGMT_PRIV_GRANTS MGMT_PRIV_GRANTS_FK_PRIV_NAME PRIV_NAME
SYSMAN MGMT_PRIV_INCLUDES MGMT_PRIV_INCLUDES_FK_IPRIVNAM IPRIV_NAME
SYSMAN MGMT_ROLE_GRANTS MGMT_ROLE_GRANTS_FK_ROLE_NAME ROLE_NAME
SYSMAN MGMT_SQLPROBLEM_FACTORS SQL_PROBFAC_EVAL_FK ADDRESS
SYSMAN MGMT_SQLPROBLEM_FACTORS SQL_PROBFAC_EVAL_FK HASH_VALUE
SYSMAN MGMT_SQLPROBLEM_FACTORS SQL_PROBFAC_EVAL_FK PLAN_HASH_VALUE
SYSMAN MGMT_SQLPROBLEM_FACTORS SQL_PROBFAC_EVAL_FK REASON_CODE
101 rows selected.
Top
29. 建有6个以上索引的非系统表
TABLE_OWNER TABLE_NAME INDEX_COUNT
HDCARDHQSZS CARDINFO 8
HDCARDCTSZS CARDINFO 8
2 rows selected.
Top
30. 指向对象不存在的Public同义词
SYNONYM_NAME TABLE_OWNER TABLE_NAME
DBMS_AW_UTILITIES OLAPSYS DBMS_AW_UTILITIES
GV$DB_TRANSPORTABLE_PLATFORM SYS GV$_DB_TRANSPORTABLE_PLATFORM
GV$SESSION_FIX_CONTROL SYS GV$SESSION_FIX_CONTROL
GV$SYSTEM_FIX_CONTROL SYS GV$SYSTEM_FIX_CONTROL
GV$TRANSPORTABLE_PLATFORM SYS GV$_TRANSPORTABLE_PLATFORM
SDO_AVAILABLE_ELEM_OPS MDSYS SDO_AVAILABLE_ELEMENTARY_OPS
6 rows selected.
Top
31. 指向对象不存在的非Public同义词
OWNER SYNONYM_NAME TABLE_OWNER TABLE_NAME
SYS DEF$_SCHEDULE SYSTEM DEF$_SCHEDULE
1 rows selected.
Top
32. 没有授予给任何角色和用户的角色
ROLE
0 rows selected.
Top
33. 将System表空间作为临时表空间的用户(除Sys外)
USERNAME
0 rows selected.
Top
34. 将System表空间作为默认表空间的用户(除Sys外)
USERNAME
MGMT_VIEW
SYSTEM
OUTLN
3 rows selected.
Top
35. 没有授予给任何用户的profiles
PROFILE
0 rows selected.
Top
36. 没有和Package相关联的Package Body
OWNER OBJECT_NAME
0 rows selected.
Top
37. 被Disabled的约束
OWNER TABLE_NAME CONSTRAINT_NAME CONSTRAINT_TYPE
OLAPSYS CWM$DOMAIN CWM$DOMAIN_UK U
SYSTEM LOGMNR_ATTRCOL$ LOGMNR_ATTRCOL$_PK P
SYSTEM LOGMNR_ATTRIBUTE$ LOGMNR_ATTRIBUTE$_PK P
SYSTEM LOGMNR_CCOL$ LOGMNR_CCOL$_PK P
SYSTEM LOGMNR_CDEF$ LOGMNR_CDEF$_PK P
SYSTEM LOGMNR_COL$ LOGMNR_COL$_PK P
SYSTEM LOGMNR_COLTYPE$ LOGMNR_COLTYPE$_PK P
SYSTEM LOGMNR_DICTIONARY$ LOGMNR_DICTIONARY$_PK P
SYSTEM LOGMNR_DICTSTATE$ LOGMNR_DICTSTATE$_PK P
SYSTEM LOGMNR_ICOL$ LOGMNR_ICOL$_PK P
SYSTEM LOGMNR_IND$ LOGMNR_IND$_PK P
SYSTEM LOGMNR_INDCOMPART$ LOGMNR_INDCOMPART$_PK P
SYSTEM LOGMNR_INDPART$ LOGMNR_INDPART$_PK P
SYSTEM LOGMNR_INDSUBPART$ LOGMNR_INDSUBPART$_PK P
SYSTEM LOGMNR_LOB$ LOGMNR_LOB$_PK P
SYSTEM LOGMNR_LOBFRAG$ LOGMNR_LOBFRAG$_PK P
SYSTEM LOGMNR_OBJ$ LOGMNR_OBJ$_PK P
SYSTEM LOGMNR_TAB$ LOGMNR_TAB$_PK P
SYSTEM LOGMNR_TABCOMPART$ LOGMNR_TABCOMPART$_PK P
SYSTEM LOGMNR_TABPART$ LOGMNR_TABPART$_PK P
SYSTEM LOGMNR_TABSUBPART$ LOGMNR_TABSUBPART$_PK P
SYSTEM LOGMNR_TS$ LOGMNR_TS$_PK P
SYSTEM LOGMNR_TYPE$ LOGMNR_TYPE$_PK P
SYSTEM LOGMNR_USER$ LOGMNR_USER$_PK P
24 rows selected.
Top
38. 被Disabled的触发器
OWNER TABLE_NAME TRIGGER_NAME
EXFSYS EXPFIL_ALTEREXPTAB_MAINT
EXFSYS EXPFIL_DROPOBJ_MAINT
EXFSYS EXPFIL_DROPUSR_MAINT
EXFSYS EXPFIL_RESTRICT_TYPEEVOLVE
EXFSYS RLMGR_TRUNCATE_MAINT
SYS AURORA$SERVER$SHUTDOWN
SYS AURORA$SERVER$STARTUP
SYS CDC_ALTER_CTABLE_BEFORE
SYS CDC_CREATE_CTABLE_AFTER
SYS CDC_CREATE_CTABLE_BEFORE
SYS CDC_DROP_CTABLE_BEFORE
WMSYS NO_VM_DDL
WMSYS NO_VM_DROP_A
13 rows selected.
Top
39. Invalid Objects
OWNER OBJECT_NAME OBJECT_TYPE
EXFSYS EXPRESSIONINDEXMETHODS TYPE BODY
HDCARDHQSZS PIMP_CARD_HQS PACKAGE BODY
MDSYS SDO_GEOR_TRIG_DEL1 TRIGGER
MDSYS SDO_GEOR_TRIG_INS1 TRIGGER
MDSYS SDO_GEOR_TRIG_UPD1 TRIGGER
MDSYS SDO_LRS_TRIG_DEL TRIGGER
MDSYS SDO_LRS_TRIG_INS TRIGGER
MDSYS SDO_LRS_TRIG_UPD TRIGGER
PUBLIC ALL_APPLY SYNONYM
PUBLIC ALL_APPLY_ENQUEUE SYNONYM
PUBLIC ALL_APPLY_ERROR SYNONYM
PUBLIC ALL_APPLY_PARAMETERS SYNONYM
PUBLIC ALL_APPLY_PROGRESS SYNONYM
PUBLIC ALL_CAPTURE SYNONYM
PUBLIC ALL_CAPTURE_EXTRA_ATTRIBUTES SYNONYM
PUBLIC ALL_CAPTURE_PARAMETERS SYNONYM
PUBLIC ALL_PROPAGATION SYNONYM
PUBLIC ALL_QUEUES SYNONYM
PUBLIC ALL_QUEUE_TABLES SYNONYM
PUBLIC ALL_STREAMS_GLOBAL_RULES SYNONYM
PUBLIC ALL_STREAMS_MESSAGE_CONSUMERS SYNONYM
PUBLIC ALL_STREAMS_MESSAGE_RULES SYNONYM
PUBLIC ALL_STREAMS_RULES SYNONYM
PUBLIC ALL_STREAMS_SCHEMA_RULES SYNONYM
PUBLIC ALL_STREAMS_TABLE_RULES SYNONYM
PUBLIC DBA_JOBS_RUNNING SYNONYM
PUBLIC DBA_QUEUES SYNONYM
PUBLIC USER_QUEUES SYNONYM
PUBLIC X$BH SYNONYM
PUBLIC X$KGLOB SYNONYM
PUBLIC X$KSMLRU SYNONYM
PUBLIC X$KSUSE SYNONYM
XDB XDB_PV_TRIG TRIGGER
33 rows selected.
Top
40. 执行失败或中断的Jobs
JOB Last Date This Date BROKEN FAILURES SCHEMA_USER WHAT
0 rows selected.
Top
41. 当前未执行且下一执行日期已经过去的Jobs
JOB Last Date This Date BROKEN FAILURES SCHEMA_USER WHAT
0 rows selected.
Top
42. 含有未分析的非系统表的Schemas
Schema
EXFSYS
HDCARDCTSZS
HDCARDHQSZS
OLAPSYS
SYSMAN
WMSYS
6 rows selected.
Top
43. 含有未分析的非系统分区表的Schemas
Schema
0 rows selected.
Top
44. 含有未分析的非系统索引的Schemas
Schema
EXFSYS
OLAPSYS
SYSMAN
TSMSYS
WMSYS
5 rows selected.
Top
45. 含有未分析的非系统分区索引的Schemas
Schema
0 rows selected.
Top
46. 死锁检测
TABLE_NAME SESSION_ID SERIAL# ACTION OSUSER AP_PROCESS_ID DB_PROCESS_ID
0 rows selected.
Top
47. top I/O Wait
EVENT SEGMENT_TYPE SEGMENT_NAME FILE_ID BLOCK_ID BLOCKS
0 rows selected.
Top
48. top 10 wait
EVENT Prev Curr Total
SQL*Net message from client 0 29 29
rdbms ipc message 0 14 14
jobq slave wait 0 1 1
smon timer 0 1 1
pmon timer 0 1 1
Streams AQ: qmn slave idle wait 0 1 1
SQL*Net message to client 1 0 1
Streams AQ: qmn coordinator idle wait 0 1 1
Streams AQ: waiting for time management or cleanup tasks 0 1 1
9 rows selected.
Top
49. Top 10 bad SQL
EXECUTIONS SORTS COMMAND_TYPE DISK_READS SQL_TEXT
57 0 3 2925164 S
最低0.47元/天 解锁文章
扫一扫
1767
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
