Interested to Buy Any Domain ? << Click Here >> for more details...
What are the components of Logical database structure of
ORACLE database?
- 4 Answers
- 14820 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 |
How to delete a column in an existing table in oracle?
Who i will insert 1 lacks record in a Database table
What are the different windows events activated at runtime ?
What is a subquery in oracle?
How to update values in a table in oracle?
What is a nvl function? How can it be used?
How does oracle handle read consistency?
What is connection pooling in oracle?
What is ordinary table in oracle?
What is a package ? What are the advantages of package ?
What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
Explain constraining triggers.
Oracle General 
