Database Administration Oracle II
Description
Goals
- Describe memory management in the Oracle database
- Regularly monitoring of an Oracle database with the SAP database monitor
- Analyzing and optimizing database performance
Audience
- System Administrator
- Database Administrator
- Technology Consultant
Prerequisites
Essential- ADM505
- none
Course based on software release
- SAP ERP 6.05
- Oracle 11g
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 Im…
Frequently asked questions
There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.
Goals
- Describe memory management in the Oracle database
- Regularly monitoring of an Oracle database with the SAP database monitor
- Analyzing and optimizing database performance
Audience
- System Administrator
- Database Administrator
- Technology Consultant
Prerequisites
Essential- ADM505
- none
Course based on software release
- SAP ERP 6.05
- Oracle 11g
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
Notes
- Optimizing database parameters and the hardware configuration are not covered as part of this course
Popular tags
No tags submitted for this course yet
Share your review
Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate $1.- to Stichting Edukans.There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.