An introduction to system commands for newcomers to Linux In “Guide to Linux File Command Mastery,” we covered the basic information needed to take advantage of the most essential and commonly used Linux file commands. In this article, I’ll do the same with Linux system commands. As we learned in the previous article, everything is…
PS1=” `hostname`*${ORACLE_SID}-${PWD} ==>”
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…
############## 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…
#—-Flash Recovery Area (FRA)——#
A flash recovery area is a disk location in which the database can store and manage files related to backup and recovery. Some features of Oracle database backup and recovery, such as Oracle Flashback Database and guaranteed restore points, require the use of an FRA. However, having an FRA for use by these features does…
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
