Home
E-mail Us
Oracle Articles
New Oracle Articles

Oracle Training
Oracle Tips
Oracle Forum
Class Catalog

Remote DBA
Oracle Tuning
Emergency 911
RAC Support
Apps Support
Analysis
Design
Implementation
Oracle Support

SQL Tuning
Security
Oracle UNIX
Oracle Linux
Monitoring
Remote support
Remote plans
Remote services
Application Server
Applications
Oracle Forms
Oracle Portal
App Upgrades
SQL Server
Oracle Concepts
Software Support
Remote Support
Development
Implementation

Consulting Staff
Consulting Prices
Help Wanted!

Oracle Posters
Oracle Books
Oracle Scripts
Ion
Excel-DB

Don Burleson Blog

Oracle Database 10g New Features for Administrators OCP Exam Training Class

This course is taught at your Company site with up to 20 students.

Click here for on-site course prices

* Learn Oracle 10g installation & configuration.

* Understand Server Configuration.

* See new Oracle10g Utilities Enhancements.

* Use Oracle10g Backup and Recovery Features.

* Learn Oracle10g Database Tuning and Performance.

* Understand Oracle10g Globalization Improvements.

exercises are used to demonstrate each feature and the student will gain first-hand experience in the key Oracle SQL & PL/SQL concepts required to pass the Oracle10g OCP SQL & PL/SQL exam. This course provides sample OCP exam questions and an opportunity to access your overall knowledge of Oracle 10g SQL concepts and PL/SQL programming.

The primary goal of this course is to prepare the students to pass the Oracle10g OCP SQL & PL/SQL exam. This Oracle10g OCP course is an intensive 5-day course is designed to provide Oracle professionals with an in-depth understanding of the SQL & PL/SQL features of Oracle10g, specific Oracle concepts and knowledge required for the OCP exam, and tips and techniques for passing the Oracle10g OCP exam on your first attempt.

Broad in scope, this course covers all of the Oracle10g SQL & PL/SQL topics on the OCP exam. PL/SQL techniques include PL/QL control structures, PL/SQL Boolean Logic, PL/SQL array processing, bulk collect techniques and the use of stored procedures and PL/SQL packages. SQL techniques include in-line views, scalar subqueries, correlated and non-correlated subqueries, execution plan analysis and SQL tuning.

Oracle Database 10g New Features
Oracle 10g Reference for Advanced Tuning & Administration

Mike Ault, Daniel Liu, Madhu Tumma

ISBN: 0-9740716-0-9

This Oracle OCP SQL & PL/SQL exam review training is designed for the practicing Oracle professional but it is useful to anyone interested in learning Oracle SQL and PL/SQL. Appropriate students include Oracle developers, Oracle DBAs, Oracle web developers and any computer professional who needs to understand developing applications using Oracle SQL & PL/SQL. The course assumes a basic knowledge of computer programming techniques, relational database concepts and basic SQL syntax.

This Oracle OCP training was designed by Donald K. Burleson. Author of more than 30 database books, Burleson was chosen by Oracle Press to write five authorized editions, including Oracle High-Performance SQL tuning. Burleson Corporation instructors offer decades of real world DBA experience in Oracle features, and they will share their Oracle secrets in this intense Oracle new features training

Learning Objectives:

The primary objective of this Oracle10g OCP training is to provide each student with the knowledge and testing secrets for passing the Oracle10g OCP SQL & PL/SQL exam. The student will gain confidence in their Oracle SQL & PL/SQL knowledge and learn the tricks and traps of the Oracle10g OCP SQL & PL/SQL exam.

Using a proven training combination of intense instruction, practicum and numerous Oracle10g sample exams, the student should have a firm understanding of Oracle10g SQL and PL/SQL coding techniques.

Oracle Database 10g New Features for Administrators OCP Exam

Oracle10g Certified Professional New Features OCP Upgrade Class

A five-day on-site Oracle Certified Professional Training Course

Test 1Z0-040

Syllabus

Oracle 10g installation & configuration

Oracle10g installer new features

Oracle10g installer performance enhancements

Oracle10g installer

Server Configuration

