Database Administration - What are the components of logical database structure of Oracle database

GeekInterview.com > Interview Questions > Oracle > Database Administration

Go To First | Previous Question | Next Question

Database Administration | Question 2 of 231

What are the components of logical database structure of Oracle database

Total Answers and Comments: 6

Last Update: April 06, 2009

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

June 05, 2005 22:16:29

Yoaga

RE: What are the components of logical database structure of Oracle database

Tablespace segments extens data Blocks.

A logical unit of storage of databse is called Tablespace.

Segments is a space alloocated for a specific logical storage structure within a tablespce.

Extents: Space allocated to a segments.

Datablocks: Oracle server manage the storage space in the datafiles in units is called data blocks or oracle blocks.

Is this answer useful? Yes | No

September 01, 2005 14:36:26

rajesh

RE: What are the components of logical database structure of Oracle database

thanks for providing for this.it is very usefull for us
thanx

Is this answer useful? Yes | No

September 12, 2005 17:26:12

shalini

RE: What are the components of logical database structure of Oracle database

Oracle database constitutes of tablespaces which are made of segments which inturn have extents which are made out of oracle blocks.

Is this answer useful? Yes | No

January 08, 2007 15:26:13

RAVI

RE: What are the components of logical database struct...

Components of Logical Database:--

1. Tablespace - A tablespace consist Datablock Extends and Segments

2. Schema - A schema includes --

Index Tables Views Clusters Stored Procedures Triggers and Sequences

Thanks

Is this answer useful? Yes | No

July 22, 2007 09:11:37

waqas

RE: What are the components of logical database struct...

Data objects are used to stored data when needs to grow take chunks of space that is called extents and an data objects multiple extents are stored in segment.

Is this answer useful? Yes | No

April 05, 2009 13:29:55

sivaraju.sateesh

Member Since: January 2009 Contribution: 10

RE: What are the components of logical database structure of Oracle database

Oracle logical structure follows the order like
Tablespace
Segments

Extents
Datablocks

Oracle database consists of tablesapces (one or more tablespace forms database)

Segments is the area in which on oracle object sores in a tablespace.
One Oracle object will be in the one segment only.

Segment needs to extent the size of the segment then the memory will be allotted in extents.

Each extent is the collection of Oracle blocks.
So the logical architecture of the Oracle follows like above.

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank