Rman Notes -1
#—-Flash Recovery Area (FRA)——#
Year: 2008
Rman Notes -1
############## RMAN CATALOG ############## The recovery catalog contains information about RMAN operations, including: + Datafile and archived redo log backup sets and backup pieces + Datafile copies + Archived redo logs and their copies + Tablespaces and datafiles on the target database + Stored scripts, which are named user-created sequences of RMAN commands + Persistent…
find_log_switch.sql Find log switches in graphical manner
set linesize 100 set pagesize 100 column day format a15 heading ‘Day’ column d_0 format a2 heading ’00’ column d_1 format a2 heading ’01’ column d_2 format a2 heading ’02’ column d_3 format a2 heading ’03’ column d_4 format a2 heading ’04’ column d_5 format a2 heading ’05’ column d_6 format a2 heading ’06’ column…
Read More “find_log_switch.sql Find log switches in graphical manner” »
sql_plan9i.sql
set lines 132 set pages 1400 accept v_address prompt ‘Enter ADDRESS :’ accept v_hash_value prompt ‘Enter HASH VALUE :’ select sql_text from v$sqltext where address=’&v_address’ and hash_value=’&v_hash_value’ order by piece; SELECT LPAD(‘ ‘,2*(LEVEL-1))||operation||’ ‘||options ||’ ‘||object_name ||’ ‘|| DECODE(id, 0, ‘Cost = ‘||position) “Query Plan” FROM v$sql_plan START WITH id = 0 and address=’&v_address’ and…
find_idle_cpu.sql
spool /export/home/oracle/scripts/idle_cpu.txt set linesize 120 set pagesize 120 SELECT TO_CHAR (start_date, ‘DD-MON-RRRR:HH24:MI’) start_dt, user_cpu, system_cpu, idle_cpu, wait_cpu FROM stats$vmstat2 where idle_cpu=(SYSDATE – 1/48) AND ROWNUM
perf_today.sql
column start_dt format a20 column start_dt1 format a20 set lines 120 pages 300 select to_char(start_date, ‘DD-MON-RRRR:HH24:MI’) start_dt, user_cpu, system_cpu, idle_cpu, wait_cpu from STATS$VMSTAT2 where start_date > trunc(sysdate) order by start_date; select to_char(measured_date, ‘DD-MON-RRRR:HH24:MI’) start_dt, total_users, Active_users from STATS$TOTALUSERS where measured_date > trunc(sysdate) order by measured_date; select to_char(start_date, ‘DD-MON-RRRR:HH24:MI’) start_dt1, system_sessions, active_users, inactive_users, dedicated_servers, user_sessions, transactions…
pvm_rbs1.sql (to collect rbs info from db)
select segment_name, status from dba_rollback_segs order by status, segment_name; select status, count(1) from dba_rollback_segs group by status;
Find sort details from Db find_sort.sql
select sql_text,(executions-sorts) “Diff” from v$sqlarea where (executions-sorts) < 20 and executions > 100 order by 2 ; SELECT S.sid || ‘,’ || S.serial# sid_serial, S.username, T.blocks * TBS.block_size / 1024 / 1024 mb_used, T.tablespace, T.sqladdr address, Q.hash_value, Q.sql_text FROM v$sort_usage T, v$session S, v$sqlarea Q, dba_tablespaces TBS WHERE T.session_addr = S.saddr AND T.sqladdr = Q.address…
runsql_once.ksh
#!/bin/ksh # This parameter will be for executing environment file. $1 $ORACLE_HOME/bin/sqlplus -s “/ as sysdba”
send attachment from unix-shell script
#!/bin/ksh ORACLE_HOME=/oracle/app/oracle/product/9.2.0.8;export ORACLE_HOME ORACLE_SID=800P; export ORACLE_SID $ORACLE_HOME/bin/sqlplus -s “/ as sysdba”