Oracle Database Management & Other Database Tools

Starting with Oracle Database 11g 

Database Structure:

Memory Structure 

Process Structure

User Process: 

User process is started at the time of a database user request a connection to the oracle server .

Server Process: 

Connect to the oracle instance and is started  when  a user establishes a session .

Background Processes:

are started when an oracle instance is started

Oracle Instance Management

Server Process and Database Buffer Cache 

Physical Database Structure

TableSpaces & Data Files

Tablespaces consist of one or more data files & data files belongs to only one tablespace

SYSTEM AND SYSAUX TABLESPACES

The SYSTEM & SYSAUX Tablespaces are mandatory tablespaces .
They are created at the time of database creation.
They must be online
The system tablespace is used to core functionality (for example , data dictionary tables).
The auxiliary SYSAUX tablespace is used for additional database components (such as the Enterprise Manager Repositary).

SEGMENTS , EXTENTS & BLOCKS 

• Segments exist within tablespace
• Segments are made up of collection of extents .
• Extents are the collection of blocks
• Data blocks are mapped to disk blocks.

Logical & Physical Structure 

Tools Used to Database Administrator an Oracle 

• Oracle Universal Installer
• Database Configuration Assistant
• Database upgrade Assistant
• Oracle Net Manager
• Oracle Enterprise Manager 
• SQL *Plus
• Recovery Manager
• Oracle Secure Backup
• Data Pump
• Command Line Tools

Installation System Requirement