Recommended training

Take Recommended Training Courses Complete one of the courses below to prepare for your exam (optional): Oracle Database 12c: Administration Workshop Oracle Database 12c: Backup and Recovery Workshop Oracle Database 12c: Managing Multitenant Architecture Oracle Database 12c: ASM Administration Oracle Database 12c: RAC Administration Oracle Database 12c: Clusterware Administration Oracle Database 12c: Data Guard Administration …

Lab

Exam Environment Oracle Linux Release 6.5 64 bit Mozilla Browser, Text (emacs, gedit) and vi editors Shell environment: bash, csh Use either CLI or GUI environment and tools when available Oracle Database 12c Enterprise Edition Release 12.1.0.2.0  64 bit Oracle Grid Infrastructure 12c Release 1 (12.1.0.2) Oracle Enterprise Manager Cloud Control 12c Rel 4

Create a database using OMF (Oracle Managed Files)

— Create the destination folders, root and subfolders /u01/oradata/ folder1 | folder2 | flash_recovery_area | diag — Create the PFILE DB_NAME=orcl600 DB_UNIQUE_NAME=orcl600 DB_CREATE_FILE_DEST=’/u01/oradata/folder1′ DB_CREATE_ONLINE_LOG_DEST_2=’/u01/oradata/folder2′ MEMORY_TARGET=2048m PGA_AGGREGATE_TARGET=130m UNDO_TABLESPACE=undotbs01 CONTROL_FILES=’/u01/oradata/control01.ctl’,’/u01/oradata/control02.ctl’ DB_RECOVERY_FILE_DEST=’/u01/oradata/flash_recovery_area’ DB_RECOVERY_FILE_DEST_SIZE=10g DIAGNOSTIC_DEST=’/u01/oradata/diag’ — Export the SID export ORACLE_SID=orcl600 export ORACLE_BASE=/u01/app/oracle export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1 — Connect and startup the instance [oracle@rman bin]$ sqlplus / as sysdba SQL> startup …

Memory Management

Oracle memory structures consists of System Global Area (SGA) and Program Global Area (PGA). These memory areas can be managed automatically (you cannot set AMM if lock_sga is TRUE) or manually. Contents of PGA:- [pic] [credits] Private SQL Area: Contains data such as bind information and run-time memory structures. It contains Persistent Area which contains bind information and is …