What are the components of Logical database structure of
ORACLE database?
- 4 Answers
- 12964 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 |
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?
How do you increase the OS limitation for open files (LINUX and/or Solaris)?
What is merge in oracle?
What is DTS and purpose of DTS ?
What is the difference between substr & instr functions?
does the query needs a hint to access a materialized view?
What is difference between SUBSTR and INSTR?
select * from emp what happened internally when we write this query in the sql prompt?
What are the varoius components of physical database structure of oracle database?
How to recover a dropped table in oracle?
when loggined as SYSTEM,how to display all the users of database using sql query?
What are the different approaches used by Optimizer in choosing an execution plan ?
Oracle General 
