Oracle Database Commands and Practical Examples

Copying  Archive log  from ASM to local file system using script  Set archivelog  in ASM location (OPTIONAL) SQL> ALTER SYSTEM SET log_ar...

Example - Create SQL Tuning Set Step 1) Login source database  and  Create SQL Tuning Set BEGIN   DBMS_SQLTUNE.CREATE_SQLSET ( sqlset_name =...

 To get cluster stack health status $crsctl check crs Check visibility of CRS across nodes $crsctl check cluster -n node_name Stop/Start Clu...