Simplified subset of init.ora initialization parameters

Using Oracle10g policy-based database configuration framework

Use the DBCA wizard to clone a database

Use the DBCA wizard to create a Real Application Clusters RAC database

Using 10g OEM to view AWR and ASH statistics

New Oracle10g Utilities Enhancements

Cross-platform transportable tablespace enhancements

Using the RMAN convert clause

Oracle Data Pump utility replaces export/import utilities

Using the oracle_datapump access driver API

Parallel unload with Datapump

Monitoring a Data Pump job

Creating datapump external tables

Defining datapump external table properties

Improved VLDB Support

Bigfile tablespaces

Temporary tablespace groups

Detecting & skipping unuseable indexes

Partitioning Enhancements

Storage characteristics for index partitions

Hash-partitioned global indexes

Oracle10g Backup and Recovery Features

Flashback and RMAN

Extended Flashback Functions

Flashback Database

Flashback Standby Database

Flashback Re-instantiation

Flashback Drop

Flashback Table

Flashback Row History

Flashback Transaction History

RMAN Enhancements

Automated Channel Failover for Backup and Restore

Automated File Creation During Recovery

Simplified Backups to Disk

Proxy Copy Backup of Archivelogs

Incrementally Updated Backups

Simplified Recovery Through Resetlogs

Full Database Begin Backup Command

Changes to the ALTER DATABASE END BACKUP command

Change-Aware Incremental Backups

Automated Disk-Based Backup and Recovery

RMAN Database Dropping and Deregistration

Automated TSPITR Instantiation

Simplified Recovery Manager Cataloging of Backup Files

RMAN and the new EM (Enterprise Manager)

Save storage space through writing compressed backup sets

Manageability Infrastructure

Monitoring with AWR and ASH

Monitor and manage server-generated alerts

Explain the automated tasks feature

Oracle10g Database Tuning and Performance

Database Resource Manager

Components of DRM

Resource Plans and Plan Directives

Procedure to implement and manage

Automatic Mapping

Database Tuning Improvements

User initiated Buffer Cache Flushing

Automated Checkpoint Tuning

Easier Transaction Recovery Monitoring

Performance Overview Charts

Application Tuning Improvements

Optimizer Mode

Moving from RBO to the Cost-Based Optimizer

Dynamic Sampling

Sample Table Scans

trcsess utility

Self-Tuning Features

Automatic Shared Memory Management

Automatic SQL Tuning Process

SQL Tuning Advisor

Wait Event Model improvements

Overview of Wait Event Model

Oracle10g Database & Instance Management

SYSAUX Tablespace

What is Automated Storage Management?

Automated Storage Management Configuration

ASM Concepts

ASM Files

Failure Groups

ASM Instances

Database Instance ASM Background Processes

Installation of ASM

ASM Benefits

Viewing Information About Automated Storage Management

Automated Memory Management

Oracle Database g Automation Features

Automatic Workload Repository

Automatic Maintenance Tasks

Oracle Database g Automatic Memory Management (AMM)

How AMM Works

Adjusting the Oracle Database g data buffers

Viewing Information About the SGA

Adjusting the Oracle Database g Shared Pool

Conclusions about AMM

Automated RAC Services Configuration

Creating a Real Application Clusters Database with the DBCA

Simplified Upgrade for RAC and OPS Databases

Drop Database

Oracle10g Tablespace Management

Temporary Tablespace

Temporary Tablespace Group Overview

Temporary Tablespace Group Benefits

New Data Dictionary View

Examples

Rename Tablespace

Tablespace Rename Overview

Tablespace Rename Benefits

Bigfile Tablespace

Bigfile Tablespace Overview

Bigfile Tablespace Benefits

Maximum Database Size

Extended ROWID Format

Data Dictionary Views Enhancement

Examples

New Cross-Platform Transportable Tablespaces

Benefits

Supported Platforms and New Data Dictionary Views

Determine Platform Endianness

Convert Datafiles using RMAN

Oracle10g Table and Index Features

Table and Index Partitions

Overview

Index-Organized Tables

LOB Column Support for IOT Partitions

