UGF2824_Elsins-OOW15 - Maris Elsins - Mining AWR

8/20/2019 UGF2824_Elsins-OOW15 - Maris Elsins - Mining AWR

http://slidepdf.com/reader/full/ugf2824elsins-oow15-maris-elsins-mining-awr 1/101

!"#$% '(%$)%

*#"+(' *,')-*#(. /012

!$)$)3 "45*!"5$+ -*#6(*". #',*%$5*#7

"(5'#)"5$9' !'5:*.% ;*#

$.')5$;$+"5$*) *; 5:' 5*, %<(%



!"#$% '(%$)%Lead Database Consultant

At Pythian since 2011

Located in Riga, Latvia

Oracle [Apps] DBA since 2005

Speaker at conferences since 20@MarisElsins elsins@pyth

=>>?8@@AB>CDE@FG>!*%,H>I=



,E>=BHJ BK H FDLAHD $5 KGMNBIGK ILO?HJE >=H> K?GIBHDBPGK

BJ QGKBFJBJFR BO?DGOGJ>BJFR HJQ OHJHFBJF KEK>GOK >=H>QBMGI>DE ILJ>MBAS>G >L MGNGJSG HJQ ASKBJGKK KSIIGKKC -G

=GD? ILO?HJBGK HQL?> QBKMS?>BNG >GI=JLDLFBGK >L HQNHJIGBJJLNH>BLJ HJQ BJIMGHKG HFBDB>EC *SM =BF=DE KTBDDGQ

>GI=JBIHD >GHOK ULMT HK HJ BJ>GFMH>GQ GV>GJKBLJ LW LSMIDBGJ>KX LMFHJBPH>BLJK >L QGDBNGM ILJ>BJSLSK >MHJKWLMOH>BLJHJQ SJBJ>GMMS?>GQ L?GMH>BLJHD GVIGDDGJIGC

"Y*45 ,75:$")

5L? 2Z >HDGJ> ULMDQUBQG

[ *MHIDG "+'K

\ *MHIDG "+' .BMGI>LMK

1] EGHMK BJ ASKBJGKK

\00^ GO?DLEGGK

/_0^ ISK>LOGMK ULMDQUBQG



"3')."

