Oracle 9i Admim
1. Oracle RDBMS 1.1 (System Global Area:SGA) 1.1.1 (Shared Pool) 1.1.2 (Database Buffer Cache) 1.1.3 (Redo Log Buffer) 1.1.4 Java Pool Large Pool 1.2 Program Global Area (PGA) 1.3 Oracle Background Process 1.3.1 Oracle 1.3.2 1.4 (Server Process) (User Process) 1.4.1 (Server Process) 1.4.2 (User Process) 1.5 Oracle Instance 1.6 Oracle Database 1.6.1 (Data Files) 1.6.2 (Control Files) 1.6.3 (Redo Log Files) 1.7 Oracle Architecture 2. 2.1 Oracle DB (StartUp) 2.1.1. Oracle DB 2.1.2 DB 2.1.3 ALTER DATABASE 2.2. (Shutdown) 2.2.1 Oracle DB 2.2.2 DB 2.3 PFILE(Parameter File) SPFILE(Server Parameter File) 2.3.1 PFILE (Parameter File)
2.3.2 SPFILE (Server Parameter File) 2.3.3 CREATE PFILE/SPFILE 3. Control Files 3.1 Control File 3.1.1 3.1.2 3.1.3 3.1.4 4. Redo Log Files 4.1 Redo Log File 4.1.1 4.1.2 4.1.3 4.1.4 4.2 Redo Log File 4.2.1 4.2.2 4.2.3 4.2.4 4.2.5 Redo Log 4.2.6 5. (TABLESPACE) 5.1 (TABLESPACE)? 5.1.1 Tablespace? 5.1.2 Tablespace 5.1.3 Tablespace 5.2 Tablespace 5.2.1 Tablespace 5.2.2 Tablespace 5.3 Tablespace 5.3.1 Tablespace 5.4 Tablespace 5.4.1 Default Storage 5.4.2
5.4.3 (OFFLINE) Tablespace 5.4.4 (ALTER DATABASE) 5.4.5 (Read Only) Tablespace 5.5 Tablespace 5.5.1 Tablespace 5.6 Locally Managed Tablespaces 5.6.1 Locally Managed Tablespaces? 5.6.2 Locally Managed Tablespaces 5.6.3 Locally Managed SYSTEM Tablespaces 5.6.4 DMTLMT 5.7 5.7.1 6. Storage Structure 6.1 Oracle Storage Structure 6.1.1 Structure Relationship 6.1.2 Storage Structure 6.2 Database Block 6.2.1 Database Block 6.2.2 6.2.3 PCTFREE 6.2.4 PCTUSED 6.2.5 PCTFREE = 20 / PCTUSED = 40 6.3 Oracle BlockExtent 6.3.1 Data Block 6.3.2 Extent 6.4 Storage 6.4.1 Storage 6.4.2 Storage 7. (Rollback Segment) 7.1? 7.1.1? 7.1.2 7.1.3 7.2
7.2.1 (Growth) 7.2.2 (Shrinkage) 7.3 7.3.1 7.3.2 8. (Undo Segment) 8.1 Undo Segment? 8.2 Undo 8.2.1 Undo 8.2.2 Undo 9. (Managing Indexes) 9.1 9.1.1 9.1.2 Unique NonUnique 9.2 9.2.1 9.2.2 9.3 B-Tree 9.3.1 B-Tree 9.3.2 9.4 9.4.1 9.4.2 9.5 (REBUILD) (COALESCE) 9.5.1 9.5.2 9.6 9.6.1 9.6.2 9.7 9.7.1 9.7.2 10. (Managing Clusters)
10.1 (Cluster) 10.1.1? 10.2 (Index Cluster) 10.2.1? 10.2.2 11. (Managing Profiles) 11.1 11.1.1? 11.1.2 11.1.3 11.1.4 11.2 11.2.1? 11.2.2 12. IOT(Index Organized Table) 12.1 IOT(INDEX ORGANIZED TABLE) 12.1.1 IOT(INDEX ORGANIZED TABLE)? 12.2 IOT(INDEX ORGANIZED TABLE) 12.2.1 IOT 12.2.2 IOT 12.2.3 IOT 9i 13. (Auditing) 13.1 (Auditing)? 13.1.1 13.1.2 / 13.2 13.2.1 13.2.2 Data Dictionary Views 14. SQL*Loader 14.1 SQL*Loader? 14.1.1 SQL*Loader? 14.1.2 SQL*Loader 14.2 SQL*Loader
14.2.1 SQL*Loader 14.2.1 SQL*Loader Sequence,Decode 15. PARTITION TABLE 15.1 PARTITION TABLE 15.1.1 Partition Table 15.1.2 16 Materialized View 16.1 Materialized View 16.1.1 Materialized View 16.1.2 Materialized View 16.1.3 Materialized View View 16.1.4 Materialized View Parameter 16.2 Materialized View 16.3 Query RewriteMView Refresh. 16.3.1 Query Rewrite() 16.3.2 MView Refresh 17. ORACLE 17.1 Oracle 17.1.1 17.1.2 User 17.2 17.3.1. (System Privileges) 17.3.2. (Object Privileges) 17.3.3. (Role) 17.3.4. Oracle Database Role 18. 18.1 18.1.1 18.1.2 18.1.3 18.1.4
. LGWR. 2.. (Log Sequence Number).
-