CONFIGURING THE SERVER FOR INSTALLATION IDENTIFY system requirements OPTIMAL flexible architecture (OFA) ORACLE_BASE ORACLE_HOME CONFIGURE linux installation CONFIGURE MS windows installation PREREQUISITE checs & fixup utility

ENTERPRISE EDITION INSTALLATION MORE about the installation START the installation DESKTOP class installation 11g r2 SERVER class installation 11g r2 POST-installation configuration

VERIFY THE INSTALLATION ACCESSING the EM database control USING the EM interface USING sql*plus USING em sql worksheet USING ssh

UPGRADE, DEINSTALLATION & PATCHING DATABASE upgrade NETCA DBUA ONLINE patching ORACLE deinstaller

MANUALLY STARTING & STOPPING DATABASE SERVICES STARTING & stopping database control STARTING & stopping the listener STARTING & stopping the database SYSBDA

EXPLORING THE ORACLE DATABASE ARCHITECTURE: GENERAL THE oracle enterprise architecture GENERAL database architecture V$VERSION

EXPLORING THE ORACLE DATABASE ARCHITECTURE: INSTANCE MEMORY MORE about database instances USING V$SGA_dynamic_components ABOUT the pga MANAGING memory

CREATING AN ORACLE DATABASE CREATE a new database CONFIGURE an existing database DROP a database MANAGE DBCA templates MANUALLY create a database MORE about the database files

ENABLING TRANSPARENT DATA ENCRYPTION TRANSPARENT data encryption MANAGING TDE IMPLEMETNING column encryption

MANAGE DATABASE STORAGE STRUCTURES: TABLESPACES ABOUT tablespaces TABLESPACE management AUTOEXTEND options DROP tablespace ALTER tablespace

MANAGE DATABASE STORAGE STRUCTURES: ADVANCED TABLESPACES MORE about temporary tablespaces USING V$SORT_segment ABOUT temporary tablespace groups MORE about permanent tablespaces ABOUT database_properties MORE about bigfile tablespaces MORE about the sysaux tablespace

MANAGE DATABASE STORAGE STRUCTURES: DATA FILES & TEMP FILES MANAGING data files MANAGING temp files ENABLE oracle-managed files (OMF)

MANAGING UNDO DATA ABOUT undo space management CONFIGURE undo management UNDO_management UNDO_tablespace UNDO_retention GUARENTEE undo retention MONITOR undo space USE the undo advisor

NETWORK ENVIRONMENT: ORACLE NET SERVICES ORACLE net services architecture ORACLE net configuration assistant ORACLE net manager CONFIGURATION using EM TROUBLESHOOTING network problems COUNTERING database attacks NETWORK environment: oracle shared servers SHARED servers architecture CONFIGURE shared servers MONITOR shared servers V$SHARED_server V$SHARED_server_monitor V$SESSION V$CIRCUIT V$DISPATCHER & v$dispatcher_config V$QUEUE

SECURITY: IMPLEMENTING DATABASE SECURITY DATABASE system privileges DATABASE object privileges AUDITING of database activity AUDIT_trail parameter ENHANCED default security settings

SECURITY: ADMINISTERING USER SECURITY CREATE & managed database accounts GRANT & revoke database privileges RESOURCE limits via profiles ALTER profile DROP profile PASSWORD management via profiles ABOUT role-based security WITH admin option WITH admin option & system privileges WITH grant option & object privileges ALTER user…default role SET role ENHANCED default security settings SEC_case_sensitive_logon setting

MOVING DATA: SQL LOADER LOADER concepts CONTROL file options LOAD methods USING the EM interface

MOVING DATA: EXPORT & IMPORT MANAGE directory objects ABOUT the data pump architecture DATA pump import DATA pump data dictionary views USING the EM interface

DATA MAINTENANCE & PERFORMANCE MONITORING MANAGEMENT & advisory framework MANAGE awr ADDM USE metrics & alert thresholds AUTOMATIC maintenance tasks

MANAGING CONCURRENCY & LOCKS ABOUT latches & locks MANAGE & monitor latches V$LOCK V$LOCKED_OBJECT V$SESSION V$SESSION_WAIT DBA_BLOCKERS & dba_waiters DBA_DMI_LOCKS & dba_ddl_locks DML_LOCKS

BACKUP & RECOVERY CONCEPTS & CONFIGURATION ABOUT backup & recovery structures MANAGING redo data MANAGING archival data AUTOMATIC crash recovery CREATING a basic backup strategy