What are the components of Logical database structure of
ORACLE database?
- 4 Answers
- 13717 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 write numeric literals in oracle?
what are the different types of cursors? explain?
What is analyze command used for?
What are the types of partitions in oracle?
What is the effect of setting the value "ALL_ROWS" for OPTIMIZER_GOAL parameter of the ALTER SESSION command ?
How to select the name of employee who is getting maximum sal with out using subquery
How to find the duplicate rows count from employees table in oracle?
What is procedure overloading in oracle?
How to count duplicated values in a column in oracle?
Whatz the main diff between Subquery and a Join
14 Answers Oracle, Zeta Interactive,
src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));
What is meant by recursive hints ?
Oracle General 
