473,394 Members | 1,674 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,394 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 12777
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

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

Similar topics

0
by: basement_addict | last post by:
First off I am new to xmlrpc.I am working on a project that requires me to return this structure. <?xml version="1.0"?> <methodResponse> <params> <param> <struct> <member> <name>files</name>
6
by: Leif K-Brooks | last post by:
I got bored with working on larger projects and wrote a little script/module for counting logical (not physical) lines of Python code in a file or directory. It uses ASTs generated by...
0
by: Mark Stokes | last post by:
Hi there, I wanted a bit of advice on a program (a prototype) that I am trying to write that uses threads. I will outline what I am attempting to do, and if anyone has any advice on the way I...
8
by: Andrew Maclean | last post by:
Does VC7.1 support hyperthreading? I looked in the documentation but I could find no reference at all.
1
by: DazedAndConfused | last post by:
Is it proper to structure your code in the basic work flow of the program? i.e. Form_Load
4
by: Ashish_CPP | last post by:
Hi, Can anyone help me and suggest some good C books that enhances the logical & problem solving skills. I dont want those books which teach C/C++ rather I want those books to be suggested that...
2
by: Old Fossil Bama | last post by:
In DB2/400, if I run this statement: delete from ordvcrec a where not exists(select * from i$paint b where a.part#=b.i$part) Where ORDVCREC is a join logical of physical files ORDVALID and...
1
by: gdia44 | last post by:
Hello, This is my first post to this forum. I'm working through an exercise where I am required to 'design and describe' the logical and physical structure for a case study. I've made quite...
0
by: prassaad | last post by:
Hi everyone! I don't understand what is actual difference between logical & raw reading happens during copying data.... I m waiting......
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

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.