Oracle DBA Quick Scripts Quotes

“FOR c1 IN (SELECT OWNER,table_name, constraint_name FROM dba_constraints WHERE constraint_type = 'R' and owner=upper('&shema_name')) LOOP EXECUTE IMMEDIATE 'ALTER TABLE '||' "'||c1.owner||'"."'||c1.table_name||'" DROP CONSTRAINT ' || c1.constraint_name; END LOOP; FOR c1 IN (SELECT owner,object_name,object_type FROM dba_objects where owner=upper('&shema_name')) LOOP BEGIN IF c1.object_type = 'TYPE' THEN EXECUTE IMMEDIATE 'DROP '||c1.object_type||' "'||c1.owner||'"."'||c1.object_name||'" FORCE'; END IF; IF c1.object_type != 'DATABASE LINK' THEN EXECUTE IMMEDIATE 'DROP '||c1.object_type||' "'||c1.owner||'"."'||c1.object_name||'"'; END IF; EXCEPTION WHEN OTHERS THEN NULL; END;”
― Arun Kumar, Oracle DBA Quick Scripts: Oracle dba scripts collection used by expert database administrators everyday. Must have dba scripts for your daily activities!

“SELECT SID, SERIAL#, USERNAME, CONTEXT, SOFAR, TOTALWORK, ROUND(SOFAR/TOTALWORK*100,2) "%_COMPLETE" FROM V$SESSION_LONGOPS WHERE TOTALWORK != 0 AND SOFAR <> TOTALWORK;”
― Arun Kumar, Oracle DBA Quick Scripts: Oracle dba scripts collection used by expert database administrators everyday. Must have dba scripts for your daily activities!

“select log_id, log_date, owner, job_name from ALL_SCHEDULER_JOB_LOG where job_name like 'RMAN_B%' and log_date > sysdate-2; select log_id,log_date, owner, job_name, status, ADDITIONAL_INFO from ALL_SCHEDULER_JOB_LOG where log_id=113708;”
― Arun Kumar, Oracle DBA Quick Scripts: Oracle dba scripts collection used by expert database administrators everyday. Must have dba scripts for your daily activities!