Oracle DBA Interview Question (Part -3)
17) What is the contrast between the hot backup taken through RMAN and Manual?
check the underneath connection for Detailed clarification
Component pursued by Oracle when we are taking hot backup
18) What is the library reserve lock?
A library reserve lock implies that a session is holding on to utilize or change an item definition or to utilize a SQL proclamation that another session is stacking, changing or parsing, or is hanging tight to change or parse. This typically shows database object definitions are being changed routinely. Another precedent is gathering insights on an item. At the point when measurements are assembled all references to that object in the common pool or library store become invalid, requiring another hard parse for each SQL articulation referencing the item. Measurements should possibly be accumulated when there are no dynamic clients or framework action is low.
Visit Oracle DBA Training to get the practical explantion
19)How do we discover the blocker for Library store lock?
We can run hang analyze to discover the blocking session.
Ordinarily the beneath inquiry likewise works in magnificent way
select/*+ all_rows */w1.sid waiting_session,
h1.sid holding_session,
w.kgllktype lock_or_pin,
w.kgllkhdl address,
decode(h.kgllkmod, 0, ‘None’, 1, ‘Invalid’, 2, ‘Offer’, 3, ‘Select’,
‘Obscure’) mode_held,
decode(w.kgllkreq, 0, ‘None’, 1, ‘Invalid’, 2, ‘Offer’, 3, ‘Select’,
‘Obscure’) mode_requested
from dba_kgllock w, dba_kgllock h, v$session w1, v$session h1
where
(((h.kgllkmod != 0) and (h.kgllkmod != 1)
furthermore, ((h.kgllkreq = 0) or (h.kgllkreq = 1)))
furthermore,
(((w.kgllkmod = 0) or (w.kgllkmod= 1))
furthermore, ((w.kgllkreq != 0) and (w.kgllkreq != 1))))
furthermore, w.kgllktype = h.kgllktype
furthermore, w.kgllkhdl = h.kgllkhdl
furthermore, w.kgllkuse = w1.saddr
furthermore, h.kgllkuse = h1.saddr
/
20) How to take worldwide hanganalyze dump?
ORADEBUG setmypid
ORADEBUG setinst all
ORADEBUG — g def hanganalyze <level>
21) How would you recoup the database in the event that you lost one of the controlfile in the database?
Check underneath connection for all the helpful situation for recuperation
Database recuperation different cases and arrangement
22) How would you recuperate the database on the off chance that you lost the majority of the controlfile in the database?
Check underneath connection for all the valuable situation for recuperation
Database recuperation different cases and arrangement
Visit onlineITGuru to clear database certification
23) What is flashback database?
Flashback database clarified and confinement
24) How would you be able to reconstruct a record?
We can modify the list utilizing the underneath order
adjust list index_name remake on the web; If it is to be on the web
adjust list index_name remake; If it is to be revamp disconnected
25) What is Branch Block in file ?
Branch square lines hold <separator key,kdba> sets used to direct the B-tree seek to a column in a leaf square.
26) What is Leaf Block in file ?
Answer: Leaf square columns hold the <KEY, KEYDATA> sets put away by the B-tree.
