Oracle 10g Admin - 1
#Oracle DB Architecture:
- Instance and DB Architecture and its components
#Oracle DB Software:
- Common DB Admin Tools,
- OFA,
- Software/Binary Intallation,
- Configuration of Env Variables,
- Use of Installer log's.
# Oracle Database Creation
- Using DBCA
- Manual Method.
# Oracle Instance Management
- Using Ooracle Enterprise Manager
- Management of DB intialization Parameters
- Startup / Shutting of the Database with Different stages
- Usage of DB Alert Log File
- Dynamic Performance Views
Managing Database Storage Structures
- Tablespace, Datafiles, Segments, Extents, Blocks
- Space Management In Tablespace.
- Tablespace Management
- Automatic Storage Management
Administering User Security
- User Management
- Role Management
- System / Object Privileges
- Profile Management
Managing Schema Objects
- Table Management: Creation, Droping Truncations, Table Constraints
- Index Management
- User Views, Sequences and other relevant Objects
Managing Data and Concurrency
- Data manipulation via SQL
- PLSQL Objects and its Management
- Triggers and Triggering Events
- Locking: Lock Levels, Cause for Lock conflicts, Manage and resolve Lock conflicts
Managing Undo Data
-Monitor and administer undo
-Configure undo retention
-Describe the relationship between undo and transactions
-Size the undo tablespace
Implementing Oracle Database Security
- Apply the principle of least privilege
- Audit database activity
- Implement Fine-Grained Auditing
Configuring the Oracle Network Environment
-Use Database Control to Create additional listeners
-Use Database Control to Create Oracle Net service aliases
-Control Oracle Net Listeners
-Identify when to use shared servers versus dedicated servers
Proactive Maintenance
-Gather optimizer statistics
-Manage the Automatic Workload Repository
-Use the Automatic Database Diagnostic Monitor (ADDM)
-Set warning and critical alert thresholds
-React to performance issues
Performance Management
Use enterprise manager to view performance.
Tune SQL by using SQL tuning advisor.
Tune SQL by using SQL access advisor.
Use automatic shared memory management.
Use the memory advisor to size memory buffer.
Backup and Recovery Concepts
Describe the types of failure that may occur in an Oracle Database
Identify the importance of checkpoints, redo log files, and archived log files
Tuning instance recovery
Configure a database for recoverability
Configure ARCHIVELOG mode
Performing Database Backup
Create consistent database backups
Back up your database without shutting it down
Create incremental backups
Automate database backups
Backup a control file to trace
Monitor flash recovery area
Performing Database Recovery
Recover from loss of a Control file
Recover from loss of a Redo log file
Recover from loss of a system-critical data file
Recover from loss of a non system-critical data file
Performing Flashback
Describe flashback database
Resotore the table contents to a specific point in time
Recover from a dropped table
Use Flashback Query to view the contents of the database as of any single point of time
View transaction history or row with flashback transaction query
Moving Data
Describe the general architecture of Data Pump
Use Data Pump export and import to move data between Oracle databases
Load data with SQL Loader
Use external tables to move data
Oracle 10g Admin - 2
Using Globalization Support Objectives
- Customize language-dependent behavior for the database and individual sessions
- Specify different linguistic sorts for queries
- Use datatime datatypes
- Query data using case insensitive and accent insensitive searches
- Obtain Globalization support configuration information
Configuring Recovery Manager
- Configure database parameters that affect RMAN operations
- Change RMAN default settings with CONFIGURE
- Manage RMAN's persistent settings
- Start RMAN utility and allocate channels
Recovering from User Errors
- Recover a dropped table using Flashback technology
- Perform Flashback table operation
- Manage the recycle bin
- Recover from user errors using Flashback versions query
- Perform transaction level recovery using Flashback Transaction query
Dealing with Database Corruption
- Define block corruption and list its causes and symptoms
- Detect database corruptions using the following utilities: ANALYZE
DBVERIFY
- Detect database corruptions using the dbms_repair package
- Implement the DB_BLOCK_CHECKING parameter to detect corruptions
- Repair corruptions using RMAN
Automatic Database Management
- Use the Database Advisors to gather information about your database
- Use the SQL Tuning Advisor to improve database performance
- Use automatic undo retention tuning
Using Recovery Manager
- Use the RMAN BACKUP command to create backup sets and image copies
- Enable block change tracking
- Manage the backups and image copies taken with RMAN with the LIST and REPORT commands
Recovering from Non-Critical Losses
- Recover temporary tablespaces
- Recover a redo log group member
- Recover index tablespaces
- Recover read-only tablespaces
- Recreate the password file
Monitoring and Managing Storage
- Tune redo writing and archiving operations
- Issue statements that can be suspended upon encountering space condition errors
- Reduce space-related error conditions by proactively managing tablespace usage
- Reclaim wasted space from tables and indexes using the segment shrink functionality
- Estimate the size of new table and indexes
- Use different storage options to improve the performance of queries
- Rebuild indexes online
Automatic Storage Management
- Set up initialization parameter files for ASM and database instances
- Execute SQL commands with ASM file names
- Start up and shut down ASM instances
- Administer ASM disk groups
- Use RMAN to migrate your database to ASM
Monitoring and Managing Memory
- Implement Automatic Shared Memory Management
- Manually configure SGA parameters for various memory components in the SGA
- Use Automatic PGA Memory Management