Locally Partitioned Bitmap Indexes on an IOT Partition

Managing Index Partitions

Skipping Unusable Indexes

Enhanced Partition Management in OEM

Hash-Partitioned Global Indexes

Sorted Hash-Clustered Tables

Overview of Hash Clusters

Creating Sorted Hash-Clustered Tables

Oracle10g DML Features

Single-Set Aggregates in DML Returning Clause

Single-set Aggregates in the INSERT Statement

Single-set Aggregates in the UPDATE Statement

Single-set Aggregates in the DELETE Statement

Virtual Spreadsheets and Upsert Through SQL Interrow Calculations

Oracle10g SELECT Features

Grouped Table Outer Join

Increased Number of Aggregates per Query

Remote Stored Functions in SELECT Statements

hs_call_name

Case-Insensitive and Accent-Insensitive Query and Sort

Enhanced CONNECT BY Support

Hierarchical Query Pseudo-columns

Oracle Expression Filter

The Expression Attribute Set

Expression Datatype and Expressions

The EVALUATE Operator

Example use of the EVALUATE Operator

Using CREATE INDEX for Expressions

SQL Regular Expressions

Changes to INSTR

Changes to LIKE

Changes to REPLACE

Changes to SUBSTR

Multilingual Regular Expression Syntax

Notes on the POSIX operators and Oracle enhancements:

Regular Expression Operator Multilingual Enhancements

Row Timestamp

Oracle10g Improved Existing Features

Existing Features That Have Changed

Asynchronous Row Change Data Capture

Overview of Change Data Capture

Change Data Capture

Asynchronous Change Data Capture

Cross-Platform Transportable Tablespaces

Transporting Tablespaces Between Databases: A General Procedure

The RMAN CONVERT Clause

Restrictions and Usage Notes

Enhanced Table Functions

Returning Large Amounts of Data from a Function

Representing Dynamically Typed Data Using SYS.AnyData, SYS.AnyType, and SYS.AnyDataSet Types

External Tables Unload

Unloading Data Using External Tables and the oracle_datapump Access Driver

The oracle_datapump Access Driver

LOGFILE | NOLOGFILE

Using LOGFILE clause for oracle_datapump

Unloading Data With the oracle_datapump Access Driver

PARALLEL UNLOAD

Supported Datatypes

Unsupported Datatypes

Reserved Words For the oracle_datapump Access Driver

Enhanced MERGE Functionality

Prerequisites

MERGE Syntax

Oracle10g Initialization Parameters

Basic Parameters

Old Parameters

New Parameters

create_stored_outlines

db_flashback_retention_target

db_recovery_file_dest

db_recovery_file_dest_size

db_unique_name

ddl_wait_for_locks

ldap_directory_access

log_archive_config

instance_type

osm_diskgroups

osm_diskstring

osm_power_limit

plsql_code_type

plsql_debug

plsql_optimize_level

plsql_warnings

resumable_timeout

sga_target

skip_unusable_indexes

smtp_out_server

sqltune_category

streams_pool_size

Oracle10g Manageability Features

Easy Management

Self-Managing Database

Automatic Workload Repository (AWR)

General Benefits

Physical Structures

Collection Process

Using and Managing AWR

Active Session History

Database Feature Usage Metrics

Advisory Framework - ADDM

Server Alert Mechanism

Pro-Active Space Management

Shared Server Configuration

Transaction Manageability

New Columns

Changes to v$session_longops

MAXTRANS and Maximum Concurrency

Statistics Collection

Dictionary Objects

Guidelines

Changes to dbms_stats package

DML Table Monitoring Changes

Audit Enhancements

Uniform Audit Trails

Fine-Grained Auditing (FGA)

Response File

Oracle10g Utilities Improvements

Data Pump Utilities

Data Pump Overview

Data Pump Export

Data Pump Import

New Scheduler Utilities

Scheduler Components

Create, Enable, Disable, and Drop a Program

Create and Drop a Schedule

Create A Job Class

Data Dictionary Views

SQL*Plus Enhancements

New DEFINE Variables

SPOOL Command Enhancement

Oracle10g Network Features

Enhanced Oracle Networking

