摘要: 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 阅读(443) 评论(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) 编辑