Oracle Training Oracle Support Development Oracle Apps

 
 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 s
upport
 Remote plans
 Remote
services
 Application Server

 Applications
 Oracle Forms
 Oracle Portal
 App Upgrades
 SQL Server
 Oracle Concepts
 Software Support

 Remote S
upport  
 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

© 2007-2016 by Burleson Corporation

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

Click here for on-site course prices

 

 

Key Features

* 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.
 

 

 

  

Course Description

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.

Book Required

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

Mike Ault, Daniel Liu, Madhu Tumma

ISBN: 0-9740716-0-9

Audience

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.

Curriculum Design

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

Oracle 10g Certified Professional

Oracle10g Certified Professional New Features OCP Upgrade Class
A five-day on-site Oracle Certified Professional Training Course
Test 1Z0-040
Copyright © 2007-2016 by Burleson Corporation
 
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
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

 

 

 

 

 

 

 

 

 

 

��  
 
 
Oracle Training at Sea
 
 
 
 
oracle dba poster
 

 
Follow us on Twitter 
 
Oracle performance tuning software 
 
Oracle Linux poster
 
 
 

 

Burleson is the American Team

Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals.  Feel free to ask questions on our Oracle forum.

Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications.

Errata?  Oracle technology is changing and we strive to update our BC Oracle support information.  If you find an error or have a suggestion for improving our content, we would appreciate your feedback.  Just  e-mail:  

and include the URL for the page.


                    









Burleson Consulting

The Oracle of Database Support

Oracle Performance Tuning

Remote DBA Services


 

Copyright © 1996 -  2017

All rights reserved by Burleson

Oracle ® is the registered trademark of Oracle Corporation.

Remote Emergency Support provided by Conversational