摘要: Master Note: High Undo Space Usage (Doc ID 1578639.1) APPLIES TO: Oracle Database Cloud Schema Service - Version N/A and laterOracle Database Exadata 阅读全文
posted @ 2019-12-01 10:45 ZYLONG-SYS 阅读(828) 评论(0) 推荐(0) 编辑
摘要: Automatic Tuning of Undo Retention Common Issues (Doc ID 1579779.1) APPLIES TO: Oracle Database - Enterprise Edition - Version 12.1.0.2 to 12.1.0.2 [R 阅读全文
posted @ 2019-12-01 09:42 ZYLONG-SYS 阅读(879) 评论(0) 推荐(0) 编辑
摘要: FAQ – Automatic Undo Management (AUM) / System Managed Undo (SMU) (Doc ID 461480.1) APPLIES TO: Oracle Database - Enterprise Edition - Version 9.0.1.4 阅读全文
posted @ 2019-12-01 00:14 ZYLONG-SYS 阅读(517) 评论(0) 推荐(0) 编辑
摘要: How To Size UNDO Tablespace For Automatic Undo Management (Doc ID 262066.1) APPLIES TO: Oracle Database - Enterprise Edition - Version 9.2.0.1 to 11.2 阅读全文
posted @ 2019-11-30 22:17 ZYLONG-SYS 阅读(260) 评论(0) 推荐(0) 编辑
摘要: How to Determine the Value Of UNDO_RETENTION Parameter to Avoid ORA-1555 (Doc ID 822411.1) APPLIES TO: Oracle Database - Enterprise Edition - Version 阅读全文
posted @ 2019-11-30 22:02 ZYLONG-SYS 阅读(1032) 评论(0) 推荐(0) 编辑
摘要: Script - Check Current Undo Configuration and Advise Recommended Setup (Doc ID 1579035.1) APPLIES TO: Oracle Database - Enterprise Edition - Version 8 阅读全文
posted @ 2019-11-30 21:46 ZYLONG-SYS 阅读(392) 评论(0) 推荐(0) 编辑
摘要: SRDC - ORA-30036: Checklist of Evidence to Supply (Doc ID 1682700.1) Action Plan 1. Execute srdc_db_undo_ora-30036.sql and collect the spool output. - 阅读全文
posted @ 2019-11-30 15:59 ZYLONG-SYS 阅读(246) 评论(0) 推荐(0) 编辑
摘要: Troubleshooting ORA-30036 - Unable To Extend Undo Tablespace (Doc ID 460481.1) APPLIES TO: Oracle Database - Enterprise Edition - Version 9.2.0.1 to 1 阅读全文
posted @ 2019-11-30 15:56 ZYLONG-SYS 阅读(647) 评论(0) 推荐(0) 编辑
摘要: Action Plan 1. Execute srdc_db_undo_ora-30013.sql as sysdba and provide the spool output --srdc_db_undo_ora-30013.sql REM srdc_db_undo_ora-30013.sql R 阅读全文
posted @ 2019-11-30 15:27 ZYLONG-SYS 阅读(211) 评论(0) 推荐(0) 编辑
摘要: Troubleshooting ORA-30013 Error (Doc ID 1578717.1) APPLIES TO: Oracle Database - Enterprise Edition - Version 10.2.0.1 to 12.1.0.1 [Release 10.2 to 12 阅读全文
posted @ 2019-11-30 15:25 ZYLONG-SYS 阅读(564) 评论(0) 推荐(0) 编辑
摘要: SRDC - ORA-1628: Checklist of Evidence to Supply (Doc ID 1682729.1) Action Plan 1. Execute srdc_db_undo_ora-1628.sql as sysdba and collect the spool o 阅读全文
posted @ 2019-11-30 15:16 ZYLONG-SYS 阅读(263) 评论(0) 推荐(0) 编辑
摘要: Troubleshooting ORA-1628 - max # extents (32765) reached for rollback segment <SEGMENT_NAME> (Doc ID 1580182.1) APPLIES TO: Oracle Database Cloud Sche 阅读全文
posted @ 2019-11-30 15:15 ZYLONG-SYS 阅读(1438) 评论(0) 推荐(0) 编辑
摘要: SRDC - ORA-1562: Checklist of Evidence to Supply (Doc ID 1682728.1) Action Plan 1. Execute srdc_db_undo_ora-1562.sql as sysdba and provide the spool o 阅读全文
posted @ 2019-11-30 14:52 ZYLONG-SYS 阅读(245) 评论(0) 推荐(0) 编辑
摘要: ORA-1562 and ORA-1650 Unable to Extend Rollback Segment (Doc ID 1066542.6) APPLIES TO: Oracle Database - Enterprise Edition - Version 8.0.3.0 and late 阅读全文
posted @ 2019-11-30 14:47 ZYLONG-SYS 阅读(641) 评论(0) 推荐(0) 编辑
摘要: SRDC - ORA-1548: Checklist of Evidence to Supply (Doc ID 1682693.1) Action Plan 1. Execute srdc_db_undo_1548.sql and provide the spool output --srdc_d 阅读全文
posted @ 2019-11-30 14:33 ZYLONG-SYS 阅读(202) 评论(0) 推荐(0) 编辑
摘要: APPLIES TO: Oracle Database Cloud Schema Service - Version N/A and laterOracle Database Exadata Cloud Machine - Version N/A and laterOracle Database E 阅读全文
posted @ 2019-11-30 14:29 ZYLONG-SYS 阅读(456) 评论(0) 推荐(0) 编辑
摘要: SRDC - ORA-22924 or ORA-1555 on LOB data: Checklist of Evidence to Supply (Doc ID 1682707.1) Action Plan 1. Check for LOB Corruption using srdc_corrup 阅读全文
posted @ 2019-11-30 13:50 ZYLONG-SYS 阅读(413) 评论(0) 推荐(0) 编辑
摘要: LOBs and ORA-01555 troubleshooting (Doc ID 846079.1) APPLIES TO: Oracle Database Cloud Schema Service - Version N/A and laterOracle Database Exadata E 阅读全文
posted @ 2019-11-30 13:41 ZYLONG-SYS 阅读(713) 评论(0) 推荐(0) 编辑
摘要: SRDC - ORA-1555 during Export: Checklist of Evidence to Supply (Doc ID 1682706.1) Action Plan 1. Execute srdc_db_undo_1555-1.sql as sysdba and collect 阅读全文
posted @ 2019-11-30 13:00 ZYLONG-SYS 阅读(282) 评论(0) 推荐(0) 编辑
摘要: Troubleshooting ORA-01555/ORA-01628/ORA-30036 During Export and Import (Doc ID 1579437.1) APPLIES TO: Oracle Database - Enterprise Edition - Version 9 阅读全文
posted @ 2019-11-30 12:49 ZYLONG-SYS 阅读(442) 评论(0) 推荐(1) 编辑
摘要: SRDC - ORA-1555: Query Duration 0: Checklist of Evidence to Supply (Doc ID 1682704.1) Action Plan 1. Execute srdc_db_undo_1555-1.sql as sysdba and pro 阅读全文
posted @ 2019-11-30 11:51 ZYLONG-SYS 阅读(239) 评论(0) 推荐(0) 编辑
摘要: Troubleshooting ORA-01555 - Snapshot Too Old: Rollback Segment Number "String" With Name "String" Too Small (Doc ID 1580790.1) APPLIES TO: Oracle Fusi 阅读全文
posted @ 2019-11-30 11:16 ZYLONG-SYS 阅读(1526) 评论(0) 推荐(0) 编辑
摘要: ORA-01555 When Max Query Length Is Less Than Undo Retention, small or 0 Seconds (Doc ID 1131474.1) APPLIES TO: Oracle Database - Enterprise Edition - 阅读全文
posted @ 2019-11-30 10:33 ZYLONG-SYS 阅读(384) 评论(0) 推荐(0) 编辑
摘要: SRDC - ORA-1552: Checklist of Evidence to Supply (Doc ID 1681333.1) Action Plan 1. Execute srdc_db_undo_config.sql as sysdba and provide the spool out 阅读全文
posted @ 2019-11-30 10:02 ZYLONG-SYS 阅读(242) 评论(0) 推荐(0) 编辑
摘要: Troubleshooting Guide (TSG) - ORA-01552: Cannot Use System Rollback Segment for Non-System Tablespace (Doc ID 1579215.1) APPLIES TO: Oracle Database - 阅读全文
posted @ 2019-11-30 09:40 ZYLONG-SYS 阅读(1662) 评论(0) 推荐(0) 编辑
摘要: Master Note: Troubleshooting guide for Automatic Undo Management (Doc ID 1579081.1) APPLIES TO: Oracle Database - Enterprise Edition - Version 9.2.0.1 阅读全文
posted @ 2019-11-29 15:57 ZYLONG-SYS 阅读(428) 评论(0) 推荐(0) 编辑