-
编辑 删除
Materialized view refresh monitor
column "MVIEW BEING REFRESHED" format a30column INSERTS format 9999999column UPDATES format 9999999column DELETES format 9999999select x.sid_knst, x.serial_knst, CU...
-
编辑 删除
Managing Rollback/Undo Segments in Automatic Undo Management
Managing Rollback/Undo Segments in Automatic Undo Management:=============================================================This new feature simplifies and automates the management of undo s...
-
编辑 删除
How to Shrink the datafile of Undo Tablespace
How to Shrink the datafile of Undo Tablespace [ID 268870.1] 修改时间 17-AUG-2011 类型 HOWTO 状态 PUBLISHED In this Docu...
-
编辑 删除
Creating, Optimizing, and Understanding Rollback Segments [ID 62005.1]
Purpose This paper is a discussion on configuring a rollback segment tablespace that is designed to meet the needs of your database applications. ***Checked for relevance on 25-Jul-...
-
编辑 删除
ORA-01555: snapshot too old - Causes and Solutions [ID 1005107.6]
Problem Description:====================A transaction fails with an ORA-01555 error.ORA-01555: snapshot too old (rollback segment too small) Cause: rollback records needed by a reade...
-
编辑 删除
ORA-01555 "Snapshot too old" - Detailed Explanation [ID 40689.1]
ORA-01555 "Snapshot too old" - Detailed Explanation [ID 40689.1] 修改时间 01-OCT-2010 类型 BULLETIN 状态 PUBLISHED In t...
