Oracle Apps DBA Training :DBA Technologies

Views:
 
Category: Education
     
 

Presentation Description

DBA T is pchnologies Provides Oracle DBA Online Training Class course by excellent experienced IT professionals who has more then 18+ Years of real time experience Our trainers has good training experience so that best quality output will be delivered. visit - http://www.dbatechnologies.net/

Comments

Presentation Transcript

PowerPoint Presentation:

W E L C O ME T O D B A T E C H N O L O GI E S O R A C LE D A T A B A SE A R C HI T E C T U R E -2 B y M r . P R A S A D MYNUM P A T I 18 Y e a r s R e a l T ime in I ND I A - U S A ww w . db a t e c hn olo g i e s. n e t ww w .db a t e c hno l o g i es .n e t B u il d i n g C a r ee r With P assi o n

PowerPoint Presentation:

d a t a b a se A r ch i t ec t u r e – U S E R T S USE R t a b le s p a c e is t o s t o r e d a t a p er m a n e n tly E n ti r e A pp li c a tion d a t a s t o r a g e a n d r e tri e v al f r om USE R t a b le s p a c es F or load b ala nc i n g pu r p o s e w e u s e d i f f e r e n t • • • t a b le s p a c es on d i f f e r e n t d i s k s f or I N D E X a n d D AT A H o w m a n y t a b le s p a c es f or a d a t a b a s e? d e p e nd s on d e s i g n of t h e a pp li c a tion a n d nu m b er of a pp li c a tio n s • •

PowerPoint Presentation:

O R A C LE & O S c o mp a r i s o n FI L E S Y S TEM T AB L E S P A C E F il e s y s t e m P art i t i ons ( e xt3) T ab l es pa c e s (Und o , T e mp and P e rman e n t) Mou n t f il e s y s t e m ( T o r e ad and wr i t e ) B y d e f au l t T S i s mou n t e d F il e s & D i r e c t or i e s T ab l e s , Ind e x e s (obj e c t s ) O S B l o c k s i z e T S B l o c k s i z e (D e f au l t 8K) Mu l ti u se r a cc es s ba se d on pr i v il e g e s Mu l ti u se r s a cc es s b y a ss i g n e d quo t a B a c k up F S B a c k up t ab l es pa c e F S c on s i s t e n c y ( f s c k) D a t aba s e lev e l c on s i s t e n c y ( R MAN)

PowerPoint Presentation:

Se r v er & S t o r a g e c o n f i gu r a t i o n O S a n d O R A CLE S W is on Se r v er D a t a b a s e is g oi n g t o b e on h igh e n d st o r a g e – N AS ( N e t w ork a r ea S t o r a g e) • • – S AN (S t o r a g e a r ea N e t w or k s)

PowerPoint Presentation:

Ide n t i f y i ng O S f o r O R A C LE S W v e r s i o n W h a t k i n d of O S w e n eed ? • • N eed t o f oll o w ce r t i f i c a t ion m a t r ix o r acle m e t ali n k . ww w . m e t ali n k .o r acle. c om N eed t o c h oo s e ce r t i f ied O S f r om • • Can w e i n s t all mu l t i p le v e r s io n s (7,8,8i,9i,10 g ,11g) of O r acle S W s e r v e r ? Y es w e c an on s a m e •

PowerPoint Presentation:

S i ng l e DB v s. Mu l t i p l e d a t a b a ses Can w e c r e a t e mu l t i p le d a t a b a s es b y u s i n g s a m e v e r s ion of O r acle So f t w a r e? Y es w e c an On e d a t a b a s e vs . Mu l t i p le d a t a b a s es – N a t u r e of a pp li c a t io n s • • • • D e p e nd e n cy – Si z e of t h e d a t a b a s e ( m ai n t e n a n ce) – App li c a t ion Co mp l e xi t y …..

PowerPoint Presentation:

In s t a nce a nd D a t a b a se In s t a nc e w ill b e h o s t ed on s e r v er • – – – C PU M EM P R OC E SS E S • D a t a b a s e ( C , R , D file s ) is lo c a t ed on h i g h end s t o r a g e s ol u tio n s li k e S AN w ith fi b er o p tic t e chn olo g y . P r o c e s s p o w er a n d m e m o r y f or all D a t a b a s e o p e r a tio n s a r e f r om s e r v er r e s o u r c es •