" %'#$*4% - "%: ,(")5



"3')."

, "))$)3



.'!*



-:"5 $% "-#`-*#6(*".



-:"5 $% "-#`%)",%:*5



-:"5 $% "-#`#',*%$5*#7



-:"5 $% "-#` "-# #',*#5



"-#

"S>LOH>BI -LMTDLHQ #G?LKB>LME

(G>XK >ME HFHBJ a



-*#6(*".

_b] 9c d1/C1C0C/e



"-# %)",%:*5

b/^ 9c f gc



-*#6(*".

+ ",54#'. Y7 "-#

h *+,-./ %/"/$%/$.% >=H> QG>GMOBJG AL>= HIIGKK HJQ SKHFG

QH>HAHKG KGFOGJ>Kh 0$1- 123-( %/"/$%/$.% AHKGQ LJ >BOG SKHFG WLM HI>BNB>BGK

BJ >=G 9c%7%i5$!'i!*.'( HJQ 9c%'%%i5$!'i!*.'

h %LOG LW >=G %4%/-1 ")3 %-%%$2) %/"/$%/$.% ILDDGI>GQ BJ 9c%7%%5"5 HJQ 9c%'%%5"5 NBGUK

h 567 %/"/-1-)/% >=H> HMG ?MLQSIBJF >=G =BF=GK> DLHQ LJ >AHKGQ LJ IMB>GMBH KSI= HK GDH?KGQ >BOG HJQ +,4 >BOG

h 8./$9- 5-%%$2) :$%/2#4 ;85:< %/"/$%/$.%R MG?MGKGJ>BJF >LW MGIGJ> KGKKBLJK HI>BNB>E



"-# %)",%:*5

j5:' %'(;$'k

h !!*) LM QAOKiULMTDLHQiMG?LKB>LMECIMGH>GiKJH?K=L>deh .Y"i:$%5i-#i+*)5#*(

h 5*,)%<( j.';"4(5k QG?GJQK LJ >=G %5"5$%5$+%i('9

l 57,$+"( mn o0 dBK >=BK GJLSF= e l "(( mn 100

h .Y!%i-*#6(*".i#',*%$5*#7 l !LQBWE KG>>BJFK8 !*.$;7i%)",%:*5i%'55$)3% l +LDLMGQ %<(8 "..i+*(*#'.i%<(



%)",%:*5

/ -"7% *; +*(('+5$)3 %5"5$%5$+%

h .'(5"K f 5*5"(K

l +H?>SMGK ISMMGJ> NHDSGK l ,MGpIHDISDH>GK qNHDSGK

l .Y"i:$%5i%<(%5"5

l .Y"i:$%5i%'3i%5"5

h 5*5"(K l +H?>SMGK ISMMGJ> NHDSGK

l %BOBDHM >L %5"5%,"+6

l .Y"i:$%5i$*%5"5i.'5"$( HJQ L>=GMK



#',*%$5*#7

%)",i$. p Y"%'. $);*#!"5$*) d102eh .Y"i:$%5i"+5$9'i%'%%i:$%5*#7h .Y"i:$%5i",,(7i%4!!"#7h .Y"i:$%5i"%:i%)",%:*5h .Y"i:$%5i"%!iY".i.$%6h .Y"i:$%5i"%!i.$%63#*4,i%5"5h .Y"i:$%5iY3i'9')5i%4!!"#7h .Y"i:$%5iY4;;'#'.i<4'4'%

h .Y"i:$%5iY4;;'#'.i%4Y%+#$Y'#%h .Y"i:$%5iY4;;'#i,**(i%5"5h .Y"i:$%5i+",54#'h .Y"i:$%5i+'((i+*);$3i.'5"$(h .Y"i:$%5i+'((i.Yh .Y"i:$%5i+'((i.$%657,'h .Y"i:$%5i+'((i.$%6i)"!'h .Y"i:$%5i+'((i.$%6i%4!!"#7h .Y"i:$%5i+'((i3(*Y"(h .Y"i:$%5i+'((i3(*Y"(i%4!!"#7h .Y"i:$%5i+'((i$*#'"%*)h .Y"i:$%5i+'((i)"!'h .Y"i:$%5i+'((i*,')i"('#5%h .Y"i:$%5i+(4%5'#i$)5'#+*)h .Y"i:$%5i+*!,i$*%5"5h .Y"i:$%5i+#iY(*+6i%'#9'#

h .Y"i:$%5i+4##')5iY(*+6i%'#9'#h .Y"i:$%5i.Yi+"+:'i".9$+'h .Y"i:$%5i.$%,"5+:'#h .Y"i:$%5i.(!i!$%+h .Y"i:$%5i.7)i#'!"%5'#i%5"5%h .Y"i:$%5i')<4'4'i%5"5h .Y"i:$%5i'9')5i:$%5*3#"!h .Y"i:$%5i;$('!'5#$+i:$%5*#7h .Y"i:$%5i;$('%5"5g%h .Y"i:$%5i$+i+($')5i%5"5%h .Y"i:$%5i$+i.'9$+'i%5"5%h .Y"i:$%5i$!i%'3i%5"5

h .Y"i:$%5i$)%5")+'i#'+*9'#7h .Y"i:$%5i$)%5i+"+:'i5#")%;'#h .Y"i:$%5i$)5'#+*))'+5i,$)3%h .Y"i:$%5i$*%5"5i.'5"$(h .Y"i:$%5i$*%5"5i;$('57,'h .Y"i:$%5i$*%5"5i;4)+5$*)h .Y"i:$%5ir"9"i,**(i".9$+'

h .Y"i:$%5i("5+:h .Y"i:$%5i("5+:i+:$(.#')h .Y"i:$%5i("5+:i!$%%'%i%4!!"#7h .Y"i:$%5i("5+:i,"#')5h .Y"i:$%5i($Y#"#7+"+:'h .Y"i:$%5i(*3h .Y"i:$%5i!'!*#7i#'%$s'i*,%h .Y"i:$%5i!'!*#7i5"#3'5i".9$+'h .Y"i:$%5i!'!i.7)"!$+i+*!,h .Y"i:$%5i!55#i5"#3'5i".9$+'h .Y"i:$%5i!45'gi%('',h .Y"i:$%5i!9,"#"!'5'#h .Y"i:$%5i*%%5"5h .Y"i:$%5i,"#"!'5'#h .Y"i:$%5i,.Yi$)i%)",h .Y"i:$%5i,'#%$%5')5i<!)i+"+:'

h .Y"i:$%5i,'#%$%5')5i<4'4'%h .Y"i:$%5i,'#%$%5')5i%4Y%h .Y"i:$%5i,3"%5"5h .Y"i:$%5i,3"i5"#3'5i".9$+'h .Y"i:$%5i,#*+'%%i!'!i%4!!"#7h .Y"i:$%5i#',($+"5$*)i5Y(i%5"5%h .Y"i:$%5i#',($+"5$*)i5g)i%5"5%h .Y"i:$%5i#',*#5%h .Y"i:$%5i#',*#5%i.'5"$(%h .Y"i:$%5i#',*#5%i5$!'Y").%h .Y"i:$%5i#'%*4#+'i($!$5h .Y"i:$%5i#*-+"+:'i%4!!"#7

h .Y"i:$%5i#%#+i+*h .Y"i:$%5i#%#+i,("h .Y"i:$%5i#4('i%'5h .Y"i:$%5i%'3i%5"5h .Y"i:$%5i%'#9$+'i%h .Y"i:$%5i%'#9$+'i-h .Y"i:$%5i%'%%!'5#

h .Y"i:$%5i%'%%i%3"h .Y"i:$%5i%'%%i5$!'h .Y"i:$%5i%3"h .Y"i:$%5i%3"%5"5h .Y"i:$%5i%3"i5"#3h .Y"i:$%5i%:"#'.i,h .Y"i:$%5i%:"#'.i%h .Y"i:$%5i%)",%:*5h .Y"i:$%5i%)",i'##h .Y"i:$%5i%<(Y$).h .Y"i:$%5i%<(%5"5h .Y"i:$%5i%<(i%4!!h .Y"i:$%5i%<(i-*#6h .Y"i:$%5i%5#'"!%ih .Y"i:$%5i%5#'"!%ih .Y"i:$%5i%5#'"!%i

h .Y"i:$%5i%7%!'5#$h .Y"i:$%5i%7%!'5#h .Y"i:$%5i%7%%5"5h .Y"i:$%5i%7%5'!i'h .Y"i:$%5i%7%i5$!'ih .Y"i:$%5i5"Y('%,"+h .Y"i:$%5i5Y%,+i%,h .Y"i:$%5i5'!,%5"5h .Y"i:$%5i5:#'".h .Y"i:$%5i4).*%5"5h .Y"i:$%5i-"$5+("%h .Y"i:$%5i-"$5%5"5



#',*%$5*#7

!'5"."5"

h .Y"i:$%5i"%!i.$%63#*4,

h .Y"i:$%5iY"%'($)'

h .Y"i:$%5iY"%'($)'i.'5"$(%

h .Y"i:$%5iY"%'($)'i!'5"."5"

h .Y"i:$%5iY"%'($)'i5'!,("5'

h .Y"i:$%5i+'((i+*);$3

h .Y"i:$%5i+'((i$*#'"%*)i)"!'

h .Y"i:$%5i+'((i!'5#$+i.'%+

h .Y"i:$%5i+*(*#'.i%<(

h .Y"i:$%5i."5"Y"%'i$)%5")+'

h .Y"i:$%5i."5";$('

h .Y"i:$%5i'9')5i)"!'

h .Y"i:$%5i$!i%'3i%5"5i*Yrh .Y"i:$%5i$*%5"5i;$('57,'i)"!'

h .Y"i:$%5i$*%5"5i;4)+5$*)i)"!'

h .Y"i:$%5i("5+:i)"!'

h .Y"i:$%5i!'5#$+i)"!'

h .Y"i:$%5i*,5$!$s'#i')9

h .Y"i:$%5i*%%5"5i)"!'

