Loading Classes
Database Administration Oracle II (ADM506)
New Age Technologies has been delivering Authorized Training since 1996. We offer SAP’s full suite of authorized courses including courses pertaining to Database Administration Oracle, Supply Chain Management (SCM), Enterprise Resource Planning (ERP), BusinessObjects, Product Lifecycle Management (PLM), and more. If you have any questions or can’t seem to find the SAP class that you are interested in, contact one of our SAP Training Specialists. Invest in your future today with SAP training from New Age Technologies.
✉ SAP Training Specialists | ☏ 502.909.0819
Current Promotion
COURSE INFORMATION
Database Administration Oracle II (ADM506) Overview:
In the Database Administration Oracle II (ADM506) course, you will learn how to describe memory management in the Oracle database, monitor an Oracle database with the SAP database monitor, and analyze and optimize database performance.
Note: Course Based on Software Release – SAP ERP 6.05 and Oracle 11g
Who Should Attend:
- System Administrator
- Database Administrator
- Technology Consultant
Database Administration Oracle II (ADM506) Prerequisites:
Before attending this course, you must have the following:
Database Administration Oracle II (ADM506) Content:
Oracle Cache Management
- Introducing Oracle System Global Area
- Introducing Automatic Oracle Program Global Area (PGA)
Monitoring of the Database Instance
- Using the DBA Cockpit to Monitor the Database
- Understanding the DBA Cockpit support of Oracle database features
Application Design Analysis
- Understanding the Impact of Expensive SQL Statements
- Using SM50/SM66 to Find Expensive SQL Statements
- Using ST03/STAD to Find Expensive SQL Statements
- Using ST04 to Find Expensive SQL Statements
- Using SQL Trace to Find Expensive SQL Statements
- Monitoring Exclusive Lock Waits
Index Management and Optimization
- Utilizing Indexes
- Creating an Index
Cost-Based Optimizer
- Updating Statistics
- Detecting problems with Optimizer statistics
Analysis of Physical and Logical Layout
- Defragmenting Indexes
- Working with I/O Contention
Memory Configuration Analysis
- Describing Data Buffer Utilization
- Analyzing Efficiency of Shared Pool
- Monitoring the Automatic Program Global Area (PGA)
Wait Interface and Automatic Workload Repository
- Observing Oracle Wait Interface
- Reviewing Automatic Workload Repository and Histories