PowerPoint Presentation:

OR A C LE IN S T ANC E B A C K G R O UN D P R O C E SS E S M a nd a t e a n d O p t i o n a l b ac k g r o un d p r o c ess w il l b e st a t ed w h en I N S T A NC E st a rts A l l t h e r unnin g b ac k g r o un d p r o c esses c a n b e vi e w ed @ t w o di f f e r e n t l e v e l s O S LEVEL – $e c h o $ O R A C LE_S I D ( I n st a n c e N a me) • • • – $ p s – e f | g r ep $ O R A C LE_S I D D AT A B ASE LEVEL - SQL> Se l e c t PN AME F r om v $ p r o c ess Wh e r e PN AME i s n ot nul l O R D ER b y PN AME; H o w t o see a l l t h e a v a il a bl e b ac k g r o un d p r o c ess d e t a il s – SQ L > S e l ect na m e f r o m v $bgp r o ces s ; • •

PowerPoint Presentation:

M a nd a t e Bac k g r o un d P r oce ss es D B W n D B W n : W r i t es d i r ty bu f f e r s f r om • I n s t a n ce B u f f er Cac h e t o D B F files S H A R ED POO L D A T A B ASE US E R D A T A FIL E R e do bu f f e r s

PowerPoint Presentation:

M a nd a t e Bac k g r o un d P r oce ss es D B W n D B W n : W ri t e s only dirty bu f f e r s th a t a r e LRU (L e a s t r e c e n tly Us e d bu f f e r s) t o d b f f il e s and MRU during CK P T • • Wh a t is the di f f e r e nce b e t w ee n block ( f il e ) and bu f f e r (m e mo r y) D a t a B a s e B u f f e r Ca c he ( M e m ory ) D b f f il e B l o c k s : (S t o r a g e ) D e f au l t B l o c k S i z e 8K Non d e f au l t s uppor t e d b l o c k s i z es : 2k , 4k , 16k , 32k

PowerPoint Presentation:

T y p es of B u f f e r s in B u f f er Cac h e • D i r t y Bu f f e r s • F r ee Bu f f e r s D A T A B ASE BUFFER C A C H E • P i nned Bu f f e r s

PowerPoint Presentation:

T y p es of B u f f e r s in B u f f er Cac h e Di r t y Bu f f e r s – Mo d i f i ed i n bu f f er c a che(mem o r y ) • th a t a r e n o t y e t ( s t o r a g e) w r i t t en t o d a t a f il es • F r ee Bu f f e r s – R e a dy t o u s e P i nned B u f f e r s – B u f f e r s th a t a r e • i n u s e b y O r a c l e

PowerPoint Presentation:

D B W n w r i t es w h e n ? Di r ty bu f f e r s t h r es h old W h en r e qu i r ed f r ee bu f f e r s a r e a v aila b le • • n ot • D ur i n g g r ac e f u l / c o n si s t e n t s hu t d o w n • A n y T S s t a t u s c h a n g e li k e ( r ead o n l y , o f fli n e or T a b les p ace B egin b ac k up ..) C h eck p oi n t •

