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 do you mean by a tablespace?
select to_char('10','10') from dual This gives me an error oRA-1481 INVALID NUMBER FORMAT MODEL why? pls help
Why do we use bulk collect in oracle?
What is the Difference between 1) ER MODEL and Relational Model 2) Dense Index and Sparse Index
How to check the server version in oracle?
What is oracle database client?
what is difference between table and view? where to use views? thanks in advance!
how to use sequence and what use of sequence cache
What are inner join and outer join?
What are the benefits of ordbms?
i can create a view with two columns from emp table,, later i need to add one more emp column to existing view.. what is query similarly add one more column to existing primary key constraint.. please give me the solutions
how to tune oracle sql queries pls tell me step by step. urgent pls