ALL DB = Primary + DR databases. -> Implement checkfile concept so script will not page for planned maitenance. (1) Connect and update all Primary db for hang check. (2) Check for pmon for all db. (3) Check Alert log for ORA error for Primary database. (4) Purge Alert log of Primary and keep backup…
FROM TUNINGDB21 (Target) =============== tuningdb21*-/db1/home/oracle/paresh ==>ping 10.180.1.144 10.180.1.144 is alive tuningdb21*-/db1/home/oracle/paresh ==>ping oem2k.1800flowers.int ping: unknown host oem2k.1800flowers.int tuningdb21*-/db1/home/oracle/paresh ==>nslookup 10.180.1.144 *** Can’t find server name for address 127.0.0.1: Unspecified error *** Default servers are not available tuningdb21*-/db1/home/oracle/paresh ==>nslookup oem2k.1800flowers.int *** Can’t find server name for address 127.0.0.1: Unspecified error *** Default servers are not available…
exp userid=vivek file=ats_florist_zips_20MAY08.dmp log=ats_florist_zips_20MAY08.log grants=N indexes=N tables=ats.ats_florist_zips triggers=N statistics=None feedback=5000 imp userid=vivek file=ats_florist_zips_20MAY08.dmp log=imp_ats_florist_zips_20MAY08.log buffer=20971520 grants=N indexes=N fromuser=ats touser=5049 commit=Y constraints=N feedback=5000 statistics=None alter table “5049”.ATS_FLORIST_ZIPS rename to ats_florist_zips_05_20_2008;
D:oracle_homesagent10gBIN> emctl status agent D:oracle_homesagent10gBIN> emctl start agent D:oracle_homesagent10gBIN> emctl stop agent yantradevdb-YANTRAD> emctl getemhome yantradevdb-YANTRAD> emctl upload
Problem Description: ==================== You receive the following error: ORA-01562: “failed to extend rollback segment number %s” Cause: Failure occurred when trying to extend rollback segment Action: This is normally followed by another error message that caused the failure. You may take the rollback segment offline to perform maintainence. Use the alter rollback segment offline command…
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” »
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…
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
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…
select segment_name, status from dba_rollback_segs order by status, segment_name; select status, count(1) from dba_rollback_segs group by status;
