Managing the Oracle Instance

Managing the Oracle Instance

Logging in As SYSDBA/SYSOPER(SYS AS SYSDBA/SYSTEM)
Shutdown/Startup the Instance by Enterprise Manager
Modifying Memory Setting:&Server--->Memory Advisors
 Auto Memory Management/Automaitc Shared Memory Management/Automatic PGA Memory Management

Managing Database Storeage Structures

 Redo Log Files

Data Files<------Segment<----Extent<------Data block

database--->Tablespaces    :a storage location for physical file

     Locally Managed Tablespaces

          Tablespace Types:   Permanent/Undo/Temporary

          Tablespace Status:  Read Write/Read Only/Offline     在维护和恢复表空间数据时Offline

          Autoextend Tablespace