| OracleTM Database Server Architecture |
Understanding Database Objects |
 |
Oracle™ Enterprise Manager (OEM) |
|
OEM Console |
|
Application Architectures
2-tier traditional Client/Server
3-tier traditional Client/Server
3-tier traditional Intranet or Internet
|
|
The Oracle™ Database Server |
|
How does a SQL Statement execute? |
|
What is the Data Dictionary? |
|
Databases Users & Schemas |
|
SYS Schema illustrated |
|
OEM Security Manager, Users |
|
Data Dictionary, DBA_USERS |
|
|
Which Database Objects exist? |
|
OEM Schema Manager, Schema Objects |
|
Data Dictionary, DBA_OBJECTS |
|
OEM Schema Manager, Tables (General tab) |
|
Data Dictionary, DBA_TABLES |
|
Data Dictionary, USER_TAB_COLUMNS |
|
OEM Schema Manager, Tables (Constraints tab) |
|
Data Dictionary, DBA Constraints |
|
Data Dictionary, DBA_CONS_COLUMNS |
|
OEM Schema Manager, Sequences |
|
Data Dictionary, DBA_SEQUENCES |
|
| Instance & User Memory Structures |
Instance & User Processes |
|
IFILE Parameter |
|
OEM Instance Manager, Initialisation Parameter |
|
Single Instance |
|
Concurrent Instances and Database, same Server |
|
Multiple Instances for one Database, same server |
|
Oracle™ Real Application Clusters |
|
Multiple Instances for one database, clustered Servers |
|
SYSTEM GLOBAL AREA (SGA) |
|
How the Java Pool is used |
|
Parameters which determine SGA size |
|
About Oracle™ Buffer Cache & Subcaches |
|
SGA Size |
|
|
Which processes are executing? |
|
Instance background processes |
|
Instance background system processes illustrated |
|
DBWR & LGWR processes |
|
Checkpoints and CKPT process |
|
SMON & PMON processes |
|
ARCH processes |
|
OEM Instance Manager, background process list |
|
Oracle™ Jserver Instance, Oracle™ Jserver Instance illustrated |
|
SQL execution |
|
PGA & instance |
|
Data Dictionary, V$SESSION |
|
OEM instance manager, sessions |
|
| Auditing Database Usage |
An Introduction to Backup & Recovery |
|
Auditing Users and Objects |
|
Specifying Auditing for the Instance |
|
AUDIT_TRAIL Parameter Options |
|
Specifying Auditing Actions |
|
AUDIT/NOAUDIT |
|
Maintain the Audit Trail |
|
|
About Backup & Recovery |
|
Archiving |
|
ARCHIVELOG |
|
Data Dictionary, ARCHIVELOG status from V$DATABASE |
|
BACKUO |
|
RECOVERY |
|
| Utilities |
Utilities, Exporting & Importing Data |
|
About the Database Utilities |
|
Using the LOADER, LOADCTL Control File |
|
Understanding the LOADER Process |
|
Control File Options, Direct Path Loads |
|
|
| Managing Physical Storage of Tables |
Managing Indexes |
|
Table Physical Storage |
|
CREATE and ALTER TABLE |
|
CHAINED ROWS |
|
|
| Managing Clusters & Indexed Organised Tables |
National Language Support (NLS) |
| Data Files, Data Segments |
Data Files, Non-Data Segments |
|
Which files are used by the database |
|
Data files & the physical storage hierarchy |
|
Understanding tablespaces |
|
Understanding data files, segments |
|
Understanding E_DERST |
|
Understanding database blocks |
|
PCTFREE/PCTUSED |
|
Understanding the row structure |
|
Understanding R_D |
|
ROWID_TO_RESTRICTED() and ROWID_TO_EXTENDED() |
|
|
The non-data S_TA |
|
Indexes & index segments |
|
Bitmap Vs. B-tree index scenario |
|
DBA_INDEXES |
|
DBA_IND_COLUMNS |
|
Temporary segments, Rollback segments |
|
DBA_SEGMENTS, Rollback segments |
|
V$ROLLNAME and V$ROLLSTAT |
|
| Non-Data Files |
Installation & Database Creation |
| Database Maintenance, Other Structure |
Managing User Security |
|
Rollback Segment Maintenance |
|
Create Rollback Segment |
|
Using OEM Storage Manager for Rollback Segments |
|
ALTER ROLLBACK SEGMENT |
|
DROP ROLLBACK SEGMENT |
|
DBA_SEGMENTS |
|
V$ROLLNAME and V$ROLLSTAT |
|
OPTIMAL size |
|
ALTER DATABASE |
|
ALTER SYSTEM |
|
Dynamic Changes with ALTER SYSTEM |
|
|
Managing Users |
|
CREATE, ALTER, DROP USER |
|
GRANT & REVOKE System Privileges |
|
Roles |
|
WITH ADMIN OPTION |
|
SET ROLE |
|
Data Dictionary Storage of Privileges and Roles |
|
Managing Users with OEM |
|
CREATE PROFILE |
|
ALTER,DROP,PROFILE |
|
Finding & Killing a Session |
|
