learn-oracle




Oracle Instance


Instance Memory Structure

The size of these structures affects the performance of the Oracle database server and is controlled by initialization parameters.
Oracle Background Processes

Oracle creates a set of background processes for an instance that interact with each other and with the operating system to manage memory structure, asynchronously perform I/O to write data to disk, and do general housekeeping.
 
Accessing the Database

The database instance can be started (made available) only by an authorized database administrator who has a special type of connection privilege to the Oracle instance.
Shuting down and Restarting the instance and Database

Oracle DBA can start and shut down your Oracle database with the Windows Services program.
 
Viewing and Modifying Initialization

When Oracle DBA install one of the preconfigured databases provided by Oracle, the initialization parameters are optimized for normal use in the environment that you specified.
Managing Memory Parameters

Some initialization parameters, referred to here as memory parameters, determine the total size of the system global area (SGA) and the program global area (PGA), and of the subcomponents of the SGA.

More Tutorials on Oracle dba ...


Liked it ? Want to share it ? Social Bookmarking

Add to: Mr. Wong Add to: BoniTrust Add to: Newsider Add to: Digg Add to: Del.icio.us Add to: Reddit Add to: Jumptags Add to: StumbleUpon Add to: Slashdot Add to: Netscape Add to: Furl Add to: Yahoo Add to: Spurl Add to: Google Add to: Blinklist Add to: Technorati Add to: Newsvine Information


Source : Website | Oracle DBA

Want to share or request Oracle Tutorial articles to become a Oracle DBA. Direct your requests to webmaster@oracleonline.info





   Forum
Oracle Forum   
Google

Oracle DBA Tutorial
Introduction
Installation
Oracle Enterprise Manager
Configuring client/server network
Database Instance
Database Storage Structures
DBA Accounts
Managing Oracle Objects
Backup & Recovery Concepts
Database Monitoring

SQL Statement Tuning
Backup and Recovery Concepts
Oracle 11g New Features
Oracle E Suite & Others
Oracle Data Guard
Oracle DBA FAQ