What are the components of Logical database structure of
ORACLE database?
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 |
How to rename an index in oracle?
How to drop an existing view in oracle?
Explain the use of grant option in imp command.
What is Private Database Link ?
What is the difference between Outer join and Full outer join?
what is RAID technology?which is better RAID 0+1 OR RAID 5?
How to open a cursor variable?
What types of joins are used in writing subqueries?
How to install oracle odbc drivers?
What is Redo Log Buffer in Oracle?
How to display the hierarchy of employee and managers without using connect by prior.
Describe varray?