Answer Posted / 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 |
Post New Answer View All Answers
What is ceil and floor in oracle?
Which is better Oracle or MS SQL? Why?
What view(s) do you use to associate a users SQLPLUS session with his o/s process?
Explain an index?
What is the difference between translate and replace in oracle?
How to install oracle odbc drivers?
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
What are the database administrators utilities available?
How do we create privileges in oracle?
What is meant by an index?
What happens if the imported table already exists?
How to install oracle database 10g xe?
What are the different types of record groups in oracle? Explain each of them
Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..
can u plz provide me oca sql dumps please i need them