How to Resolve Standby ORA-00600 [3020]
ORA-00600 [3020] Found MRP shutdown with ORA-00600 [3020] in alert log of a standby database due to inconsistency of a newly created data file. Wed… Read More »How to Resolve Standby ORA-00600 [3020]
Undo Tablespace
How to Resolve ORA-01555 UNDO_RETENTION
ORA-01555 UNDO_RETENTION Let's see the error ORA-01555 UNDO_RETENTION first: Description ORA-01555: snapshot too old: rollback segment number string with name "string" too small Cause rollback… Read More »How to Resolve ORA-01555 UNDO_RETENTION
UNDO_RETENTION, How and Why
UNDO_RETENTION At times, you may find out or feel that UNDO_RETENTION is useless at all. Raising the number of seconds cannot resolve ORA-01555. This is… Read More »UNDO_RETENTION, How and Why
Oracle Undo Tablespace Usage
The first purpose of using UNDO is for storing all uncommitted data in case we need to undo uncommitted data in rollback or after system… Read More »Oracle Undo Tablespace Usage
How to Check Tablespace Size in Oracle
After having the whole picture about the size of the database, we can further check Oracle tablespace usage solely by SQL. Oracle Tablespace Usage Of… Read More »How to Check Tablespace Size in Oracle
How to Resolve ORA-30036 UNABLE TO EXTEND SEGMENT BY 8 IN UNDO TABLESPACE 'UNDOTBS1'
ORA-30036 This error ORA-30036 could be very serious in a situation that is described below and may make users panic: One day, a DBA was… Read More »How to Resolve ORA-30036 UNABLE TO EXTEND SEGMENT BY 8 IN UNDO TABLESPACE 'UNDOTBS1'