Interested to Buy Any Domain ? << Click Here >> for more details...
What are the components of Logical database structure of
ORACLE database?
- 4 Answers
- 14827 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 define a sub function?
When a form is invoked with call_form, Does oracle forms issues a save point ?
when do u go for hash partitioning?
How to drop an existing view in oracle?
 What are the oracle DML commands possible through an update strategy?
What is the relation of a user account and a schema in oracle?
What are the differences between interval year to month and interval day to second?
Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?
HI, Please let me know the syllabus for Oracle OCA and OCP Certification
What is SQL Tuning Advisor in Oracle?
What are the general rules on data consistency?
What is an oracle database table?
Oracle General 
