How many memory layers are in the shared pool?
Answer / md mubeen
Shared pool buffers cache consists of two layer
1)Library cache (LC) 2) Data dictionary cache (DDC)
in the Library cache the parsed information data will be
stored 2)DDC contains the dictionary tables which stores
the meta data information .
| Is This Answer Correct ? | 2 Yes | 0 No |
What is the effect of setting the value of OPTIMIZER_MODE to 'RULE' ?
From the database level, how can you tell under which time zone a database is operating?
Hi Guys,I have completed my B.com Commerc in the year 2005 and MBA finance in 2008(Correspondance).And I have 3+yrs exp in Accounting and Finance feild.I have worked for TCS for 1.8yrs as Project manage office as a enduser in oracle ERP module.Currently working as Project Adminstartor for CSC.I have joined in Oracle financial classes and I am through with that subject.So my concern is After learning oracle, am in dilemma that will i be eligible to get job in oracle or not?Please advice or Give me suggestions.To kick start my career as fresher in Oracle
does the query needs a hint to access a materialized view?
How to write a query with a full outer join in oracle?
what is integrity constrains?
Explain a segment?
What is enter substitution variable in oracle?
How a database is related to tablespaces?
What is oracle update statement with inner join ?
can any one help me with import/export options in oracle............
Explain the importance of .pll extension in oracle?