When Oracle Software Directory Is Full
What will happen if the mount point of oracle software is 100% used or full? I guess you may feel panic due to a potentially… Read More »When Oracle Software Directory Is Full
Space Management
How to Alter Temporary Tablespace Offline
Offline a Temporary Tablespace Theoretically, you can't take the whole temporary tablespaces offline. SQL> alter tablespace temp offline; alter tablespace temp offline * ERROR at… Read More »How to Alter Temporary Tablespace Offline
How to Move Tables by SQL Script
I usually move some tables for data reorganization, and I found the procedure is pretty routine:Moving the table.Rebuilding indexes related to this table.Analyzing all segments… Read More »How to Move Tables by SQL Script
How to Get Tablespace DDL
We can compose the execution statement for getting the definition of all tablespaces by the following. SQL> select 'exec dbms_output.put_line(dbms_metadata.get_ddl(''TABLESPACE'',''' || tablespace_name || '''));' ddl… Read More »How to Get Tablespace DDL
How to Find Top IO on Data Files
In my case, I was planning to move some hot data files to a new mount point with SSD disks underneath, so I have to… Read More »How to Find Top IO on Data Files
Alter Database Move Datafile in Oracle
ALTER DATABASE MOVE DATAFILE After changing SPFILE location, changing control file location and changing redo logs location, we are going to move or rename data… Read More »Alter Database Move Datafile in Oracle
Must Dos after Moving a Table
Moving a table is actually a reorganization process, The database will copy the original data to the new place. In which, the data will be… Read More »Must Dos after Moving a Table
When Redo Log Files Are All Missing
If your redo logs are all missing, then you have to know you will lose some data and no longer to recover it. Now let's… Read More »When Redo Log Files Are All Missing
How to Reduce Chained Row
The chained row is a row which is too large to fit into one single data block when it is first inserted. In row chaining,… Read More »How to Reduce Chained Row
How to Resolve ORA-01562: failed to extend rollback segment number
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