In this course, you will gain hands-on experience with:

• Installing, creating, and administering an Oracle Database 10g Enterprise Edition database.
• Configuring the database for an application.
• Implementing a backup and recovery strategy.
• Employing basic monitoring procedures.

В программе курса:

• Installing Oracle Database 10g Software.

System Requirements. Optimal Flexible Architecture (OFA). Setting Environment Variables. Preinstallation Checks. Oracle Universal Installer. Inventory and UNIX Group Name. File Locations. Prerequisite Checks. Starter Database. Configuration and Management. File Storage and Backup Recovery. Passwords and Summary.

• Creating an Oracle Database.

Database Architecture. Control Files. Redo Log Files. Segments, Extents, and Blocks. Oracle Instance Management. Oracle Memory Structures. Oracle Processes. Database Control. Grid Control. Database Configuration Assistant (DBCA). Creating a Database. Creation Options. Other Actions with DBCA.

• Database Interfaces.

Enterprise Manager. SQL*Plus. iSQL*Plus. PL/SQL. Oracle and Java. Oracle Call Interface (OCI). Other APIs.

• Controlling the Database.

Starting and Stopping iSQL*Plus. Management Framework. Starting and Stopping Database Control. Accessing Database Control. Startup and Shutdown Database. Initialization Parameter Files. Alert Log.

• Storage Structures.

Tablespaces and Data Files. Space Management in Tablespaces. Creating a New Tablespace. Tablespaces in the Preconfigured Database. Altering a Tablespace. Actions with Tablespaces. Dropping Tablespaces. Viewing Tablespace Information.

• Administering Users.

Database User Accounts. Creating a User. Profiles and Users. Authenticating Users. Default and Temporary Tablespaces and Locking. Database Users and Schemas. Privileges. System Privileges. Object Privileges. Assigning Quota to Users. Assigning Roles to Users. Roles. Predefined Roles. Secure Roles.

• Managing Schema Objects.

Schemas. Accessing Schema Objects. Naming Database Objects. Schema Object Namespaces. Creating and Modifying Tables. Understanding Data Integrity. Defining Constraints. Viewing the Attributes of a Table. Viewing the Contents of a Table. Actions with Tables. Creating Indexes. Creating Views. Using a Sequence.

• Managing Data.

Manipulating Data Through SQL. The INSERT Command. The UPDATE Command. The DELETE Command. The COMMIT and ROLLBACK Commands. Integrity Constraints and DML. Data Pump Export. Data Pump Import. DIRECTORY Objects SQL*Loader.

• PL/SQL.

Administering PL/SQL Objects. PL/SQL Objects. Functions. Procedures. Packages. Package Body. Built-In Packages. Triggers. PL/SQL Configuration Options.

• Oracle Database Security.

Apply the Principle of Least Privilege. Protect the Data Dictionary. Revoke Unnecessary Privilegesfrom PUBLIC. Restrict the Operating System Directories Accessible by the User. Limit Users with Administrative Privileges. Disable Remote Operating System Authentication. Manage Default User Accounts. Implement Standard Password Security Features. Monitoring for Suspicious Activity. Audit Tool Comparisons. Standard Database Auditing. Value-Based Auditing. Fine-Grained Auditing (FGA). Auditing SYSDBA and SYSOPER Users. Security Updates.

• Oracle Net Services.

Oracle Net Listener. Monitoring the Listener. Creating a Listener. Listening Addresses. Configuring Optional. Parameters. Static Database Registration. Listener Control Utility. Oracle Net Connections. Names Resolution. Easy Connect. Local Naming. Directory Naming. Configuring Service Aliases. Advanced Connection Options. Oracle Net Manager.

• Oracle Shared Servers.

Dedicated Server Process. User Sessions: Dedicated Server. User Sessions: Shared Server. Configuring Oracle Shared. Server . DISPATCHERS. SHARED_SERVERS. MAX_SHARED_SERVERS. CIRCUITS. SHARED_SERVER_SESSIONS. Related Parameters. Data Dictionary Views. Choosing a Connection Type.

• Performance Monitoring.

Monitoring Methodologies. Database and Instance Metrics. Data Dictionary Metrics. Optimizer Statistics. Manually Gather Optimizer Statistics. Automate Optimizer Statistics Collection. Schedule Optimizer Statistics Collection. Dynamic Performance Views. Viewing Metric Information. Reacting to Performance Issues.

• Proactive Maintenance.

Server Generated Alerts. Thresholds. Baseline Measurements. Tuning and Diagnostic Advisors. SQL Tuning and Access. Advisors.Memory Advisors. Segment Advisor. Automatic Workload Repository (AWR). Managing the AWR. Automatic Database Diagnostic Monitor.

• Undo Management.

Transactions and Undo Data. Storing Undo Information. Monitoring Undo. Administering Undo. Configuring Undo. Retention. Guaranteeing Undo Retention. Sizing the Undo Tablespace. Using the Undo Advisor.

• Monitoring and Resolving Lock Conflicts.

Locks. Locking Mechanism. Data Concurrency. DML Locks. Enqueue Mechanism. Lock Conflicts. Possible Causes of Lock Conflicts. Detecting Lock Conflicts. Resolving Lock Conflicts. Deadlocks.

• Backup and Recovery Concepts.

Backup and Recovery Issues. Categories of Failures. Statement Failures. User Process Failure. Network Failure. User Errors. Instance Failure. Instance Recovery. Phases of Instance Recovery. Tuning Instance Recovery. Using the MTTR Advisor. Media Failure. Configuring for Recoverability. Control Files. Redo Log Files. Archived Log Files. Archive Log File Naming and Destinations. ARCHIVELOG Mode.

• Database Backups.

Terminology. Recovery Manager (RMAN). Configuring Backup Settings. Backup Control File to Trace. Manage Backups. Flash Recovery Area.

• Database Recovery.

Changing Instance Status. Keeping a Database Open. Loss of a Control File. Loss of a Redo Log File. Loss of a Data File in NOARCHIVELOG Mode. Loss of a Noncritical Data File in ARCHIVELOG Mode.