Evolving Technologies

• Create, configure and maintain Oracle 10g databases
• Optimize space and performance for effective storage management
• Maximize database efficiency using the Oracle Enterprise Manager
• Ensure database security by managing user privileges and roles
• Implement Oracle partitions to manage large tables and indexes
• Deploy appropriate backup, recovery and flashback procedures

Databases represent the core of an organization's informational infrastructure. To effectively maintain those databases, it is imperative for administrators to be well trained. In this hands-on course, you gain the knowledge and skills to create and configure Oracle 10g databases, manage memory and storage effectively, and deploy essential procedures to maintain your organization's database and ensure its availability.

Administrators and others involved in the management of Oracle 10g databases. Course  "Oracle Database 10g ," or equivalent experience is assumed. Exercises provide the practical skills to administer Oracle databases, including:

• Building, starting up and shutting down the database
• Creating and maintaining tablespaces
• Configuring UNDO tablespaces and retention periods
• Administering partitioned objects
• Safeguarding using backup and restore techniques
• Retrieving lost data from hardware and software failure
• Managing user resources and privileges
• Redefining, reorganizing and shrinking tables online
• Recovering from user error with flashback operations

Course Outline

pp 

Overview of Oracle 10g Administration

• Configuring Oracle 10g databases
• Controlling user access and operations
• Monitoring system usage
• Ensuring database availability

• Instances vs. databases
• Oracle processes and memory usage
• Determining database file structure
• Processing transactions with Oracle 10g

• Setting the initialization parameters
• Dynamic and static parameters
• Creating control files and log files
• Reducing administration with Oracle managed files

• Supporting applications that require multiple block sizes
• Creating UNDO and SYSAUX tablespaces

• Mounting and opening the database
• Text-based and server parameter files
• Connecting with SYSDBA privilege

• Improving sort performance
• Bigfile and locally managed tablespaces

• Managing space with PCTFREE/PCTUSED
• Moving and redefining tables online
• Shrinking tables online to regain space
• Resuming operations after failures
• Managing LOB storage with chunks

• Strengths and weaknesses of OEM
• Navigating the graphical interface

• Setting thresholds and generating alerts
• Verifying changes in the data dictionary

• Implementing password controls
• Allocating space quotas on tablespaces
• Limiting resource usage with profiles

• System and object privileges
• Setting up and working with roles
• Transparently encrypting data

• Partitioning types: range, hash and list
• Tailoring storage for individual partitions
• Splitting and merging partitions

• Deploying local, global, prefixed and non-prefixed indexes
• Rebuilding unusable indexes

• Role of the redo log and control file
• Ensuring recovery using archiving
• Protecting and tracing the control file

• Implementing hot and cold backups
• Partial online and offline backups
• Restoring tables with Data Pump

• Recovering corrupted tablespaces
• Tracking row history with flashback
• Restoring dropped tables from the recycle bin

• Sizing the buffer cache and shared pool
• Balancing disk I/O and memory allocation
• Index storage considerations