Index
A
- ACCEPT command / Examining a manual database creation
- account unlock / Creating users
- ACID / Examining the rules of a transaction
- Active Data Guard / Understanding Oracle Database options
- ADDM / MMON – the Manageability Monitor, Understanding the Automatic Database Diagnostic Monitor
- administration-related views
- V$CONTROLFILE / Administration-related views
- V$LOG / Administration-related views
- V$LOGFILE / Administration-related views
- V$PARAMETER / Administration-related views
- V$ARCHIVED_LOG / Administration-related views
- V$INSTANCE / Administration-related views
- V$DATABASE / Administration-related views
- ADR / Understanding the Automatic Diagnostic Repository
- about / Using the Data Recovery Advisor
- ADRCI / Understanding the Automatic Diagnostic Repository
- Advanced Compression / Understanding Oracle Database options
- Advanced Replication option / Examining the streams pool
- Advanced Security / Understanding Oracle Database options
- advanced tablespace management techniques
- non-standard block size tablespaces, using / Using non-standard block size tablespaces
- locally managed tablespaces / Understanding locally managed tablespaces
- advise failure command / Performing recovery using the DRA command-line interface
- Advisory Framework, Oracle
- about / Understanding Oracle's Advisory Framework
- ADDM / Understanding the Automatic Database Diagnostic Monitor
- ADDM report, generating / Generating an ADDM Report
- memory advisors, using / Using Memory Advisors
- Alert Framework / Understanding the Alert Framework
- Alert Framework / Understanding the Alert Framework
- alter database archivelog command / Converting to an ARCHIVELOG mode
- ALTER DATABASE DATAFILE command / Managing undo tablespaces
- alter database begin backup command / Creating user-managed hot backups
- alter system command / Examining the database buffer cache
- ALTER TABLESPACE command / Adding datafiles
- alter tablespace begin backup command / Creating user-managed hot backups
- AMM / MMAN – Memory Manager, Understanding the PGA, Using Automatic Memory Management
- ARCH / ARCn – the Archiver process
- noarchivelog mode / ARCn – the Archiver process
- archivelog mode / ARCn – the Archiver process
- archive logs / ARCn – the Archiver process
- archived log / Exploring ARCHIVELOG mode
- archive log list command / Understanding the archived redo logs, Converting to an ARCHIVELOG mode
- archivelog mode / ARCn – the Archiver process
- archive logs / ARCn – the Archiver process
- ARCn process / Exploring ARCHIVELOG mode
- ASM / Introducing the Database Configuration Assistant
- ASMM / MMAN – Memory Manager, Using Automatic Shared Memory Management
- ASSM / Understanding locally managed tablespaces
- Atomicity / Examining the rules of a transaction
- attributes / A new paradigm
- auditing
- about / Understanding auditing
- audit trail , exploring / Exploring the audit trail
- database actions / Auditing database actions
- audit trail
- exploring / Exploring the audit trail
- NONE or FALSE / Exploring the audit trail
- OS / Exploring the audit trail
- DB / Exploring the audit trail
- XML / Exploring the audit trail
- DB/XML_EXTENDED / Exploring the audit trail
- AUM / Understanding undo-related parameters
- authentication / Creating and managing user accounts
- Automatic Memory Management (AMM) / A recommended strategy for preparation
- Automatic Shared Memory Management (ASMM) / A recommended strategy for preparation
- automatic undo management / Understanding the Undo tablespace
- AWR / MMON – the Manageability Monitor, Understanding the SYSAUX tablespace
- about / Managing the Automatic Workload Repository
- managing / Understanding the AWR
- metrics, using / Using statistics, metrics, and baselines
- statistics, using / Using statistics, metrics, and baselines
- baselines, using / Using statistics, metrics, and baselines
- report, generating / Generating an AWR report
B
- backup as copy command / Backing up image copies
- backup as copy database command / Backing up image copies
- backup channel / Performing a tablespace-level RMAN backup
- backup mode / Creating user-managed hot backups
- backup piece / Understanding the RMAN architecture
- backup set / Understanding the RMAN architecture
- backup tablespace command / Performing a tablespace-level RMAN backup
- baseline / Using statistics, metrics, and baselines
- bigfile tablespaces / Understanding non-specialized datafiles
- block change tracking / Creating incremental backups
- blocksize parameter / Understanding file-level media failure
- buffer / CKPT – the Checkpoint process
- Buffer Pool Advisor / Using the Buffer Pool Advisor
C
- change vectors / Understanding the archived redo logs, Examining types of transactions
- Check Again button / Running the Oracle Universal Installer
- checkpoint / CKPT – the Checkpoint process
- CJQn / Recognizing other database processes
- CKPT
- dirty buffer / CKPT – the Checkpoint process
- checkpoint / CKPT – the Checkpoint process
- full checkpoint / CKPT – the Checkpoint process
- about / CKPT – the Checkpoint process
- client-server model / Exploring Oracle Net
- cold / Understanding the startup process
- columns / A new paradigm
- common data dictionary views
- object-related views / Object-related views
- administration-related views / Administration-related views
- security-related views / Security-related views
- storage-related views / Storage-related views
- Companylinkdatabase
- about / Introducing the Companylink database
- supported site / Introducing the Companylink database
- compressed backups
- performing / Performing compressed backups
- Connection Mode tab / Introducing the Database Configuration Assistant
- Consistency / Examining the rules of a transaction
- Console / Examining Windows Services in Oracle
- control file / Understanding the control file, Constructing a control file
- conventional path / Understanding SQL*Loader's load paths
- core infrastructure datafiles, Oracle
- examining / Examining Oracle's core infrastructure datafiles
- SYSTEM tablespace / Understanding the SYSTEM tablespace
- SYSAUX tablespace / Understanding the SYSAUX tablespace
- temporary tablespace, exploring / Exploring the temporary tablespace
- Undo tablespace / Understanding the Undo tablespace
- non-specialized datafiles / Understanding non-specialized datafiles
- cost-based optimizer / Understanding the Oracle optimizer
- CPU / Patching Oracle
- CREATE DATABASE command / Examining a manual database creation, Managing undo tablespaces
- Create Database option / Introducing the Database Configuration Assistant
- CREATE PROFILE command / Using profiles to manage passwords
- CREATE ROLE command / Managing user roles
- CREATE TABLESPACE command / Using non-standard block size tablespaces
- CREATE UNDO TABLESPACE command / Managing undo tablespaces
- CREATE USER command / Creating users
- critical threshold / Understanding the Alert Framework
- CRM / Examining Oracle Application Servers
- crontab command / Automating Backups with scripting
- crosscheck backup of database command / Checking files using CROSSCHECK
- CROSSCHECK command / Checking files using CROSSCHECK
- crowsfootsymbol / A new paradigm
- CSI / Using My Oracle Support
- CSV / Flat file databases, Creating external tables
- cumulative incremental backup / Creating incremental backups
- current log group / Exploring the redo logfiles, Understanding the redo-based architecture
- current log sequence / Understanding the redo-based architecture
D
- data
- migrating, Oracle Data Pump used / Migrating data with Oracle Data Pump
- exporting, Oracle Data Pump used / Exporting data Using Data Pump
- importing, Oracle Data Pump used / Importing data using Data Pump
- database / Distinguishing between an instance and a database
- database alert log / Understanding the alert log
- Database Appliance / Understanding Oracle's hardware solutions
- database backups
- automating / Automating database backups
- automating, Scripting used / Automating Backups with scripting
- automating, Enterprise Manager used / Automating backups using Enterprise Manager
- database block / DBWn – the Database Writer process, Understanding the database block
- about / Understanding the database block
- sizing / Sizing the database block
- anatomy, examining / Examining the anatomy of a database block
- database block size / Sizing the database block
- database buffer cache / Examining the database buffer cache, Understanding the database block
- Database Content screen / Introducing the Database Configuration Assistant
- database diagnostic information
- about / Understanding database diagnostic information
- alert log / Understanding the alert log
- trace files / Understanding the trace files
- Automatic Diagnostic Repository / Understanding the Automatic Diagnostic Repository
- database failure, categories
- about / Understanding the categories of database failure
- statement failures, addressing / Addressing statement failures
- user errors, addressing / Addressing user errors
- user process errors, addressing / Addressing user process errors
- media failure, addressing / Addressing media failure
- RAID / Understanding RAID
- file-level media failure / Understanding file-level media failure
- database initialization parameters
- database links
- about / Using database links
- creating / Using database links
- using / Using database links, Certification objectives covered
- orcl_db_link / Using database links
- database processes
- Dnnn / Recognizing other database processes
- DBRM / Recognizing other database processes
- DIAG / Recognizing other database processes
- FBAR / Recognizing other database processes
- CJQn / Recognizing other database processes
- SMCn / Recognizing other database processes
- VKTM / Recognizing other database processes
- database recovery
- about / Understanding the recovery process
- importance / Understanding the importance of database recovery
- recovery types / Understanding the different types of recovery
- database recovery process, types
- complete recovery / Understanding the different types of recovery
- incomplete recovery / Understanding the different types of recovery
- database registration
- about / Understanding database registration
- static registration / Using static registration
- dynamic registration / Using dynamic registration
- database shutdown
- database startup
- Database Storage screen / Introducing the Database Configuration Assistant
- database user / Exploring the principles behind security
- Database Vault / Understanding Oracle Database options
- data dictionary / Examining a manual database creation
- about / Understanding the data dictionary
- Oracle base tables, exploring / Exploring the Oracle base tables
- Static data dictionary, exploring / data dictionaryStatic data dictionary, exploringExploring the static data dictionary views
- dynamic data dictionary views, exploring / Exploring the dynamic data dictionary views
- views, querying / Querying the data dictionary views
- common data dictionary views, listing / Listing common data dictionary views
- data dictionary views
- querying / Querying the data dictionary views
- datafile / Understanding the database datafile
- DATAFILE keyword / Examining a manual database creation
- data migration, Oracle Data Pump used
- Data Recovery Advisor page / Performing recovery using the DRA with Enterprise Manager
- Data Warehouses / Sizing the database block
- DBA
- importance / Understanding the role of the DBA
- physical DBA / Understanding the role of the DBA
- logical DBA / Understanding the role of the DBA
- features / Understanding the role of the DBA
- traits / Understanding the role of the DBA
- DBArtisan / DBArtisan
- DBCA
- used, for Oracle database creation / Creating an Oracle database using DBCA
- about / Introducing the Database Configuration Assistant
- DBRM / Recognizing other database processes
- dbv command / Understanding file-level media failure
- DBVERIFY tool / Understanding file-level media failure
- DBWR / DBWn – the Database Writer process
- db_recovery_file_dest parameter / Using Oracle Managed Files, Configuring the Flash Recovery Area
- db_recovery_file_dest_size parameter / Configuring the Flash Recovery Area
- deadlock
- about / Recognizing deadlocks
- recognizing / Recognizing deadlocks
- Decision Support Systems / Sizing the database block
- dedicated server architecture / Understanding the dedicated and shared server architectures
- default role / Enabling roles
- default tablespace / Creating users
- Deferred Segment Creation / Understanding the database segment
- Deinstall Products button / Understanding the de-installation process – advanced topic
- DELETE OBSOLETE command / Using the REPORT command in RMAN
- DELETE statement / Examining types of transactions
- DIAG / Recognizing other database processes
- dictionary managed tablespaces / Understanding locally managed tablespaces
- differential incremental backup / Creating incremental backups
- directory naming / Using directory naming and external naming
- directory object / Creating directory objects
- direct path / Understanding SQL*Loader's load paths
- dirty buffer / CKPT – the Checkpoint process
- dispatcher / Understanding the dedicated and shared server architectures
- distributed transactions / RECO – the Recoverer process
- DML / Examining the rules of a transaction
- Dnnn / Recognizing other database processes
- DRA / Introducing the Data Recovery Advisor
- about / Using the Data Recovery Advisor
- requirements / Using the Data Recovery Advisor
- recovery performing, DRA command-line interface used / Performing recovery using the DRA command-line interface
- recovery performing, DRA with Enterprise Manager used / Performing recovery using the DRA with Enterprise Manager
- DRA command-line interface
- used, for recovery process / Performing recovery using the DRA command-line interface
- DROP TABLESPACE command / Managing undo tablespaces
- Durability / Examining the rules of a transaction
- dynamic data dictionary views
- exploring / Exploring the dynamic data dictionary views
- dynamic registration / Using dynamic registration
E
- Easy Connect / Understanding Easy Connect
- EBU / Introducing RMAN
- Email entity / A new paradigm
- Enterprise Edition (EE) / Understanding the different editions of Oracle Database
- entity / A new paradigm
- environment variable
- using, in OUI / Using environment variables in Oracle
- ERD / A new paradigm
- ETL / Creating external tables
- Exadata Database Machine / Understanding Oracle's hardware solutions
- Exalogic / Understanding Oracle's hardware solutions
- Exalytics / Understanding Oracle's hardware solutions
- exclusive lock / Understanding Oracle's locking scheme
- execute stage / Understanding the Oracle optimizer
- execution plans / Understanding the Oracle optimizer
- extent / Understanding the database extent
- external data access
- about / Understanding external data access
- directory objects, creating / Creating directory objects
- external tables, creating / Creating external tables
- external naming / Using directory naming and external naming
- external table
- creating / Creating external tables
F
- fast_start_mttr_target parameter / Understanding instance recovery
- FBAR / Recognizing other database processes
- fetch stage / Understanding the Oracle optimizer
- file-level media failure / Understanding file-level media failure
- findings / Generating an ADDM Report
- fine-grained auditing / Auditing database actions
- flashback query / Understanding undo-related parameters
- flashback technologies / Understanding undo-related parameters
- flashback technologies, version 11g
- flashback query / Addressing user errors
- flashback version query / Addressing user errors
- flashback transaction query / Addressing user errors
- flashback drop / Addressing user errors
- flashback table / Addressing user errors
- flashback database / Addressing user errors
- flat file databases
- about / Flat file databases
- limitations / Limitations of the flat file paradigm
- relational paradigm / A new paradigm
- FRA
- about / Understanding Flash Recovery Area
- configuring / Configuring the Flash Recovery Area
- free -k command / Understanding the memory requirements of a database
- freelist / Understanding locally managed tablespaces
- full backup
- performing / Performing a full backup
- full checkpoint / CKPT – the Checkpoint process
- fundamental security
- fundamentals / Understanding the fundamentals of database security
- principles / Exploring the principles behind security
G
- granteE / Granting system privileges
- granules / Using Manual Memory Management
H
- hardware prerequisites, Oracle installation
- reviewing / Reviewing hardware prerequisites for an installation, Meeting the minimum hardware requirements for an installation
- Processor / Meeting the minimum hardware requirements for an installation
- physical memory / Meeting the minimum hardware requirements for an installation
- virtual memory / Meeting the minimum hardware requirements for an installation
- installation disk space / Meeting the minimum hardware requirements for an installation
- hostname / Understanding the listener
- hot backups / Creating user-managed hot backups
- HTTP / Understanding the listener
- HWM / Resizing datafiles
- hybrid databases / Sizing the database block
I
- Ignore All checkbox / Running the Oracle Universal Installer
- iIncremental backups
- about / Creating incremental backups
- image copy / Understanding the RMAN architecture
- incomplete recovery / Understanding incomplete recovery
- incremental backups
- creating / Creating incremental backups
- initial extent / Understanding the database extent
- Initialization Parameters screen / Introducing the Database Configuration Assistant
- INSERT statement / Examining types of transactions
- instance / Distinguishing between an instance and a database
- instance recovery
- about / Understanding instance recovery
- invalid object
- about / Discovering invalid objects
- invalid objects
- discovering / Discovering invalid objects
- IPC / Understanding the listener
- IPS / Understanding the Automatic Diagnostic Repository
- ips generate package command / Understanding the Automatic Diagnostic Repository
- iSCSI
- Isolation / Examining the rules of a transaction
J
- Java pool / Understanding the Java pool
K
- KERNEL profile limits
- SESSIONS_PER_USER / Using profiles to manage system resources
- CPU_PER_SESSION / Using profiles to manage system resources
- CPU_PER_CALL / Using profiles to manage system resources
- LOGICAL_READS_PER_SESSION / Using profiles to manage system resources
- LOGICAL_READS_PER_CALL / Using profiles to manage system resources
- CONNECT_TIME / Using profiles to manage system resources
- PRIVATE_SGA / Using profiles to manage system resources
- COMPOSITE_LIMIT / Using profiles to manage system resources
- key command files, SQL*Loader
- about / Understanding SQL*Loader's load paths
- input data file / Understanding the input data file
- parameter (PAR) file, constructing / Constructing a parameter file
- control file, constructing / Constructing a control file
- key security parameters
- about / Understanding key security parameters
- REMOTE_OS_AUTHENT / Understanding key security parameters
- O7_DICTIONARY_ACCESSIBILITY / Understanding key security parameters
- REMOTE_LOGIN_PASSWORDFILE / Understanding key security parameters
- AUDIT_SYS_OPERATIONS / Understanding key security parameters
- SEC_CASE_SENSITIVE_LOGON / Understanding key security parameters
- SEC_MAX_FAILED_LOGIN_ATTEMPTS / Understanding key security parameters
- SEC_PROTOCOL_ERROR_FURTHER_ACTION / Understanding key security parameters
- SEC_PROTOCOL_ERROR_TRACE_ACTION / Understanding key security parameters
- SEC_RETURN_SERVER_RELEASE_BANNER / Understanding key security parameters
- keyword options / Exporting data Using Data Pump
L
- large pool / Understanding the large pool
- latch / Understanding latches and mutexes
- LDAP / Creating users, Using directory naming and external naming
- least privilege / Exploring the principles behind security
- LGWR
- about / LGWR – the Log Writer process
- Redo logs / LGWR – the Log Writer process
- log buffer / LGWR – the Log Writer process
- library cache / Examining the shared pool
- limit / Understanding password limits
- list backup of database command / Using the LIST command in RMAN
- Listener / Examining Windows Services in Oracle
- listener
- about / Understanding the listener
- controlling / Controlling the listener
- networking configuration files / Understanding the networking configuration files
- local authentication / Creating users
- local connection / Understanding the listener
- locally managed tablespaces / Understanding the database extent, Understanding locally managed tablespaces
- local naming / Understanding local naming
- lock contention / Examining locking in action
- log buffer / LGWR – the Log Writer process, Utilizing the log buffer
- logical backup / Importing data using Data Pump
- logical DBA
- logical DBA;about / Understanding the role of the DBA
- Log Miner / Understanding incomplete recovery
- log_archive_dest_1 parameter / Configuring the Flash Recovery Area
- LRU / Examining the database buffer cache
- lsnrctl utility / Controlling the listener
M
- manual database creation
- examining / Examining a manual database creation
- media failure / Addressing media failure
- addressing / Addressing media failure
- media pack / Acquiring the Oracle software
- memory advisors
- using / Using Memory Advisors
- Buffer Pool Advisor / Using the Buffer Pool Advisor
- Shared Pool Advisory / Using the Shared Pool Advisory
- PGA Advisor, using / Using the PGA Advisor
- memory caches, Oracle
- SGA / Understanding the SGA
- metric / Using statistics, metrics, and baselines
- mkdir command / Examining a manual database creation
- MMAN / MMAN – Memory Manager
- MML / Understanding the RMAN architecture
- MMNL / MMON – the Manageability Monitor
- MMON / MMON – the Manageability Monitor
- mount points / Establishing Oracle directory structures
- MTTR / Understanding instance recovery
- multiplexing / Understanding the control file
- multiplexing redo logs / Understanding the redo-based architecture
- multiversioning / Examining the rules of a transaction
- mutex / Understanding latches and mutexes
- My Oracle Support
- using / Using My Oracle Support
N
- n-tier system / Exploring Oracle Net
- name resolution / Using Oracle name resolution
- NAS
- about / Meeting the minimum hardware requirements for an installation, Exploring Oracle Real Application Clusters
- NETCA / Running the Network Configuration Assistant
- network port / Understanding the listener
- NETWORK_LINK feature / Using Data Pump with NETWORK_LINK
- next extent / Understanding the database extent
- NIS+ / Using directory naming and external naming
- NOARCHIVELOG mode / Exploring ARCHIVELOG mode
- noarchivelog mode / ARCn – the Archiver process
- non-standard block size tablespaces / Using non-standard block size tablespaces
O
- object-level tuning
- about / Understanding object-level tuning
- Oracle optimizer / Understanding the Oracle optimizer
- Oracle optimizer, gathering / Gathering object statistics
- invalid objects, discovering / Discovering invalid objects
- object-related views
- DBA_TABLES / Object-related views
- DBA_OBJECTS / Object-related views
- DBA_INDEXES / Object-related views
- DBA_VIEWS / Object-related views
- DBA_PART_TABLES / Object-related views
- DBA_TAB_COLUMNS / Object-related views
- DBA_IND_COLUMNS / Object-related views
- DBA_CONSTRAINTS / Object-related views
- DBA_SYNONYMS / Object-related views
- object owner / Exploring the principles behind security
- object privileges
- granting / Granting object privileges
- OEM
- about / Oracle Enterprise Manager
- Database Control / Oracle Enterprise Manager
- Grid Control / Oracle Enterprise Manager
- features / Oracle Enterprise Manager
- OEM Agent / Introducing the Database Configuration Assistant
- OFA
- offline backup / Creating user-managed cold backups
- offline redo logs / Exploring ARCHIVELOG mode
- OLTP / Introducing the Database Configuration Assistant, Sizing the database block, Using Automatic Memory Management
- OMF / Introducing the Database Configuration Assistant
- using / Using Oracle Managed Files
- online backups / Creating user-managed hot backups
- opatch apply command / Patching Oracle
- OPatch tool / Patching Oracle
- operating system authentication / Establishing a connection with SYSDBA privileges
- operating system group / Creating Oracle user accounts and groups
- OPS
- optimizer statistics
- about / Gathering object statistics
- gathering manually / Gathering statistics manually
- gathering automatically / Gathering statistics automatically
- Oracle
- about / Introducing the Oracle product family
- history / Exploring the history of Oracle
- Windows Services, examining / Examining Windows Services in Oracle
- memory caches, identifying / Identifying Oracle's memory caches
- name resolution / Using Oracle name resolution
- Advisory Framework / Understanding Oracle's Advisory Framework
- Oracle architecture / Distinguishing between an instance and a database
- Oracle base tables
- exploring / Exploring the Oracle base tables
- Oracle Certified Association (OCA)
- about / About the exam
- Oracle database
- creation plan / Planning for a database creation
- memory requirements / Understanding the memory requirements of a database
- disk requirements / Understanding the disk requirements of a database
- NETCA, running / Running the Network Configuration Assistant
- creating, DBCA used / Creating an Oracle database using DBCA
- Oracle Database
- about / Understanding the Oracle Database product
- Enterprise Edition (EE) / Understanding the different editions of Oracle Database
- Standard Edition (SE) / Understanding the different editions of Oracle Database
- OneTopicnStandard Edition One (SE1) / Understanding the different editions of Oracle Database
- Oracle databaseExpress Edition (XE) / Understanding the different editions of Oracle Database
- Personal Edition (PE) / Understanding the different editions of Oracle Database
- options / Understanding Oracle Database options
- Oracle database, components
- examining / Examining the Oracle database components
- control file / Understanding the control file
- redo logfiles / Exploring the redo logfiles
- archived redo logs / Understanding the archived redo logs
- core infrastructure datafiles / Examining Oracle's core infrastructure datafiles
- Oracle Database, options
- Advanced Security / Understanding Oracle Database options
- Active Data Guard / Understanding Oracle Database options
- Advanced Compression / Understanding Oracle Database options
- Total Recall / Understanding Oracle Database options
- Partitioning / Understanding Oracle Database options
- Database Vault / Understanding Oracle Database options
- Real Application Clusters / Understanding Oracle Database options
- Oracle database creation plan
- about / Planning for a database creation
- Oracle databaseExpress Edition (XE) / Understanding the different editions of Oracle Database
- Oracle Database Server / Understanding the Oracle Database product
- Oracle Database software
- about / Installing the Oracle Database software
- OUI, running / Running the Oracle Universal Installer
- installation, examining / Examining the installation
- de-installation process / Understanding the de-installation process – advanced topic
- Oracle Database versioning
- interpreting / Interpreting Oracle Database versioning
- Oracle Data Pump
- using, for data migration / Migrating data with Oracle Data Pump
- architecture / Understanding the architecture of Data Pump
- using, for data export / Exporting data Using Data Pump
- using, for data import / Importing data using Data Pump
- using, with NETWORK_LINK / Using Data Pump with NETWORK_LINK
- Oracle DBA
- tools / Examining the tools of the Oracle DBA
- TOAD / TOAD
- DBArtisan / DBArtisan
- Oracle SQL Developer / Oracle SQL Developer
- OracleDBConsoleorcl / Examining Windows Services in Oracle
- Oracle Fusion Middleware / Understanding how OUI works
- Oracle installation
- steps / Planning an Oracle installation
- concepts / Understanding Oracle installation concepts
- software package, acquiring / Acquiring the Oracle software
- hardware prerequisites, reviewing / Reviewing hardware prerequisites for an installation
- software prerequisities, reviewing / Reviewing software prerequisites for an installation
- Oracle instance
- examining / Examining the Oracle instance
- primary Oracle processes, recognizing / Recognizing the primary Oracle processes
- Oracle Linux / Exploring Oracle operating systems
- Oracle Memory Management
- about / Understanding Oracle Memory Management
- manual method, using / Using Manual Memory Management
- ASMM, using / Using Automatic Shared Memory Management
- AMM, using / Using Automatic Memory Management
- Oracle name resolution
- about / Using Oracle name resolution
- Easy Connect / Understanding Easy Connect
- local naming / Understanding local naming
- directory naming / Using directory naming and external naming
- external naming / Using directory naming and external naming
- Oracle Net / Exploring Oracle Net
- Oracle networking concepts
- about / Understanding Oracle networking concepts
- Oracle Net / Exploring Oracle Net
- dedicated server architecture / Understanding the dedicated and shared server architectures
- shared server architecture / Understanding the dedicated and shared server architectures
- Oracle optimizer / Understanding the Oracle optimizer
- Oracle processes
- background processes / Recognizing the primary Oracle processes
- PMON process / PMON – the Process Monitor
- SMON / SMON – the System Monitor
- DBWR / DBWn – the Database Writer process
- Database Writer / DBWn – the Database Writer process
- CKPT / CKPT – the Checkpoint process
- Checkpoint process / CKPT – the Checkpoint process
- LGWR / LGWR – the Log Writer process
- ARCH / ARCn – the Archiver process
- secondary Oracle processes / Recognizing the secondary Oracle processes
- Oracle products
- about / Examining the Oracle product family
- hardware solutions / Understanding Oracle's hardware solutions
- virtualization solutions, examining / Examining Oracle virtualization solutions
- operating systems, exploring / Exploring Oracle operating systems
- Application Servers, examining / Examining Oracle Application Servers
- Oracle Recovery Manager
- about / Understanding Oracle Recovery Manager
- features / Introducing RMAN
- RMAN architecture / Understanding the RMAN architecture
- Oracle Secure Backup / Introducing RMAN
- OracleServiceORCL / Examining Windows Services in Oracle
- Oracle Solaris / Exploring Oracle operating systems
- Oracle SQL Developer / Oracle SQL Developer
- Oracle Streams / Examining the streams pool
- Oracle Support Model
- about / Understanding the Oracle Support model
- My Oracle Support, using / Using My Oracle Support
- Oracle, patching / Patching Oracle
- certification objectives / Certification objectives covered
- Oracle Technology Network / Acquiring the Oracle software
- Oracle VM / Examining Oracle virtualization solutions
- ORACLE_BASE / Understanding the Optimal Flexible Architecture
- oradim command / Controlling startup and shutdown on Windows platforms
- OUI
- about / Using the Oracle Universal Installer
- working / Understanding how OUI works
- final installation preparation, completing / Completing final preparations to install the Oracle software
- groups, creating / Creating Oracle user accounts and groups
- Oracle user accounts, creating / Creating Oracle user accounts and groups
- Oracle directory structures, establishing / Establishing Oracle directory structures
- OFA / Understanding the Optimal Flexible Architecture
- environment variables, using / Using environment variables in Oracle
- OUI Inventory / Understanding how OUI works
P
- parameter file / Understanding the PFILE and SPFILE, Exporting data Using Data Pump
- parity / RAID 5
- parse stage / Understanding the Oracle optimizer
- parsing / Examining the shared pool
- Partitioning / Understanding Oracle Database options
- password-related profile limits
- FAILED_LOGIN_ATTEMPTS / Understanding password limits
- PASSWORD_LOCK_TIME / Understanding password limits
- PASSWORD_LIFE_TIME / Understanding password limits
- PASSWORD_GRACE_TIME / Understanding password limits
- PASSWORD_VERIFY_FUNCTION / Understanding password limits
- PASSWORD_REUSE_MAX / Understanding password limits
- PASSWORD_REUSE_TIME / Understanding password limits
- password expire / Creating users
- Pearson VUE exam site
- about / About the exam
- Personal Edition (PE) / Understanding the different editions of Oracle Database
- PFILE
- about / Understanding the PFILE and SPFILE
- working with / Working with the PFILE and SPFILE
- PGA
- database buffer cache, examining / Examining the database buffer cache
- shared pool, examining / Examining the shared pool
- log buffer, utilizing / Utilizing the log buffer
- large pool / Understanding the large pool
- streams pool, examining / Examining the streams pool
- Java pool / Understanding the Java pool
- about / Understanding the PGA
- PGA Advisor / Using the PGA Advisor
- pga_aggregate_target parameter / Using the PGA Advisor
- physical DBA
- physical space paradigm, Oracle
- examining / Examining Oracle's physical space paradigm
- database block / Understanding the database block
- database block, sizing / Sizing the database block
- database extent / Understanding the database extent
- database segment / Understanding the database segment
- database datafile / Understanding the database datafile
- PMON process / PMON – the Process Monitor
- port / Understanding the listener
- primary Oracle processes
- recognizing / Recognizing the primary Oracle processes
- PMON / PMON – the Process Monitor
- SMON / SMON – the System Monitor
- DBWR / DBWn – the Database Writer process
- CKPT / CKPT – the Checkpoint process
- LGWR / LGWR – the Log Writer process
- ARCH / ARCn – the Archiver process
- private SQL area / Examining the shared pool
- privileges
- about / Understanding privileges
- system privileges, granting / Granting system privileges
- object privileges / Granting object privileges
- removing, REVOKE used / Removing privileges with REVOKE
- Process Monitor (PMON) / Addressing user process errors
- profile / Creating users
- profiles
- about / Understanding profiles
- password limits / Understanding password limits
- using, for password management / Using profiles to manage passwords
- using, for system resource management / Using profiles to manage system resources
- protocol / Understanding the listener
- ps -ef command / PMON – the Process Monitor
- PSU / Patching Oracle
- PSUs / Running the Oracle Universal Installer
Q
- quota / Creating users
R
- RAC / Understanding Oracle Database options, Managing undo tablespaces
- RAID
- about / Understanding RAID
- 0(stripping) / RAID 0
- 1(mirroring) / RAID 1
- 10(stripping with mirroring) / RAID 10
- 5(stripping with parity) / RAID 5
- RAID 0 / RAID 0
- RAID 1 / RAID 1
- RAID 5 / RAID 5
- RAID 10 / RAID 10
- RDBMS
- about / Understanding the RDBMS, Understanding the Oracle RDBMS
- databases / The importance of databases
- flat file databases / Flat file databases
- instance / Distinguishing between an instance and a database
- database / Distinguishing between an instance and a database
- read consistency / Examining the rules of a transaction
- RECO / RECO – the Recoverer process
- record / Flat file databases
- recover / Performing RMAN complete recoveries
- recovery catalog / Understanding the RMAN architecture
- Red Hat Compatible Kernel / Exploring Oracle operating systems
- redo-based architecture
- about / Understanding the redo-based architecture
- redo log members, adding / Adding redo log members
- redo log group, adding / Adding a redo log group
- ARCHIVELOG mode, exploring / Exploring ARCHIVELOG mode
- redo log files / Understanding the redo-based architecture
- redo log groups / Understanding the redo-based architecture
- redo log member / Understanding the redo-based architecture
- Redo logs / Examining a manual database creation, LGWR – the Log Writer process
- relational paradigm / A new paradigm
- repair failure command / Performing recovery using the DRA command-line interface
- REPORT command / Using the REPORT command in RMAN
- REPORT NEED BACKUP command / Using the REPORT command in RMAN
- REPORT OBSOLETE command / Using the REPORT command in RMAN
- RESETLOGS command / Performing recovery using the DRA command-line interface
- Resource Manager feature / Recognizing other database processes
- restore / Performing RMAN complete recoveries
- REVOKE
- using, for privilege removing / Removing privileges with REVOKE
- RMAN
- about / Introducing RMAN
- architecture / Understanding the RMAN architecture
- LIST command, using / Using the LIST command in RMAN
- REPORT command, using / Using the REPORT command in RMAN
- RMAN complete recovery
- performing / Performing RMAN complete recoveries
- datafile-level RMAN complete recovery, performing / Performing datafile-level RMAN complete recovery
- complete recovery, performing / Performing complete recovery of the database
- RMAN hot backups
- performing / Performing RMAN hot backups
- full hot backups, performing / Performing full hot backups
- incremental backups, creating / Creating incremental backups
- maintenance activities, performing / Creating incremental backups
- RMAN parameters / Understanding RMAN Parameters
- LIST commands, using / Using the LIST command in RMAN
- REPORT command, using / Using the REPORT command in RMAN
- file checking,CROSSCHECK used / Checking files using CROSSCHECK
- FRA with Enterprise Manager, monitoring / Monitoring the Flash Recovery Are with Enterprise Manager
- RMAN incomplete recovery
- about / Performing incomplete recoveries
- sequence-based recovery / Understanding incomplete recovery
- time-based recovery / Understanding incomplete recovery
- change-based recovery / Understanding incomplete recovery
- time-based incomplete recovery, performing / Performing a time-based incomplete recovery
- RMAN offline backups
- performing / Performing RMAN offline backups
- tablespace-level RMAN backup, performing / Performing a tablespace-level RMAN backup
- full backup, performing / Performing a full backup
- compressed backup, performing / Performing compressed backups
- image copies, backing up / Backing up image copies
- RMAN parameters / Understanding RMAN Parameters
- RMAN recovery
- complete recovery, performing / Performing complete recovery of the database
- RMAN repository / Understanding the RMAN architecture
- RMAN script / Performing full hot backups
- role-based security
- about / Understanding role-based security
- system roles, using / Using system roles
- user roles, managing / Managing user roles
- roles
- about / Using system roles
- enabling / Enabling roles
- default role / Enabling roles
- Secure Application Roles, using / Enabling roles
- rollback data / Managing undo data
- rollback segments / Managing undo data
- rule-based optimizer / Understanding the Oracle optimizer
- run script / Performing full hot backups
S
- SAN
- about / Meeting the minimum hardware requirements for an installation, Exploring Oracle Real Application Clusters
- Schedule Customized Backup / Automating backups using Enterprise Manager
- SCN / Understanding the control file
- secondary Oracle processes
- recognizing / Recognizing the secondary Oracle processes
- MMON / MMON – the Manageability Monitor
- MMAN / MMAN – Memory Manager
- RECO / RECO – the Recoverer process
- security-related views
- BA_USERS / Security-related views
- DBA_TAB_PRIVS / Security-related views
- DBA_SYS_PRIVS / Security-related views
- security policy / Exploring the principles behind security
- segment / Understanding the database segment
- Select a Title for the Program window / Examining Windows Services in Oracle
- SELECT statement / Examining types of transactions
- serialization mechanisms
- managing / Managing serialization mechanisms
- Oracles locking scheme / Understanding Oracle's locking scheme
- locking action / Examining locking in action
- deadlock, recognizing / Recognizing deadlocks
- mutexes / Understanding latches and mutexes
- latches / Understanding latches and mutexes
- server-generated alerts / Understanding the Alert Framework
- service name / Understanding the listener
- SGA
- about / Understanding the SGA
- shared pool / Examining the shared pool
- Shared Pool Advisory / Using the Shared Pool Advisory
- shared server architecture / Understanding the dedicated and shared server architectures
- share lock / Understanding Oracle's locking scheme
- shmmax / Understanding the Java pool
- shmmin / Understanding the Java pool
- shmmni / Understanding the Java pool
- shmseg / Understanding the Java pool
- show parameter command / Examining the database buffer cache
- shutdown command / Controlling the database shutdown process
- shutdown immediate command / Performing a tablespace-level RMAN backup
- shutdown process
- controlling, on Windows platforms / Controlling startup and shutdown on Windows platforms
- shutdown transactional command / Controlling the database shutdown process
- SID / Understanding the listener
- SMCn / Recognizing other database processes
- SMON / SMON – the System Monitor
- snapshots / Using statistics, metrics, and baselines
- Snnn / Recognizing other database processes
- SPFILE
- about / Understanding the PFILE and SPFILE
- working with / Working with the PFILE and SPFILE
- spool command / Examining a manual database creation
- SPOOL OFF command / Examining a manual database creation
- SQL
- SQL*Loader
- about / Loading data with SQL*Loader
- data, loading / Loading data with SQL*Loader
- key command files / Understanding the key command files used by SQL*Loader
- conventional path / Understanding SQL*Loader's load paths
- direct path / Understanding SQL*Loader's load paths
- input data file / Understanding the input data file
- SQL*Loader job
- running / Running a SQL*Loader job
- SQL*Plus / SQL*Plus
- sqlldr command / Running a SQL*Loader job
- sqlldr parfile=external.par command / Running a SQL*Loader job
- SR / Using My Oracle Support
- Standard Edition (SE) / Understanding the different editions of Oracle Database
- Standard Edition One (SE1) / Understanding the different editions of Oracle Database
- startup mount command / Performing a tablespace-level RMAN backup
- startup process
- controlling, on Windows platforms / Controlling startup and shutdown on Windows platforms
- statement failures
- addressing / Addressing statement failures
- static data dictionary views
- static registration / Using static registration
- statistic / Using statistics, metrics, and baselines
- Statspack / Understanding the AWR
- status keyword / Controlling the listener
- storage-related views
- DBA_TABLESPACES / Storage-related views
- DBA_FREE_SPACE / Storage-related views
- DBA_DATA_FILES / Storage-related views
- V$TABLESPACE / Storage-related views
- V$DATAFILE / Storage-related views
- DBA_TEMP_FILES / Storage-related views
- V$TEMPFILE / Storage-related views
- streams pool / Examining the streams pool
- Submit Recovery Job button / Performing recovery using the DRA with Enterprise Manager
- switch logfile command / Adding redo log members
- SYSAUX tablespace / Understanding the SYSAUX tablespace
- SYSDBA privileges
- connection, establishing with / Establishing a connection with SYSDBA privileges
- SYSOPER / Establishing a connection with SYSDBA privileges
- System Change Number (SCN) / Understanding incomplete recovery
- systeminfo command / Understanding the memory requirements of a database
- system privileges
- granting / Granting system privileges
- system roles
- about / Using system roles
- CONNECT / Using system roles
- RESOURCE / Using system roles
- DBA / Using system roles
- SELECT_CATALOG_ROLE / Using system roles
- system tablespace / Examining a manual database creation
- SYSTEM tablespace / Understanding the SYSTEM tablespace
T
- tables keyword / Importing data using Data Pump
- tablespace / Examining Oracle's core infrastructure datafiles
- tablespace-level RMAN backup
- performing / Performing a tablespace-level RMAN backup
- tablespaces
- modifying / Modifying tablespaces
- datafiles, resizing / Resizing datafiles
- datafiles, adding / Adding datafiles
- datafiles, automatic extension / Automatically extending datafiles
- availability, managing / Managing tablespace availability
- dropping / Dropping a tablespace
- tablespaces management
- SQL Developer, starting / Starting SQL Developer
- tablespaces, creating / Creating tablespaces
- TCL / Examining the rules of a transaction
- temporary segments / Understanding the database segment
- temporary table / Exploring the temporary tablespace
- temporary tablespace / Exploring the temporary tablespace, Creating users
- threshold / Understanding the Alert Framework
- time-based incomplete recovery
- performing / Performing a time-based incomplete recovery
- TM / Examining locking in action
- TM locks / Understanding Oracle's locking scheme
- TOAD
- about / TOAD
- tools, Oracle DBA
- SQL*Plus / SQL*Plus
- OEM / Oracle Enterprise Manager
- Total Recall / Understanding Oracle Database options
- trace file / Understanding the trace files
- transaction
- about / Understanding the lifecycle of a transaction
- rules, examining / Examining the rules of a transaction
- types, examining / Examining types of transactions
- Transaction control / Understanding the lifecycle of a transaction
- TX / Examining locking in action
- TX locks / Understanding Oracle's locking scheme
U
- UGA / Understanding the dedicated and shared server architectures
- Unbreakable Enterprise Kernel / Exploring Oracle operating systems
- undo data / Examining types of transactions
- managing / Managing undo data
- related parameters / Understanding undo-related parameters
- tablespaces, managing / Managing undo tablespaces
- undo segments / Understanding the database segment, Understanding undo-related parameters
- Undo tablespace / Understanding the Undo tablespace
- undo tablespace / Understanding undo-related parameters
- undo_retention parameter / Understanding undo-related parameters
- undo_tablespace parameter / Managing undo tablespaces
- unusable index / Discovering invalid objects
- user-managed backups
- about / Creating user-managed backups
- cold backups, creating / Creating user-managed cold backups
- hot backups, creating / Creating user-managed hot backups
- user accounts
- about / Creating and managing user accounts
- user creating, CREATE USER command used / Creating users
- user errors
- addressing / Addressing user errors
- user process errors
- addressing / Addressing user process errors
- user roles
- managing / Managing user roles
V
- v$logfile view / Adding redo log members
- V$ views / Exploring the dynamic data dictionary views
- verify function / Understanding password limits
- VirtualBox / Examining Oracle virtualization solutions
- VKTM / Recognizing other database processes
W
- wait state / Understanding the dedicated and shared server architectures
- warning threshold / Understanding the Alert Framework
- whole consistent backup / Creating user-managed cold backups
- window / Gathering statistics automatically
- Windows platforms
- shutdown process, controlling / Controlling startup and shutdown on Windows platforms
- startup process, controlling / Controlling startup and shutdown on Windows platforms
- Windows Services
- about / Examining a manual database creation
- examining, in Oracle / Examining Windows Services in Oracle
- Wnnn / Recognizing other database processes
Z
- 1Z0-052 exam
- about / About the exam
- hints / Helpful exam hints
- recommended strategy, for preparation / A recommended strategy for preparation