Category Archives: Database Maintenance
ORA-01595: error freeing extent (3) of rollback segment (1))
ORA-01595: error freeing extent (3) of rollback segment (1))
How to delete duplicate records
delete from where rowid not in (
select min(rowid) from
group by );
delete from emp a where rowid >
any (select rowid from emp b where a.empid=b.empid);
delete from T t1 where t1.rowid >( select min(t2.rowID) from T t2
where t1.col1 = t2.col1 and t1.col2 = t2.col2);
Row chaining and Row Migration
Concepts: There are two circumstances when this can occur, the data for a row in a table may be too large to fit into a single data block. This can be caused by either row chaining or row migration.
Chaining: Occurs when the row is too large to fit into one data block when [...]
Import terminated successfully without warnings – But no Object imported
Import terminated successfully without warnings – But no Object imported
virtual circuit status, enq: TX – row lock contention, latch: shared pool – Values are High
virtual circuit status, enq: TX – row lock contention, latch: shared pool – Values are High
Performance Impact of temporary tablespace
Performance Impact of temporary tablespace
SGA Keep
SGA Keep
Move Tables Between Tablespaces
Move Table from one Tablespace to another Tablespace
TEMPORARY SEGMENTS or TEMPORARY TABLES
TEMPORARY SEGMENTS or TEMPORARY TABLES
List of sessions locked the particular Object
List of sessions locked the particular Object
I have attended Ask Tom Live seminar about 11g Rel2 at Tokyo, Japan. Do you believe it I have got an opportunity to take a snap with him. I am very happy to share with you.