Oracle Database

From Wikibooks, the open-content textbooks collection

The Oracle Database (also referred as Oracle RDBMS or Oracle) consists of a relational database management system (RDBMS) produced and marketed by Oracle Corporation. Oracle had become a major presence in database computing.

Contents 1 Table of Contents 2 Oracle Database Management Tools 2.1 Oracle processes 3 External links

[edit] Table of Contents

• Introduction
• Adding and removing users
• Monitoring Storage and Memory
• SQL
• Importing and exporting
• Reports

[edit] Oracle Database Management Tools

• Oracle SQL Developer
• Navicat for Oracle GUI Admin Tool

[edit] Oracle processes

The Oracle RDBMS typically relies on a group of processes running simultaneously in the background (computer software) and interacting to further and monitor database operations. Such processes (and their standard abbreviations) can include:

• archiver processes (ARCn)
• checkpoint process (CKPT)
• coordinator-of-job-queues process (CJQn): dynamically spawns slave processes for job-queues
• database writer processes (DBWn)
• dispatcher processes (Dnnn): multiplex server-processes on behalf of users
• memory-manager process (MMAN): used for internal database tasks such as Automatic Shared Memory Management
• log-writer process (LGWR)
• log-write network-server (LNSn): transmits redo logs in Data Guard environments
• logical standby coordinator process (LSP0): controls Oracle Data Guard log-application
• media-recovery process (MRP): detached recovery-server process
• memory-monitor process (MMON)
• memory-monitor light process (MMNL): gathers and stores Automatic Workload Repository (AWR) data
• process-monitor process (PMON)
• process-spawner (PSP0): spawns Oracle processes
• queue-monitor processes (QMNn)
• recoverer process (RECO)
• remote file-server process (RFS)
• shared server processes (Snnn): serve client-requests
• system monitor process (SMON)

[edit] External links

• Oracle Database, a view provided by Oracle Corporation
• Oracle tutorial, a quick understanding and visualization of Oracle environment and administration
• Oracle PL/SQL, an easy guide to learn Oracle PL/SQL. Also most of the Oracle Topics discussed.