Automate CPU utilization metrics (from SAR)

Table has to be created for capturing the CPU Utilization and save it to Database.

   

Oracle : Cloning user in Database

 

ASM Disk Group Performance Summary

SET TERMOUT OFF; COLUMN current_instance NEW_VALUE current_instance NOPRINT; SELECT rpad(sys_context(‘USERENV’, ‘INSTANCE_NAME’), 17) current_instance FROM dual; SET TERMOUT ON; SET ECHO OFF SET FEEDBACK 6 SET HEADING ON SET LINESIZE 256 SET PAGESIZE 50000 SET TERMOUT ON SET TIMING OFF SET TRIMOUT ON SET TRIMSPOOL ON… Read More

Oracle Database Restore archivelogs from Sequence to Sequence Based on the Dates we give.

select ‘restore archivelog from logseq ‘|| min(sequence#) || ‘ until logseq ‘ || max(sequence#) || ‘ thread ‘ || thread# || ‘;’from gv$archived_logwhere completion_time between to_date(‘&start_date’,’DD-MON-YY HH24:MI:SS’) AND to_date(‘&end_date’,’DD-MON-YY HH24:MI:SS’) group by thread#;     Input Required: Enter value for start_date: 02-OCT-16 Enter value for… Read More