top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration Why to Join

Facebook Login
Site Registration

what are the Oracle database's physical and logical structure?

+2 votes
183 views
what are the Oracle database's physical and logical structure?
posted Jul 7, 2015 by Vidhya Sagar

Share this question
Facebook Share Button Twitter Share Button Google+ Share Button LinkedIn Share Button Multiple Social Share Button

1 Answer

0 votes
 
Best answer

Logical Database structures

Logical structures include tablespaces, schema objects, data blocks, extents and segments.

Tablespaces

Database is logically divided into one or more tablespaces. Each tablespace creates one or more datafiles to physically store data.

Schema objects

Schema objects are the structure that represents database's data. Schema objects include structures such as tables, views, sequences, stored procedures, indexes, synonyms, clusters and database links.

Data Blocks

Data block represents specific number of bytes of physical database space on disk.

Extents

An extent represents continuous data blocks that are used to store specific data information.

Segments
A segment is a set of extents allocated for a certain logical structure.

Physical database structure

The physical database structure comprises of datafiles, redo log files and control files

Datafiles

Datafiles contain database's data. The data of logical data structures such as tables and indexes is stored in datafiles of the database. One or more datafiles form a logical unit of database storage called a tablespace.

Redo log files

The purpose of these files is to record all changes made to data. These files protect database against failures.

Control files

Control files contain entries such as database name, name and location of datafiles and redo log files and time stamp of database creation

answer Jul 8, 2015 by Manikandan J
Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Bangalore-560102
Karnataka INDIA.
QUERY HOME
...