Moving Datafile using ASMCMD “cp” command – 11gR2

Few months back i wrote "Moving datafile from one diskgroup to another in ASM – 10.2.0.4" where i used RMAN and DBMS_FILE_TRANSFER methods to move the datafile between the diskgroups. From 11gR1, Oracle introduced "cp" command in asmcmd utility. cp Command Purpose Enables you to copy files between ASM disk groups on local instances to … Continue reading Moving Datafile using ASMCMD “cp” command – 11gR2

Can Table Stats be Stale even after locking its statistics?

Few day back i was asked by one of my friends, does the stats gets stale even after its locked? To put it in another words, after locking the table stats using LOCK_TABLE_STATS, does oracle mark the stats as STALE after heavy DML is done the particular table? SQL> select * from v$version; BANNER -------------------------------------------------------------------------------- … Continue reading Can Table Stats be Stale even after locking its statistics?

Oracle Restart – 11gR2

Oracle Restart is the new feature introduced by Oracle in 11gR2 which ensures that various Oracle components gets automatically restarted after hardware or software failures.This feature depends on OHAS (Oracle High Availability Service) daemon and is only for standalone server environment.The various components which gets automatically restarted as part of Oracle Restart are :- 1. … Continue reading Oracle Restart – 11gR2