Oracle DBA: Backup and Recovery Scripts By Rajendra GuttaFull description
Sample Resume of Oracle DBAFull description
Best practices for Oracle DBA. From 2004
Best practices for Oracle DBA. From 2004Full description
Full description
Full description
An Oracle DBA handbook. Covers 9i to 11g. Discusses Oracle database instance, file structure, backup recovery and performance tuning. Also includes a list of Oracle interview questions.Full description
Oracle DBA Material Draft
Oracle Apps SQL Queries
c c c cc c c c c ! c " cc c c c #c $ %c& &c ' ( cc c c ! cc )! *+ &cc,
- & c .c c& ' c/
0c / cc c c c -&c c 1 c c&1 . c 2)1 - )c 0. 0& &c 2 c ' ! &c 2 3+c%c 4 c c &c c c c
c c 5561 15724 6 c 8c c0c c 2 & c 5561 1 c c5512 1 c c c ( c c c 24 c cc cc
c c& 24 c & c& cc 2
c c c '24 ccc 9 &c c 8 !c 22
c cc c !:# 2 ;?c @ !=!>?c c@ = >?c @ 16?ABA)746>CA).52CA).5>5C66A68*@ 16?DEC)6A><.A0 0 0 2' F+)..# c c . #c c 4 c c c c& c & c$ && c cc &c c c c c c&c cc c !c c c c c 21 c ' c ).c)c c c 9 2 G+ 7C6c c c % c2 00c 2c 0 c * 0 00c 2c c 0 c 0 8H1 00c 2c >c 0 c 0 8C" 00c 2c c 0 c 08H1 I+ c + cC2328 ' c c J c c J c! c 2& / /c J (
c& 24 c+
c c c24c ) & c c ' J
& 2 H&>c>c B.6& cc& 2 ")c& c c c c& !c c& c& c )c ' c c c 24)c& Cc c . !c c & c&c c 2& c & Cc )c& Cc c. c & c c c c& c 2 + c c c c )c& Cc c. c & c c c c c 2 $+ c 2 & 4c 2 & c E556>450 & c cc& c& J & <4.6& JCA8J C A c & 2 & c c c & 2 *<.A0 0 E& c
3450 0 0c9)c 2c ;+ 2& &c + ,& c& & + , & c& & E1>C)6A><.A00c'0& 4 & c>'cc c& cc c 21cc 00c c 001 8 + 1 & ' &c 00 ' cc>cc ! & %! & 1 F+ c . 2 ). )c . c . 1 . + . c c& ' 2 )C.)c& Cc c. c c& c& c 24 c. 4 c&c c2) c)c . 4 & 2 G 2 &I& 4& c& c& & c&c c2 6c E556>450 0=1?0 &c cc 2 !2 !"& 1.56A:6A 8c !H"2 &I NNN & &c 232 6c cE556>450 0=1?0cc 2 '&
I+ 2&c >E)#4AB42& c % 4 & & c :C.1;H>+A>)#:O>:6A4 c E><4.60 c E:#1>450Cc c&c 24 & &c c2+ c&c &;H ( ! & c c& c& &c c c 0 2 "H)cc& c c c c % 4 cc C )c "c c ! c&c c & c C )c c 7 Oc c c c& c2 ""+ 2 & c c&2 & & c c & c c c &c c c cc c 24 & c E:#>450 c:#>1A)7CA "$+ c . 7 c c c !cc c cc 9
7& & 1 556>45 -8. c
"*450 030'0 2' "3+ cc c Q cc c cc c cc& !>(
!& c c 9cc c c c cc ' "; &c c c& cc&& 2 & c2 &c (2/ < =& ? "F+ c c c 2
"G
29 8c>c*9 H1%c>9 ' c&JQ.2 $+ c& JQ.c JQ.cc c & 9 28&c E1>C)6A><.A000 JQ.c& c & JQ.6OC 8E1>C)6A><.A00J 0c09 c& & 14746O% 14ACC6O2A(c&JQ.c& )c O c2H2 )c O c2H2 c cO c2H2 c cO c2H2 B1 O 2H2 B1 O 2H2 c Hc & JQ.%c cJQ.2 c c c JQ.% c c c &c c !O)22 $"
c 8Rc& c E c c !,NJ)N, c $$+ c >c c >c+ & c cc& & A c >c c c 0 & 2 4 & c c & 2c& & c c E1>C)6A><.A000c2 $*+ >c c >c+ & c cc& & >c c1 c c c 2 4 & c c & 2c& & c c E1>C)6A><.A000c2 $3+ J c& c& c J c& c& c E1>C)6A><.A00J 0 $;+ c& c& + 1 8 . c& c& + 1 2c& >2c& 9 2c& 9 2 c -c2 c
$F+ c c % c& c c c c& c 1&1 c1 c81 + 1 1%J !
C 5 c :c c8 c &c c ! c + 1 c & c c
&c c c 1 c% c& c &c c& c c c8 c &c %& & c c c c& c& 2 : c:#2Oc 232Ic c cc&6c6c 29 c c c c& c c /)B1 c4 c / c c :c 1 c c 2 4 c& c& c c cc c&c & c8 c2 c c2 c cc c c c &c 1&1 c81 J JQ. : c )B1 c4 c % c2 c cc& &c c& c c/)B1 c4 c // c2 c /& c
c ( & 8E556>450 01>c 2( > c c cc c& c c)B1 c4 c c > c 08HHHR;H H. 24 c -c2 c E1>C)6A><.A00J 0 c c
22;HHHHH8' cH. c2 c P;HHHHH c2 c c -c2 c c)B1 c4 c c c& c c)B1 c4 c
c)B c c P$H% c2 c PGHHHHH $H $G+ c + Q cc c& E1>C)6A><.A000
20 c 1 c <4451 5c 02$2I 1 "HH*3I$8 12H2"2"2" c3 $I#.A& c&> c > c@ *H+ c c& & % c )& ' c J c c c !&c cc c & 24 & O7A14>71AC>5+551>J)>7C6><14 *4 c c& & E:#>1A)7CA1A)7CA 4 & c c& c c/ c / *"+ CC0:#:1 Cc C 8CCc & ( :#:1 & ( c &c c & %c& 2 *$+ 5)5 c 5)5 c&c 5 )c 5 c 27c c)c . ( c ' &cc& )c . c c 8 c ccc c c cc& 5 )c 5 c 21c&c cc&
c ' ).#c c c ).cc "&c c ' ). c "%c ).c 2 **+ c& 6 c c #c 551>E1 &c ' &c !:#:1%:#1.2 :#:1:#: 1 c!cCCCc C c ( & 2 :#1.:#1 . c O1. ' !)., *3c 9 !,#Q6,@ *;+ && %c cc c c c *F+ &c ( # &;H *G+ && cc&&c c :c 1 c & c &c 1)SA4c 1ACQ6A4 & :c c& c c! c
002 c 2c0"HH0"0&c c c! c 2 *I+ <4.6) c 1 <4.6) E)..#>450>&c c c cc &
E><4.60> 3H+ H% :#)511:#6c +:6 H% &&c :#A( !:#)511%:#6 H ' 8 ' H c ' , c 1 )c C' :c 2 , , cc& c c2 22 c!& c c c & c 1 C' :c 2 3+ 4+>41S 4+>41Sc!c c c c cc c 26 c & 5C cc c 5Cc c 2c cc 3"24 cc ' 0D5C@c &cc, cD5C c 4+>41SP5C ' 0 ' ! c c c & 5C 224+>41S 3"+ O+ 7 O+ 7 &c O 7 c 27 !5561 157057
3$+ O+ 7& % c O+ 7 & 22 )c c & 2 cc c 2 3*c@ 3F+ && 1c! %1 .c :c 002 c 2c0"HH0"0&c c c! c 2 3G+ ! c 7 ( ! 7 (06 ( c % & ( 2
3I+ 2 %2 & c c :#6 002 c 2c0"HH0"0 &c2 ;H+ 2c&& c& &c 9 c: c %c c 9 2 2#.A& c&> c > c@ ccc ! CA6A1A>#.A232H2" "2<.A05 0c c/ *2c 9 P,#Q6, 32C)6A><.A0 0& c
F2+ cc c c c cH c ! c 2G2+ c c&c 0 & 2 I2+ && c& cc&& !& ! ! c cc 2 G2+ cc&& cc&& c&8"HIHS - c 'T I2+ ! ! c c c( !2< c2 H2+ : ! : ! c c& c & c 2 2+ . ! ! c& cc c cc !232G c232I "2+ Cc c c
& ( & & c&9c c c !232G0232I $2+ c )cc c c & & cc cc& c c c c cc
cc 2 *2 2 32+ c ' > > ;2+ && > > >
c c&c c c c> > c
& &c c c&> 2
F2
c I2+ :#>#1466>5C)A11A1>A:ACCA>J1
"H2+ & c&:#>#1466>5C)A11A1>A:ACCA>J1 :#>#1466>5C)A11A1 c c ! &c c ! 9c c c ! 2>A:ACCA>J1 c c cc ! & c c>A:ACCA>J1 & c ! 9c c & c $ & c ! & c c c c ! & 2+ c c cc c ! 2 "2& c c
cc c cc cc c2&
ccc2 ""2+ c c 2 c c c U22 "$2+ & & c& ' cc ' + c ! !c&:#>#1466>5C)A11A1>A:ACCA>J1 c 556>450 01 c' c ! 24 ' & c c c :#>#1466>5C)A11A1>A:ACCA>J1 & c ! 21 c ! c c cc c c2 "*2+ cc& c! c&c ! c c ! 2 "32)cc& c c )! c&c ! c ! ' & c ! U2 ";2
+! c ! c cG 2+ c&c ! c ! ( 9c c ! c cc2 "F2
c ' &c c2 c c :#6! c ' c c 2 "G2+ :#6 :#6 c'c ccc 9 c 166ACc c 9 c 2 "I2+
c )
c & & c - c c ' c c c& 2 &c c ! & cc& ( & & & cc& & 2& & c & c
c & 2 $H2
& + & &2
c & cc& &
2 & cc & cc&&
& c & 2 $2+ c& c c 556>450 010c $"2+ c ! c& c c c !Hc !H"UUc c 556>450 010c $$2
& c:# c c c :# & c c
$*2+ & c& ! c c + ! cc& & c c & 2 $32+ && cc c 2
V& c "2#c
V7& & c c c 8 & & P
Pc $24 V+ c 9 c! c 28 Pc *25 V8 P 4 c & c c & ( c 16ABA) c cc& 2 $;2& > > >& $I2+ ' c! > >&
*H2+ -c& 4 c c c &c c c &&2 - $ cHO2 *2+ cc& cc& c c c c& c& 2 *"2+ cc& !&c )c ( & c *$2+ c ( & )c ( & c c cc& c &c c24 !>2( **2450 *32
"21A475V: & c( & $25C:6AV7 c& 2 *F2+ c cc&c& c& 556>450 00c0 *G2 c c c cc&
5 2c& c 2 E556>450 00c 024 c 2 c !& &c cc& c c c c2 c& T c !2 *I2450 24 cc& c && & c c cc& 2 3H2C)6A><.A 32+
9 & ( & - c & 92- 3"2 3"2+ 2- 0 c"2- & 2- 0 c"2-
c&9 & ' &c c c22- cc c c & c232Gc c"2- 3$2+ c cc&2- 0 c"2- 7>4509 JQ>45 3*2+ &c W Xc c !&c c c 9 332+ Wc Xc c c c 9 2 3;2c 9 PT#Q6T@ 3F2
3G2
2 ;2+ c& c& &c 8 ! c& c& 2 ( D556>450 ;"2+ ! ! ! ( 2O c&c !c
c & c ( c 2 ;$2450
;G2C)6A><.A00 0 V c FH2+ c& c& &c c cc& 2c&D1>C)6A><.A000c& F2+ c c c c 8 0 >c% c >cD1>C)6A><.A000c F"2+ c cc 560166 1 A J15A F$2+ 9 9 c 2 Tcc& c 2 F*2+ & c + c& c c c c c & 2 F32+ c c & c >c c >c c >9 2c 28&c c F;2+ c cc&9 2c 1>C)6A><.A00J 0c FF2+ c cc& 2 1>C)6A><.A00c'0& FG2+ 9 2c&9 2 c & 4 c& c& c 9 T8 2 FI2+ c
21 c8 2 c "2) VOc cE)..#>450 0> >c> c 8 V >c>> $21 8 2 GH2+ &c c& c& c c >c ( 2&DE)..#>450 0 G2+ && c &c c! G"2+ && c! c c! c&c c &;H ( c&c c c2 G$2+ &c + c c&c &c cc 2 G*2+ &c c c >c c >c G32+ c c& cc& c c )c& c& VCA5>2c 6c& VCA5>2cDGH;>C)6A><.A0 c ;H0 G;2+ )O2 & c c )O2 & & c c D GH;>C)6A><.A0 c ;H0 GF2+ & c&156
Q c & c 156 c c c cc Cc 2 GG2+ c c& c E)..#>450 00cc E556)1:0E5566O GI2c c cc c&c c #c2 c 0 cc c 2 IH2+ c c c c ' 2 I2+ && c&c 2 c V+ c c c "21 . Vc ' & cc $2)c& c c V)c c c *24 c V< c ' I"2+ c Y )c . &c T 4 c2c&c c c c 8 & & c c&c 2 c2c& c 2 4 c 2 I$2+ &4 c c c c cc ' c&c c 2 I*2+ c ! & +c ! & c c c c 2 I32+ & c c c c c 2 I;2
: c& c Y )c . &c T2 IF2+c c c c c cc 2 IG2+ & c c & c c c &c c2)& c c cc c 2 c c E:#>450 II2+ c c 2 D1>C)6A><.A00 HH2+ c& c& &c 56016 >2c&D1>C)6A><.A000c& H2
c > 2 c > 2 > 2 > 2 H$2+ 4 c& 4c4 + :c ccc)c c cc c2 H*2
c cc&:#:1:#1.2:#1. c c c c cO1. c& Y T2 HF2+ O1. O1. &c O . c c c c ! &c c& c &cc2 HG2& c&> c > c@ HI2 2+ -c& "HH c3HHO "2c > ' &>c > c > E c E c E' ( 2& ' cc c ! c ' c ! ! cc ' c c& ' cc2 *2+ c & c .c c& c c c 2Cc cc :#1. c 2c c&GH;>C)6A><.A2 32>c!c c> 2
+& c! &cc ' R& c Ec! c?H 8 & c Ec! ' ?H & Tc! c! c2 ;2C)6A><.A G2+ & c& DC.1>C)6A><.A0 00 I2C)6A><.A2 "2+ '&c c c & c 2cD0 0c 0c c 0 ""2+ c 4c c c c&c 78 7
, cc!! 24
c c &c c c c& c C)6A><.A1c c c J C A c 8JCA c C.1 1C)6A><.A c c 24 GH;C)6A><.A c c7 c 2 "$2+ && c& c 4Oc c 8c ) c 46c c 8c
4Oc c c& B.6 c c c&c c c 24 c &c cc 2 c c & c c&c 2c24Oc c c c cc& c
c C)6A><.A18C.11c JCA2 cc
&c c c c& cC)6A><.A24Oc c c c C)6A><.Ac c7 C c C )c2 #c &c c C)6A><.Accc c 7 c c! Oc c c -2 "32+ c c 4 c6c c C)6A><.A2 c C)6A><.A EC)6A><.A0 c c c& &c C)6A><.A24 6c c c C)6A><.A 72 ";2+ c C )c c c C232G2C )c
cc& c cc - C "F2
c cc c *2C c c 321 c c 2c ;2C &c2 4 c & ! c F2& ! c ! 5 &c2 41 !2) c c& c & c c c & & cc Cc c c G2C cc& c ' (2
I2C &c24 H2C cc& c ' (2 "I2+ c cc& c2&c c C.1>C)6A><.A0 0 0 $H2+ c cc& c2&c E)..#>450 0 0 $2+ c cc&&c2&c c EC.1>C)6A><.A0 0c0 $"2+ c cc&&c2&c E)..#>450c0 $$2+ ! 1 ! c c &c &c c2 $*2C)6A><.A0 0 #c c c ! & !c *I$2 $32 $;2 P @ A( '' '> P&@ 4 & EC.1>C)6A><.A0 0c ( 0 c& ' c2 $F2
(2 > 2 >'> > > c8 Z 0& A4c &c ' c G16?( 2 > 2 >'> > > c8G" @ 56016 c &c 2 4c 16?(2 > 2 >'> > > c8G"&@ $G2+ c cc& 2c EC.1>C)6A><.A0 $I2+ & c c 4 & c c c&' !( c && 24! c& cc & c &c 2 *H2+ (&c ! c& ! c&( P0Pc *2C)6A><.A0 &c c E)..#>45&c 2 *$2
c ' Oc cEC.1>C)6A><.A0 00 WWR **2+ !
16? !4A14>4>4A14"c c & ,4A14",@ ! 2 16? & c E D4A14>4>4A14"@ #.A 4A14" 16? > !& c > > !@ *2 c 2c *32
c9 c c& && cc c&c c !9 c'9&c 7C60><4.6090&0c9 29 3*2+ c c&& c 2 332+ 6 8 c 0 c & & c 2 3;2+ c c! c
c c& cc c2 A( #c 4 c 2c &c cc ! c2 3G2& P04A140 0 0232H0&c 0:0CB4+.2&(c> P&c P c >P ;H2+ 55654.5 c 4 c & c c&c 0' & 2& c c c c c 2;2+ c . c c c c& c22+ c cc c c c c& c c & c c 2 ;"2 c c + c c &cc c c
c cPc ;$2450 0$2 < 29 ;*2C)6A><.A02 > c c c c c c c2 ;32 c c 2 ;;2+ c c c ' )#17 ;F2+ & c& >& > 2c & 4 c& cc& c c ! c c c& & c 2 ;G2C)6A><.A0 *0 R ,Q c, ;I2+ c c c c
c 0 c c 0C)6A><.A c c c ccc + ! c c c c &
FFF c c c c 2& cT c ! &cc c c> c F"2< c &c +c CF**3 c c&c c c c 2 F$2+ c c c
5 & c c &c c cc 2+c WX &c &;H 2 "7 c 9 & JQ>45 c5 c : c c JC& 1c cC9! - c 2c 9& 9 c 9 & 2 F*2+ 9!+ & 9! c / c 2 ( D556>45? 2 ( D556>450 c2 D556>450 2c 9D c F32+ c c ! C 9!V - c 9 & 2 FF2+ c c c c A c C)3HH$: : c
0H0&"0&"0&"c 0 10 0
0 c&2 )4c & c&, cc& , c 21c c2 & c c&2 24&c2 c cc!&c & c
&c & , & &c2& 21c c.c & , c&2 c c&& 24 &c2 FG2+ c c c cc c cc 2)c 5 c c c c ccc c 24c c c 2"2)c 5 c c c c( cc( 24c c cc & c 2$2 + c 2 & cc& Wc
c c X24c c c
&>c & 2 FI2450' GH2+&c c c ' &c &c & & c c &c 2 DE5)450J 0 2
cc c & ( ( c& c c 2 556 #O54)
& (2 \C c&& &c & (2 \C c c&&& ' & (2 \.! &c 1c c c c2 \Sc c 8 & (:#8 cc !
c 2 ! c c 2:c ( 232H)7" c 232G8c c c232H)7"2 7 !& ! &c &c &c c c c & c c c c !2
c &c c71 c 24 71 &cc 2 cc 71 c c & 2 cc c cc ccc c! 71c71 2 1 c. 5 c &c c c 2 ) c5 c cc c c8c 2
c & c 24 c c &c c ! c c c ' 2 c cc c c & c ' 2 ' && &c c 21 ! c ' c &c 2+ c c ' ' ( cc& ' &c c 2 1 . !< c5 5 '& c c & ' c && &c c2 c c cc ' c5 2 c c ' &c c ' CA.A2 1 c. 7 &c &c c2 ) c c #c
cc c c c c c c& c 2 c c c c c & & 24c c5 c & c& & & c cc& c c c&