Monthly Archives: August 2012

Enabling / Disabling Flashback Database in 11gR2 without recycling database

Flashback database offer a simple way for performing a point in time recovery. This feature was introduced in oracle 10g. Let’s take a scenario, where we have generated huge amount of flashback logs. Now to reclaim the space, we can … Continue reading

Posted in Oracle 11.2.0.x, Oracle 11g Enhancements | Tagged | 5 Comments

ASM DISKGROUP RESIZE in 10g & 11g

ASM diskgroup is full and we want to add space to diskgroup. We have 2 options here 1. Add new disks depending on type of diskgroup / number of failgroups 2. Increase the size of the existing LUN / LV … Continue reading

Posted in Oracle Automatic Storage Management | Tagged | 3 Comments

Deferred Segment Creation / Segment Creation On Demand

“Deferred Segment Creation” is a new feature introduced in 11g. Where oracle will create tables, but will not allocate the initial storage immediately. Storage is allocated when first row is added in the table. A small example – SQL> create … Continue reading

Posted in Oracle 11.2.0.x, Oracle 11g Enhancements | Tagged | Leave a comment