h .Y"i:$%5i,"#"!'5'#i)"!'

h .Y"i:$%5i,.Yi$)%5")+'

h .Y"i:$%5i,(")i*,'#"5$*)i)"!'

h .Y"i:$%5i,(")i*,5$*)i)"!'

h .Y"i:$%5i#',*#5%i+*)5#*(

h .Y"i:$%5i%'3i%5"5i*Yr

h .Y"i:$%5i%'#9$+'i)"!'

h .Y"i:$%5i%<(+*!!").i)"!'

h .Y"i:$%5i%<(5'g5

h .Y"i:$%5i%<(iY$).i!'5"."5"

h .Y"i:$%5i%<(i,(")

h .Y"i:$%5i%5"5i)"!'h .Y"i:$%5i5"Y('%,"+'

h .Y"i:$%5i5'!,;$('

h .Y"i:$%5i5*,('9'(+"((i)"!'

h .Y"i:$%5i-#i+*)5#*(



.'!*



5:")6 7*4 ( "##7 ;*# "-# #',*#5%t



"-# #',*#5

h j%<( %>H>BK>BIKk KGI>BLJ BK HFFMGFH>GQ AE %<(i$

h .L ELS TJLU U=H>XK FLLQ HALS> %<(i$.` l $> SJBuSGDE BQGJ>BWBGK H %<( K>H>GOGJ>

h .L ELS TJLU U=H>XK AHQ HALS> %<(i$.` l $> SJBuSGDE BQGJ>BWBGK H %<( K>H>GOGJ>



%<( $. "). *5:'# $.')5$;$+"5$*) !'5:*.%

h .'!* p BQGJ>BWBIH>BLJiQGOLCKuD



+:"((')3'% -$5: 4)$<4' $.')5$;$+"5$*)



h .BWWGMGJ> WLMOH>>BJF LW H %<( K>H>GOGJ>h !BKSKG LW ILJK>HJ>K BJ %<( K>H>GOGJ>K

h 4KG LW ILJK>HJ>K BJ KGOHJ>BIHDDE GuSBNHDGJ> K>H>GOGdK=LSDQ >=GKG AG KG?HMH>GQ`e

h .BWWGMGJ> JHOGK WLM ABJQ NHMBHADGK BJ GuSBNHDGJ> %<(K>H>GOGJ>K

h .LGK 'g"+5i!"5+:$)3i%$3)"54#' =GD?`h .LGK ;*#+'i!"5+:$)3i%$3)"54#' =GD?`h .LGK ,(")i:"%:i9"(4' =GD?`

('5X% !$)' 5:' "-#t



h .'!* p HUMi>L?iKuDBQiQGOLCKuD



('5X% !$)' 5:' "-#t



h .'!* p HUMi>L?iWOKiQGOLCKuD



('5X% !$)' 5:' "-#t



h .'!* p HUMi>L?i?DHJiQGOLCKuD



%4!!"#7

h "-# MG?LM> BK KSWWBIBGJ>R GVIG?> U=GJ B>XK JL>)L IDGHM >L? ILJKSOGM



l )L IDGHM >L? ILJKSOGM l .EJHOBI %<( l +LOABJGQ MG?LM>BJF BJ>GMNHDK

h *NGM=GHQ LW IMGH>BJF HJ "-# MG?LM>h 5*,)%<(

h ;*#+'i!"5+:$)3i%$3)"54#'

h ,(")i:"%:i9"(4'

h .LJX> K>L? t 7LS QGIBQG =LU >L WBD>GM HJQ HFFMGFH>G >=G QH

l !LQSDG l "I>BLJ l a



"-# BK H ILO?DGV AGHK>R AS> B>XK JL> JGIGKKHME >L TJLU OSI= >L K

YG YMHNGtYS> ASE .BHFJLK>BIK ?HIT DBIGJKGK WBMK>C

+*)5"+5 $);*#!"5$*)



[email protected]

@MarisElsins

Lead Database Consultant,

Pythian613 565 8696 ext 337

Maris Elsins

Pythian.com

@pythian

.GOL KIMB?>K HNHBDHADG =GMG8 AB>CDE@!HMBKi**-12i"-#

UGF2824_Elsins-OOW15 - Maris Elsins - Mining AWR

Documents

Transcript of UGF2824_Elsins-OOW15 - Maris Elsins - Mining AWR