What are the components of Logical database structure of
ORACLE database?
Answer Posted / rameshkumar.k
The logical DB contains shared pool(library cache,data dictionary cache),data buffer cache,redolog buffer,java buffer and large pool.
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Can you assign multiple query result rows to a variable?
What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar
What are transaction isolation levels supported by oracle?
What is transport network substrate (tns) in oracle?
What is hash cluster in oracle?
Describe varray?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
Point the difference between translate and replace?
Why does oracle 9i treat an empty string as null?
How to convert times to characters in oracle?
Explain constraining triggers.
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
Is there any function in oracle similar like group_concat of mysql?
How to use "startup" command to start default instance?
Explain the use of record length option in exp command.