Export Directory Naming Entries to Local Naming File (tnsnames.ora)

Dynamic Connection Manager Configuration

Easy Connect Naming Method

Syntax Element Description

Configuring Easy Connect Naming to Use an Alias

Improved Network Outage Detection

Configuration of the Advanced Profile Information

Improved Connection Manager Access Rules

Automated Shared Server Configuration

Simplified Shared Server Configuration

Shared Server Initialization Parameters

Certificate Validation with Certificate Revocation Lists (CRLs)

Certificate Revocation Lists

Centralized CRL Management

Centralized User Management for Kerberos Users

What Exactly is a Trusted Database?

Access to Single Sign On Wallet Java Applications

Single Station Administration for Password Authentication

Overview of Password-Authenticated Enterprise User Database Login Information Security

Protecting Database Password Verifiers With Directory ACLS

Transport Layer Security (TLS) Support

SSL and TLS in an Oracle Environment

Oracle10g High Availability and Scalability

Avoiding Disruption

Online Redefinition

New Additions and Changes

Synonyms and Views

LOGMINER

Automatic Determination of Redo Log Files

Data Guard Environment

Overview of New Features

Supplemental Logging

Real Application Clusters

Service Registration

CRS – Cluster Ready Services

Rolling Upgrades

Oracle10g Oracle Streams

Streams Overview

Configuration and Management

Streams Administrator

SYSAUX tablespace usage

Streams Pool in the SGA

Buffered Queues in the SGA

Purge Streams Queues

New and Modified Views

Downstream Capture

Advantages of Downstream Capture

Downstream Capture Method

Monitoring Downstream Capture Processes

Asynchronous Change Data Capture

Rule Interface Improvements

Negative Rule Sets

Rule Based Transformation

Subset Rules

Replication Enhancements

Instantiating with RMAN

Instantiating with Transportable Tablespace

Migration from Advanced Replication

Messaging Enhancements

Streams Messaging Client

Simplified Configuration

Advance Queue Enhancements

Conclusion

Oracle10g Security Enhancements

Virtual Private Database

Virtual Private Database Overview

Column-Level Privacy

Apply a Column-Level VPD Policy

New Types of VPD Policies

Audit Enhancements

Oracle10g Business Intelligence

Materialized View Enhancements

Partition Tracking Change

MJV Enhancement

Nested MV enhancement

Query Rewriting

Generalized Multiple Table Instance Support

Summary Management Improvements

Materialized View Column Aliases

Partition Maintenance Operations (PMOP)

Enhanced Explain Plan for Materialized Views

Materialized View Log

Describe and Validate Dimensions

SQLAccess Advisor

Overview

Overall Benefits

Using the SQLAccess Advisor

OLAP Enhancements

Hierarchy Handling Improvements

XML Support for Analytic Workspace (AW)

Useful Views

Support for Bioinformatics

Bioinformatics Overview

Data Mining for Analytical

Multi-User Access Control

Enhanced Adaptive Bayes Network (ABN)

Non-Negative Matrix Factorization

Text Mining

Oracle10g Globalization Improvements

Globalization Development Kit Enhancements

Overview of the Globalization Development Kit and Its Components

Overview of Designing a Global Internet Application

Getting Started with Oracle Globalization Services

Oracle Services in OGS

Internet Services in OGS

Enhanced Character Set Scanner and Converter

Character Set Scanner Reports

Universal Character Sets

Oracle 10g Automatic Management

Installing, configuring & using Automatic Database Diagnostic Monitor (ADDM)

Simplifying SGA optimization with Automatic Memory Management (AMM)

Automatic CBO SQL optimizer statistics collection with dbms_stats

Using Automatic Undo Retention Tuning

Automatic Storage Management (ASM)

Review new init.ora parameters & files for ASM and Oracle10g instance

SAM and Stripe And Mirror Everywhere (SAME)

ASM file naming conventions

Starting and stopping ASM instances

ASM disk group management

Using RMAN to migrate to ASM

Oracle10g Oracle Enterprise Manager

Installation Of OEM

Starting and Navigating in OEM

The EMGO Interface

��