Oracle 9i,10g,11g RDBMS & RAC



Some stuff here, is quite old. But still... most hold, even today.
And there is some new material too...


SECTION 1: My own notes:

1.1 Short Overviews:

Just a few often used SQL statements (html)


1.2 Quick Oracle Facts (this list will grow...):

Quick overview 10g/11g SGA (html)
Quick overview (of some) 10g/11g systemviews (html) (see also 1.4)


1.3 PLSQL:

Yes, it's old, but still a lot is usable: PLSQL info txt file (txt file)


1.4 Simplified dictionary mini "posters":

All posters below in 1 html page
Simplified Overview of dictionary Oracle10g/11g with respect to Locks and Sessions (Excel format)
Simplified Overview of dictionary Oracle10g/11g with respect to Performance not using ADDM (1) (Excel format)
Simplified Overview of dictionary Oracle10g/11g with respect to Objects (tables, indexes etc..) (Excel format)
Simplified Overview of dictionary Oracle10g/11g with respect to Permissions (Excel format)


1.5 Overview RAC:

Yes, it's old: Some simple notes on Oracle RAC 10gR2 (Excel format)
Some simple notes on Oracle RAC 11gR2 / 12c (html)


1.6 Some general subjects:

Listing of some Oracle 10g/11g facts & structures (for exam 1Z0-052, excel format)


1.7 Some docs on how to deal with block corruption:


Extremely short note on quick fixing Oracle block corruption (version 0.3, Excel)
Better descriptions on handling Oracle corruption (version 1.1, html)


1.8 Some general subjects:

Oracle 9i and 10g commands and queries (txt file)
How to view locks and transactions in Oracle 9i,10g,11g (Excel format)
How to investigate events and waits in Oracle 9i,10g,11g (Excel format)
How to setup CDC in Oracle 10g,11g (Excel format)
A few notes on backup and recovery Oracle with RMAN in 9i,10g (Excel format)
Some notes about undocumented Oracle init.ora parameters (txt file)


1.9 Some common ORA- and RMAN- errors:

Some common ORA- and RMAN- errors (txt file)


SECTION 2: Other Documents:

2.1: Technical documents on the Oracle Block (page) architecture:

Header and Tail - Oracle Block format article (1)
Data Block Internals - Oracle Block format article(2)
The Data Block and BBED - Oracle Block format article (3)
The structure of a row - Oracle Block format article (4)
How to dump Blocks - Oracle Block format article (5)


2.2: Documents on corruption and crashes:

Preventing and repairing corruption (oracle.com)
Quick link to DBMS_REPAIR package 11gR2
Quick link to DBMS_REPAIR package 10gR2
Good article using SQL to retrieve rows from corrupt objects.
Bulletproofing, Backups, and Disaster Recovery Scenarios
Nice article using 11g Data Recovery Advisor


2.3: Documents on Data Guard:

Quick and to the point setup of DG 11.2 part 1
As above, part 2


2.4: Documents on RAC 11g:



SECTION 3: Libraries and Errors:

ORA-errcode and other err listings (oracle docs)

RMAN 11.2 troubleshooting (oracle docs)
RMAN 10.2 troubleshooting (oracle docs)
RMAN 9i troubleshooting (oracle docs)
Some RMAN troubleshooting scenario's (1) (oracle docs)
Some RMAN troubleshooting scenario's (2) (oracle docs)

Doc Lib 11.2
Doc Lib 10.2






















Last update: 10 June, 2012