Interested to Buy Any Domain ? << Click Here >> for more details...
What are the components of Logical database structure of
ORACLE database?
- 4 Answers
- 14909 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / jidnesh
The Logical Database Structure of an Oracle include the
schema objects, data blocks, extents, segments and tablespaces.
schema objects means table, index, synonyms, sequences etc.
Data blocks are the smallest part of the oracle database
defined by DB_BLOCK_SIZE parameter.
A group of data blocks forms an extent.
An extents groups tends to segments, and lastly a group of
segment forms a tablespace.
| Is This Answer Correct ? | 26 Yes | 4 No |
Answer / 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 |
Answer / nishi
There are tablespaces and database's schema objects.
| Is This Answer Correct ? | 0 Yes | 1 No |
Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?
What is a subquery?
What is the data type of dual table?
What are the trigger associated with image items ?
What is a sub query? What are its various types?
what is the uses of cusor
Explain an index segment?
Can you create a synonym without having a table?
What is coalesce function?
What is OCI. What are its uses?
How do I limit the number of oracle database connections generated by weblogic server?
How to find the duplicate rows count from employees table in oracle?
Oracle General 
