
Vinod Dhandapani
blogs from Chennai


Latch Oracle SGA consists of numerous data structures such as Buffer Cache, Shared pool, Library cache, Dictionary cache, redo log buffer etc. Many oracle processes need to access these SGA data structures concurrently. Though these SGA components are shared, only one process must be able to modify...
Posted on 1 August 2013 | 5:20 pm
Read postThe segment shrink is done online. During shrink operation, the conventional DML operations can coexist but parallel DMLs cannot. During segment shrink, data will be moved as part of the compaction phase. During compaction locks will be held on individual rows and/or blocks containing the data. This...
Posted on 1 August 2013 | 4:42 pm
Read postProblem: I have lost some of the archivelog files without taking backup. If I run the rman to backup available archive logs, it throws error that the archivelog_seq# is not available.Solution: run the following command.RMAN> change archivelog all validate;Now you run the backup archivelog command. R...
Posted on 10 February 2011 | 5:12 pm
Read post