Found repeated errors in the alert log:...ORA-01562: failed to extend rollback segment number 96...It seemed that some transactions were doing DML, but they failed to… Read More »How to Resolve ORA-01562: failed to extend rollback segment number
ORA-25153 After activating a physical standby database, I found some SQL statements returned ORA-25153: Description ORA-25153: Temporary Tablespace is Empty Cause An attempt was made… Read More »How to Resolve ORA-25153: Temporary Tablespace is Empty
Found repeated errors in one alert log of RAC:Fri Oct 10 17:12:10 2015ORA-1652: unable to extend temp segment by 128 in tablespace … Read More »How to Resolve ORA-01652 or ORA-1652: unable to extend temp segment by 128 in tablespace TEMP
For manual segment space management (MSSM), we have to define the two parameters in a table in order to meet our target space plan. Let… Read More »What is Difference Between PCT_FREE and PCT_USED
Do you know how large is your database? And how much space has been used? Here is an example to check it out.column "DB Name"… Read More »How to Check Database Overall Space Usage
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'