PowerPoint Presentation:

) M a nd a t e Bac k g r o un d P r oce ss es L G WR • L G W R : Log wr i t er wr i t es c h a n g e r e c o r d s r e d o bu f f e r s t o r e d o l og fil es f r om S H A R ED POO L D A T A B ASE C ur r e n t (In us e ) Acti v e ( R e qui r e d f or r e c o v e r y Inacti v e ( R e ady t o be cur r e n t) R ed o l o g f ile s L og S wi t ch R edo buf f e r s

PowerPoint Presentation:

L G WR w r i t es w h en A t e v e r y c o mm i t E v e r y th r e e s e c o nds W h e n 1 / 3 fu l l o f r e do lo g bu f f e r s W h e n w o r th o f r e do r e c o r ds i s 1 MB W h a t c o nt ai ns c h a n g e v e c t o r s – C han g e r e c o r d is c om bin a t i o n o f c han g e • • • • • v e c t o r s – Chan g e v e c t or c o n t ains • • • • • • S c n and T i m e S t a m p of c han g e T r ansa c tion Id Co mm it d e t ails if c o mm i tt ed ( s c n and ti m e s t a m p) T y pe of ope r a tion Se g m e n t na m e and t y pe Chan g e d e t ails

PowerPoint Presentation:

L G WR S e r v e r P r o ce s s c o p y r e do r e c o r ds f r o m u s e r mem or y s pa c e (P G A) t o r e do lo g bu f f e r s f o r e v e r y DML and DDL L O G_B U FFER i s the pa r a m e t e r t o s e t r e do lo g bu f f e r s si z e . M i n 64 k. Lo g bu f f e r s pa c e ( v $s e ssio n _ w a i t) – w a i t e v e n t( i n s e c o nd s ) i nd i c a t e s i n s u f f i c i e n t lo g bu f f e r s si z e • • • • V $ s y s t em _ e v e n t - lo g f il e s w i t c h c o m p l e t io n ( e v e n t , t o t a l_ w a i t s , t i me _ w a i t e d and a v e r a g e _ w a i t) A l er t lo g f il e a ls o r e c o r ds the ab o v e e v e n t c h ec k f o r c h ec kp oi n t n o t c o m p l e t e H i gh l y r e c o mme nd e d m u l t i p l e x i ng • •

PowerPoint Presentation:

M a nd a t e D B W n b ac k g r o un d p r oce s s CK P T LR U LR U LR U S H A R ED POO L D A T A B ASE B UFFER C A C H E R EDO L O G B UFFE R S M R U M R U M R U C KPT D a t a 723 f ile 1 723 723 723 723 C o n t r o l fil e D a t a fil e 2 R edo lo g fil es

PowerPoint Presentation:

M a nd a t e b ac k g r o un d p r oce s s CH E CKP OIN T • Ch ec kp oi n t i s a v e r y cr i t i c al ba c kg r o und p r o ce s s t o r e du c e the i n s t an c e o r me d i a r e c o v e r y t i m e Ch ec kp oi n t w o n t w r i t e a n y d a t a but i n o n l y e n s u r e s m a r k i ng SCN i n R e d o , C o n t r o l f il e and d a t a f il e s – D u r ing c he ck p o i n t D B W n w r i t es d a t a t o d b f f iles and m a r k s R ed o , c o n t r o l f ile and d a t a f iles wi t h s c n# Ch ec kp oi n t p osi t io n (SCN) i n r e do i s the p oi n t e r • • wh e r e r e c o v e r y m u s t s t a r t f r o m Ch ec kp oi n t e n s u r e s a l l the d i r ty bu f f e r s t o d is k ( L R U & M RU ) Ch ec kp oi n t p osi t io n i s the ol d e s t d i r ty bu f f e r i n the d a t aba s e bu f f e r c a c he • •

PowerPoint Presentation:

T y p es of c h ec k p oi n t T h r ead c h eck p oi n t : – ( d at abas e ch e ckp oi n t) D a t a b ase wr i t es t o d isk all bu f f e r s mo d ified b y r e d o in a s p ecific t h r ea d , occ u r s dur i n g t h e f oll o w i n g sit u a tio n s • • – Co ns i st e n t d at abas e shu t d o w n – Al t er s y st em ch e ckp oi n t – O n li n e r e d o log sw i t c h – Al t er d at abas e b egin bac k u p

PowerPoint Presentation:

T y p es of c h ec k p oi n t T S and d a t a file ch e ckp o i n t s : – T a b le s p a c e ch e c k p oi n t is w ith r e s p e c t t o a p arti cu lar t a b le s p a c e du ri n g t h e s t a t u s ch a n g e li k e r ead o n l y , r ead w ri t e, b e g in • b a c k up . O n ly f or t h e d a t a files t h a t b elo ng s t o a T S

PowerPoint Presentation:

T y p es of c h ec k p oi n t In c r eme n t a l c he c k p oi n t s – I t is k i n d of t h r e a d ch e ckp oi n t in o r d er t o a v oid l a r g e nu m b er of b lo c k s a t o n li n e r e d o log sw i t ch e s . D B W n c h ec k s e v e r y 3 se c o nd s t o c h eck • • a n y w o r k t o d o , if D B W n wr i t es d i r ty bu f f e r s, it a d v a n ces t h e c h eck p oi n t p osition t o t h e c o n t r ol file bu t n ot t h e d a t a file h ea d e r s

PowerPoint Presentation:

T y p es of c h ec k p oi n t In c r eme n t a l c he c k p oi n t s It is ki n d of t h r ead c h eck p oi n t in o r d er t o a v oid la rg e nu m b er of b loc k s a t o n li n e r e d o log s w i t c h es. • • • D B W n c h ec k s e v e r y 3 se c o nd s t o c h eck a n y w o r k t o d o , if D B W n wr i t es d i r ty bu f f e r s, it a d v a n ces t h e c h eck p oi n t p osition t o t h e c o n t r ol file bu t n ot t h e d a t a file h ea d e r s

PowerPoint Presentation:

M a nd a t e b ac k g r o un d p r oce s s S MO N SMON : S y s t e m M o n i t o r R e s p o n si b l e f o r In s t an c e c r a s h r e c o v e r y (IC R ) C l e ans up t em p o r a r y s e g me n t s . F o r e x a m p l e i f i nd e x c r e a t io n f a il e d i t c l e ans up a l l the t em p o r a r y s e g me n t s . W h a t i s IC R ? • • • • – In s t an c e r e c o v e r y i s app lyi ng r e c o r ds f r o m r e do t o d b f f il e s a f t e r m o s t r ece n t c h ec kp oi n t – I n f o rm a t i o n f r o m r e do m u s t be t r an s f er r e d t o d b f t o m a k e i t p erm an e n t and c o n si s t e n t –

PowerPoint Presentation:

S H A R ED POO L D A T A B ASE B UFFER C A C H E I CR - S MO N SM O N IN S T AN C E S T A R TUP AFTER CR ASH C r a s h R e co v er y 245 245 D a t a f il e 1 245 245 D a t a f il e 2 D a t a f il e 3 245 - Co n t r ol f il e 1 . R oll f o r w a r d 2 . R oll bac k ( un c o mm i t t e d t xn s ) 3 . R e c o v e r y d o n e C o mm i t t ed & u n c o mm i t t ed C o mm i t t ed & u n c o mm i t t ed 245 Undo D a t a f il e 1

PowerPoint Presentation:

M a nd a t e b ac k g r o un d p r oce s s P MO N P M O N : P r oc e ss e s M oni t or • • R e sponsible r e sou r c e s of f or cl e a ning a d e a d p r oc e ss e s S G A U ser p r o c e s s User p r o c ess C r ash PM O N

PowerPoint Presentation:

M a nd a t e b ac k g r o un d p r oce s s R EC O : R e co v e r e r R E C O • • R e sp o nsible f o r r e s o lving i n -d o u b t t r ansa c ti o ns in di s tribu t e d d at abase e n vi r o nm e n t. D i s tr i bu t e d txn R E C O R E C O U se r

PowerPoint Presentation:

SQ L st a t e m e n t s p r oce ssin g i n S er v e r P r o c esse s OR A C LE D AT A B A S E P A R SING D A T A B ASE B UFFER C A C H E 1. S y n t a x c h e c k 2. S e ma n t i c c h e c k 3.Sha r e d pool c h e c k S H A R ED POO L R EDO B U FF E R S U se r P r o c es s If SP c h e c k =no SQL> S e l e c t * f r om e mp l o y ees ; s oft ha r d d a t a f il e O P TIMIZER E x e c ut i on R o w s ou r c e g e n e r a t i on Mu l t i p l e E P ’ s

PowerPoint Presentation:

p U s e SQ L st a t e m e n t s p r oce ssin g i n S er v e r P r o c esse s OR A C LE D AT A B A S E P A R SING D A T A B ASE B UFFER C A C H E 1. S y n t a x c h e c k 2. S e ma n t i c c h e c k 3.Sha r e d pool c h e c k S H A R ED POO L U se r P r o c es s R o w s u d a t ed 10k 10k 10k R EDO B U FF E R S D B W n 20k 20k 20k If SP c h e c k =no SQL> Upd a t e s a l =20K f r om s a l a r y wh e r e s a l =10K s oft Undo d a t a f il e ha r d r d a t a f il e O P TIMIZER E x e c ut i on R o w s ou r c e g e n e r a t i on Mu l t i p l e E P ’ s

PowerPoint Presentation:

B uilding c a r ee r with pa ss i o n D S NR : 94 4 1 1 7 2 718 / 0 4 0 -6 5 555 6 8 9 ww w . db a t ec hno l og i e s . n e t QU E S T ION A N D A N S W E R S E SSION

authorStream Live Help