Register Login

TADM51 Database Administration Oracle

Updated Jun 08, 2018

TADM51 Database Administration Oracle

Course Overview
This course will introduce Oracle database administration on SAP systems using tools and transactions provided by SAP.
This course is based on:

  •  Oracle 10.2
  •  SAPNetWeaverAS7.00
  •  BR*Tools7.00

Course TADM51 completes your training to become a certified SAP Certified Technology Associate - System Administration - SAP NetWeaver 7.0 (Oracle).
To pass the exam to become a certified SAP Certified Technology Associate - System Administration - SAP NetWeaver 7.0 (Oracle), you must have good
knowledge of the content of courses TADM10 and TADM12, as well as of the database-specific course TADM51 (Oracle).
Like the other TADM courses, TADM51 comprises several individual courses (or parts thereof), which are arranged here in a way that will enable you to gain the
knowledge you require as an SAP Technology Consultant as efficiently as possible.
Course TADM51 is based on content taken from the following courses:
1. ADM505 - Database Administration (Oracle) I
2. ADM506 - Database Administration (Oracle) II
At the end of of this training there is a three-hour certification exam that covers topics from courses TADM10, TADM12, and TADM51.

Course Overview ............................................................................. vii
Course Goals................................................................................ viii
Course Objectives .......................................................................... viii
Unit 1: Database Overview ...................................................................1
Database Architecture .......................................................................3
Connecting to the database ............................................................... 31
Database Administration Tools............................................................ 52
Administration of Oracle Instances....................................................... 83
Unit 2: Backup, Restore & Recovery....................................................107
Backup Strategy ...........................................................................109
Backup Tools ...............................................................................126
Appendix: Tape Management with BR*Tools ..........................................153
Performing Backups ......................................................................171
Restore and Recovery ....................................................................192
Advanced Backup Techniques...........................................................220
Unit 3: Monitors and Tools ................................................................237
Introduction to Oracle Data Management ..............................................238
Database System Check .................................................................260
CCMS Alert Monitor .......................................................................288
Unit 4: Storage Management .............................................................295
Tablespace Administration................................................................296
Reorganization of Tables .................................................................320
Housekeeping and Troubleshooting ....................................................343
Unit 5: Introduction to Oracle cache management ..................................363
Oracle System Global Area ..............................................................364
Oracle Program Global Area .............................................................386
Unit 6: Monitoring of the database instance ..........................................403
Monitoring Performance Using the DBA Cockpit ......................................404
Unit 7: Appendix: Monitoring of the database instance............................435
Oracle Wait Interface......................................................................436
Automatic Workload Repository and Histories.........................................462
Unit 8: Analyzing application design ...................................................481
Consequences of Expensive SQL Statements ........................................483
Using SM50/SM66 to Find Expensive SQL Statements..............................487
Using ST03/STAD to Find Expensive SQL Statements ..............................490
Using ST04 to Find Expensive SQL Statements ......................................494
Using the SQL Trace to Find Expensive SQL Statements ...........................508
Exclusive Lock Waits......................................................................516
Unit 9: Index management and optimization..........................................533
Index Utilization ............................................................................534
Creating an Index..........................................................................551
Unit 10: Cost Based Optimizer ...........................................................575
Update Statistics ...........................................................................576
Appendix: Cost Evaluation ...............................................................596
Unit 11: Analyzing physical and logical layout .......................................615
Fragmented Indexes ......................................................................616
I/O Contention..............................................................................637
Unit 12: Analyzing memory configuration.............................................645
Data Buffer Utilization .....................................................................646
Unit 13: Appendix: Analyzing memory configuration ..............................663
Efficiency of the Shared Pool ............................................................664
Monitoring the Automatic Program Global Area .......................................672
Index............................................................................................689

 


 Download attached file.

You must be Logged in to download this file

×