Good links for x$ tables in oracle.
Explaination about X$tables http://www.stormloader.com/yonghuang/computer/x$table.html
dbinv.sql
set linesize 132 select owner, substr(object_name,1,30) objname , object_type from dba_objects where owner not in (‘SYS’, ‘SYSTEM’) and status = ‘INVALID’ order by owner, object_type, object_name;
myfile
**************************************************** File Name : a.sql **************************************************** create or replace view ats_dba_waiters as select /*+ all_rows */ w.session_id waiting_session, h.session_id holding_session, w.lock_type, h.mode_held, w.mode_requested, w.lock_id1, w.lock_id2 from ats_dba_lock w, ats_dba_lock h where h.blocking_others = ‘Blocking’ and h.mode_held != ‘None’ and h.mode_held != ‘Null’ and w.mode_requested != ‘None’ and w.lock_type = h.lock_type and w.lock_id1 = h.lock_id1 and…
ORACLE_SID in sqlplus
PURPOSE ========= To document one of the features of spooling in SQL*Plus. This article explains the behavior of “@” when used in the spooled file name. I checked for Unix and its working fine. This is an undocumented behavior of 10g sqlplus. How is “@” interpretted when used in spooled file name? ======================================================== When you…
compile_inv.sql
set pages 1000 spool compile_inv select ‘alter ‘ || object_type || ‘ ‘ || object_name || ‘ compile; ‘ from user_objects where status = ‘INVALID’; spool off
oracle_env_10g_CADEV
ORACLE_SID=CADEV;export ORACLE_SID ORACLE_HOME=/oracle/app/oracle/product/10.1;export ORACLE_HOME ORACLE_BASE=/oracle/app/oracle;export ORACLE_BASE LD_LIBRARY_PATH=/oracle/app/oracle/product/10.1/lib;export LD_LIBRARY_PATH PATH=/oracle/app/oracle/product/10.1/bin:/usr/ccs/bin:/usr/X/bin:/usr/openwin/bin:/usr/bin/X11:/usr/dt/bin:/usr/openwin/bin:/bin:/usr/bin:/usr/ucb:/usr/contrib/bin:/usr/local/bin:/usr/sbin:/usr/oracle/lib:/usr/proc/bin:/oracle/app/oracle/admin/shareplex/bin;export PATH ORA_NLS32=$ORACLE_HOME/ocommon/nls/admin/data;export ORA_NLS32 TNS_ADMIN=/oracle/app/oracle/product/10.1/network/admin;export TNS_ADMIN PFILE=/oracle/app/oracle/admin/CADEV/pfile;export PFILE UTL_DIR=/oracle/app/oracle/admin/CADEV/utl_dir;export UTL_DIR LOGS=/export/home/oracle/oraprocs/logs;export LOGS SCRIPTS=/export/home/oracle/oraprocs;export SCRIPTS ORAPROCS=/export/home/oracle/oraprocs;export ORAPROCS ORA_BDUMP=/oracle/app/oracle/admin/CADEV/bdump;export ORA_BDUMP ORA_CDUMP=/oracle/app/oracle/admin/CADEV/cdump;export ORA_CDUMP ORA_UDUMP=/oracle/app/oracle/admin/CADEV/udump;export ORA_UDUMP ORACLE_MAILING_LIST=”fdarwesh@1800flowers.com”;export ORACLE_MAILING_LIST NODENAME=`uname`;export NODENAME RPT=/export/home/oracle/projects/capacity/reports;export RPT BDUMP=/oracle/app/oracle/admin/CADEV/bdump;export BDUMP CDUMP=/oracle/app/oracle/admin/CADEV/cdump;export CDUMP UDUMP=/oracle/app/oracle/admin/CADEV/udump;export UDUMP EXPORT_BAK_DIR=/db7/export/backup;export EXPORT_BAK_DIR EXPORT_DIR=/db6/export/backup;export EXPORT_DIR
set_env_dba
# This File Sets all the Oracle Environment Variables and is called from # Each Users’s . profile file. B=`tput smso` N=`tput rmso` echo “” echo “Enter $B 1 $N to access Oracle 10.1.0.3 – TEST ” echo “” echo “Enter $B 2 $N to access Oracle 10.1.0.3 – UOCTEST ” echo “” echo “Enter…
.profile
#! /bin/ksh -x set -o vi stty erase EDITOR=vi;export EDITOR PATH=.:$PATH;export PATH . /oracle/oraprocs/set_env_dba stty erase ^H PS1=`uname -n`’->”$ORACLE_SID”@”(”$PWD”)’; /bin/perl /oracle/title.pl `uname -n` “->” “$ORACLE_SID” DISPLAY=192.168.4.112:0.0;export DISPLAY
rm_backup_arch_file.ksh
a=`ps -ef|grep $SCRIPT_NAME|grep -v grep|wc -l` if [ $a -gt 2 ] then echo “Exiting because of more than 1 Moving archive log script is running ” >>$LOGFILE exit fi cd $DESTFOLDER b=0 buffersize=85 currentdskspce=`df -k $DESTFOLDER|tail -1 |awk {‘print $5’}| sed ‘s/%//g’` echo “This $DESTFOLDER files removal script was executed on `date`” >>$LOGFILE while…
rm_backup_arch_file.ksh
DESTFOLDER=/uocdb7/archlog/UAS LOGFILE=/oracle/scripts/log/rm_backup_arch_uas.log NOTIFY_LIST=’dbaoracle@1800flowers.com’ NODENAME=`hostname` ORACLE_SID=UAS SCRIPT_NAME=rm_backup_arch_file.ksh