Oracle Database Architecture
Generally, Oracle RDBMS (Relation Database Management System) architecture consist of following components: Memory, processes, and files. The components are grouped into following:
- Instance
- Instance memory or System Global Area (SGA): Shared Pool (Libary Cache and Data Dictionary Cache), Database Buffer Cache, Redolog Buffer Cache, Java Pool, Large Pool.
- Back ground process: PMON, SMON, DBWR, LGWR, CKPT, Others - Database
- Datafiles
- Control files
- Redo log files - Other components
- Other process: Server Process, user process
- Other memory: Program Global Area (PGA)
- Other files: Archived logs, parameter, and password files
How to self-learn Oracle Database
Oracle is too kind to share knowledge. We can read Oracle documentation (contain unlimited knowledge) online in the web. We also can download Oracle DBMS (Database Management System) software and documentations freely.
Oracle really want to educate its user and everyone who eager to learn Oracle products. Of course, the goal is to make everyone use Oracle products, and then everyone pay Oracle license.
Through this article I share tips & tricks self learning of Oracle Database. I take Oracle Database 10g as example.
I. Read Oracle documentation.
You can read Oracle documentation online in internet. By download the source first, you can also read the documentation off line in your PC.
Here is the list of Oracle Documentation
- Index of all documentation (8, 8i, 9i, 10g, dan 11g)
http://www.oracle.com/technology/documentation/index.html - Documentation source of 10g version, ready to be downloaded.
http://download.oracle.com/docs/cds/B19306_01.zip - Documentation source of 10g version, ready to be read online.
http://www.oracle.com/pls/db102/homepage
There are so many-many documentation and knowledge. How to start? I recommend to read following documentation one by one (please read in order manner).
Read more
How to get OCP Database 10g
To get Oracle Database 10g Administrator Certified Professional (OCP 10G) you must pass following requirements:
- Pass OCA 10G (Oracle Database 10g Administrator Certified Associate) requirements
- Pass exam 1Z0-043 ((Oracle Database 10g: Administration II)
- Complete one of the approved instructor-led online or in-class courses.
- Submit the Hands On Course Requirement Form
Following courses are approved instructor-led (online or in-class) courses. You must complete one of following curses:
Read more
How to get OCA Database 10g
To get Oracle Database 10g Administrator Certified Associate you must pass following exams:
- Oracle Database 10g: Administration I (exam no. 1Z0-042)
- On December 1, 2008 Oracle will introduce an additional SQL exam requirement for this certification. In addition to the existing exam (1Z0-042) candidates will also be required to pass any one of the three following Oracle SQL exams to earn the certification:
- Introduction to Oracle9i: SQL (1Z0-007)
- Oracle Database 11g: SQL Fundamentals I (1Z1-051)
- Oracle Database SQL Expert (1Z0-047)
So, hurry up to get the OCA 10g before December 1, 2008; you are required only 1 exam. After that time you will be required 2 exams.
OCP 10G Exam 1Z0-043 (Oracle Database 10g: Administration II)
Certification Name : Oracle Database 10g Administrator ' Certified Professional (OCP 10g) Exam Number : 1Z0-043 Exam Price : $125.00 USD Duration : 90 minutes Number of Questions : 70 Passing Score : 70%
Recommended Training:
Oracle Database 10g: Administration Workshop II
Exam Material
(The exam material is the same with Oracle Database 10g: Administration Workshop II training material):
OCA 10G Exam 1Z0-042 (Oracle Database 10g: Administration I)
Certification Name : Oracle Database 10g Administrator ' Certified Associate (OCA 10g) Exam Number : 1Z0-042 Exam Price : $125.00 USD Duration : 120 minutes Number of Questions : 84 Passing Score : 68%
Recommended Training:
Oracle Database 10g: Administration Workshop I Release 2
Recommended Oracle Documentation:
- Oracle® Database Platform Guide10g Release 2 (10.2) for Microsoft Windows (32-Bit)
- Oracle® Database Installation Guide10g Release 2 (10.2) for Linux x86, Troubleshooting
- Oracle® Database Concepts10g Release 2 (10.2), Chapter 7
- Oracle® Database Concepts10g Release 2 (10.2), Chapter 2
- Oracle® Database Administrator’s Guide10g Release 2 (10.2), Chapter 12
- Oracle® Database Security Guide10g Release 2 (10.2),Chapter 11
- Oracle® Database Administrator’s Guide10g Release 2 (10.2), Chapter 13
- Oracle® Database Administrator’s Guide10g Release 2 (10.2), Chapter 16
- Oracle® Database Performance Tuning Guide10g Release 2 (10.2), Chapter 5
- Oracle® Database Performance Tuning Guide10g Release 2 (10.2), Chapter 12
- Oracle® Database Administrator’s Guide10g Release 2 (10.2), Chapter 2
- Oracle® Database Administrator’s Guide10g Release 2 (10.2), Chapter 15
- Oracle® Database Utilities10g Release 2 (10.2), Chapter 1
- Oracle® Database Utilities10g Release 2 (10.2), Chapter 6
Exam Material
(The exam material is the same with Oracle Database 10g: Administration Workshop I Release 2 training material):
Read more
Oracle Database Certification Program
ORACLE DATABASE 11g
- Oracle Database 11g Administrator Certified Associate
- Oracle Database 11g Administrator Certified Professional
- Oracle Database 11g Administrator Certified Master
ORACLE DATABASE 10g
- Oracle 10g: Managing Oracle on Linux Certified Expert
- Oracle Database 10g: Administering Real Application Clusters Certified Expert
- Oracle Database: SQL Certified Expert
- Oracle Database 10g Administrator Certified Associate
- Oracle Database 10g Administrator Certified Professional
- Oracle Database 10g Administrator Certified Master
ORACLE9i DATABASE
- Oracle9i Database Administrator Certified Associate
- Oracle9i Database Administrator Certified Professional
- Special Accreditation: Managing Oracle9i on Linux
Download Ebook Oracle Database Administration (Guide) 10g
The book title is Oracle® Database Administrator’s Guide 10g Release 2 (10.2)
The book contain following chapters:
Part I Basic Database Administration
- Overview of Administering an Oracle Database
- Creating an Oracle Database
- Starting Up and Shutting Down
- Managing Oracle Database Processes
Part II Oracle Database Structure and Storage
- Managing Control Files
- Managing the Redo Log
- Managing Archived Redo Logs
- Managing Tablespaces
- Managing Datafiles and Tempfiles
- Managing the Undo Tablespace
Part III Automated File and Storage Management
- Using Oracle-Managed Files
- Using Automatic Storage Management
Part IV Schema Objects
- Managing Schema Objects
- Managing Space for Schema Objects
- Managing Tables
- Managing Indexes
- Managing Partitioned Tables and Indexes
- Managing Clusters
- Managing Hash Clusters
- Managing Views, Sequences, and Synonyms
- Using DBMS_REPAIR to Repair Data Block Corruption
Part V Database Security
- Managing Users and Securing the Database
Part VI Database Resource Management and Task Scheduling
- Managing Automatic System Tasks Using the Maintenance Window
- Using the Database Resource Manager
- Moving from DBMS_JOB to DBMS_SCHEDULER
- Scheduler Concepts
- Using the Scheduler
- Administering the Scheduler
Part VII Distributed Database Management
- Distributed Database Concepts
- Managing a Distributed Database
- Developing Applications for a Distributed Database System
- Distributed Transactions Concepts
- Managing Distributed Transactions
Download the ebook here.
Download Ebook Oracle Database Administration 10g ( 2 Day DBA)
The book title is Oracle® Database 2 Day DBA 10g Release 2 (10.2).
The book contain following chapters:
- Introduction
- Installing Oracle and Building the Database
- Getting Started with Oracle Enterprise Manager
- Configuring the Network Environment
- Managing the Oracle Instance
- Managing Database Storage Structures
- Administering Users and Security
- Managing Schema Objects
- Performing Backup and Recovery
- Monitoring and Tuning the Database
- Managing Oracle Software
- Automatic Storage Management
- Overview of Real Application Clusters
Download the ebook here.
Download Ebook Oracle Database Administration (Guide) 11g
The book title is Oracle® Database Administrator’s Guide 11g Release 1 (11.1)
The book contain following chapters:
Part I Basic Database Administration
- Getting Started with Database Administration
- Creating and Configuring an Oracle Database
- Starting Up and Shutting Down
- Managing Processes
- Managing Memory
- Managing Users and Securing the Database
- Monitoring Database Operations
- Managing Diagnostic Data
Part II Oracle Database Structure and Storage
- Managing Control Files
- Managing the Redo Log
- Managing Archived Redo Logs
- Managing Tablespaces
- Managing Datafiles and Tempfiles
- Managing Undo
- Using Oracle-Managed Files
Part III Schema Objects
- Managing Schema Objects
- Managing Space for Schema Objects
- Managing Tables
- Managing Indexes
- Managing Clusters
- Managing Hash Clusters
- Managing Views, Sequences, and Synonyms
- Repairing Corrupted Data
Part IV Database Resource Management and Task Scheduling
- Managing Automated Database Maintenance Tasks
- Managing Resource Allocation with Oracle Database Resource Manager
- Oracle Scheduler Concepts
- Scheduling Jobs with Oracle Scheduler
- Administering Oracle Scheduler
Part V Distributed Database Management
- Distributed Database Concepts
- Managing a Distributed Database
- Developing Applications for a Distributed Database System
- Distributed Transactions Concepts
- Managing Distributed Transactions
Download the ebook here.