471,354 Members | 2,027 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,354 software developers and data experts.

Logical & Physical Structure

Hi,

a) Why oracle architecture is divided into 2 types logical and physical structure?
b) What is the use of logical structure in oracle as it does not consume any space if so then what is the use of physical structure?

Regards,
Naveen
Jun 6 '07 #1
3 12615
debasisdas
8,127 Expert 4TB
In Oracle the physical structures are:
---------------------------------------------------------
Datafiles
Control Files
Redo Log Files
Archive Log Files
Parameter Files
Alert and Trace Log Files
Backup Files

The Logical Structures are:
-----------------------------------------
Tablespaces
Oracle Data Blocks
Extents
Segments

As your question is too thepritical to answer/explain ,Please follow the Link
for further details .

Hope this one is an important resource to clarify your doubts.
Jun 6 '07 #2
Physical vs Logical can mean differnet things in different contexts . From Oracle perspective I think -

Physical : Because you can see the entites being physically present for example as OS Files(*.dbf etc)

Logical : The logical entites exist but you can not see them physically as such
blocks , extents , tablespaces all exist but not as the real physical structures .They are not real structures in physical sense, we combine certain structures and logically make them 1. Certain number of Bytes together logically making Blocks, Block together making extent , extent together logically making segments etc.

A tablespace can consist of one or more datafiles, you can see the datafiles(physical- as OS files) but not the tablespace(physically no ).Its existence is logical( one or more files make it). Similarly extents , you can not see them , it is a concept a logical view - they are just contiguous blocks , you do not seem them physically . So they do not exist in a way that you see real physical structures , their presence is just logical.

Hope I have not confused you more :-)
Jun 18 '07 #3
debasisdas
8,127 Expert 4TB
Yes avadhera you are absolutely right .

Welcome to TSDN.

You have reached the right place for knowledge shairing.

Here you will find a vast resource of related topics and code.

Feel free to post more doubts/questions in the forum.

But before that give a try from your side and if possible try to post what/how you have approached to solve the problem.

It will help Experts in the forum in solving/underestanding your problem in a better way.

Please follow the posting guidelines in every new post/reply.

Regards

Debasis
Jun 18 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

reply views Thread by basement_addict | last post: by
6 posts views Thread by Leif K-Brooks | last post: by
reply views Thread by Mark Stokes | last post: by
8 posts views Thread by Andrew Maclean | last post: by
1 post views Thread by DazedAndConfused | last post: by
2 posts views Thread by Old Fossil Bama | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.