Query – Tablespace Max Size

I sometimes see concerned emails from developers that they are running out of space in tablespace and the DBA need to do something immediately. The DBA will start wondering we have monitoring in place, then how come it did not catch an out of space situation, but a user/developer did… For you developer/user, if you … Read more

Rename Diskgroup in ASM

Rename ASM Diskgroup [11gR2] In 11gR2 it is possible to rename an ASM diskgroup. This is especially useful when performing database copy using OS level LUN mirroring technologies. The renamedg command is used to rename diskgroups. It has the following options: $ renamedg -help Parsing parameters.. phase                           Phase to execute,                                 (phase=ONE|TWO|BOTH), default BOTH dgname                          … Read more