D49524GC20, Oracle Internals for SAP Customers

Patlaban šis kurss nav ieplānots. Izmantojiet zemāk redzamo hipersaiti, lai to pieprasītu
Pieprasīt kursu

Kursa apraksts nav pieejams latviešu valodā!

Kursa mērķi

Every Oracle/SAP administrator will eventually reach the point where he/she would like to know more about the database in detail. We developed this course for these administrators. It includes very in-depth treatment of a few areas from the Oracle/SAP environment.

Especially in the event of an error (e.g. block corruption), very good know-how is an absolute must. Participants each have a PC of their own at their disposal. Within the scope of the course, exercises are conducted on individual focal topics.

Mērķauditorija

• Technical Consultant.

Pēc kursa

• Conveying highly detailed Oracle skills.

Priekšzināšanas

Suggested Prerequisites:

• Very good basic know-how of Oracle 9i/10g.

Kursa materiāli

The student kit includes a comprehensive workbook and other necessary materials for this class.

Kursa saturs

1. Oracle Data blocks:

• Structure of the data blocks
• How individual data types are stored including LOB/long raw
• Performing block dumps
• ITL structure

2. Tablespace management - extent management:

• 'Classical' tablespaces FET$/UET$
• Locally managed tablespaces

3. Tablespace management free space management within Oracle blocks:

• 'Classical' tablespace PCTFREE/PCTUSED
• ASSM tablespace levels I, II, III

4. Transaction handling:

• Performing a simple transaction and generating block dumps/redo dumps to understand transaction handling

5. Oracle events:

• Idea behind Oracle events
• Discussions of special events

6. Performance:

• Cost Based Optimizer (CBO) trace event 10053
• CBO Nested Loop, Hash Join, Sort Merge Join what is the 'best' join?
• CBO Special cases in the SAP environment
• Oracle wait events detailed discussions of special wait events (e.g. cache buffer chain latch) and what can be done

7. Recovery:

• Parallel recovery
• Trace events for recovery situations

8. Advanced administration:

• Resumable and 'after suspend' triggers
• Suspend/resume commands
• Protecting Oracle data blocks (db_block_checksum)
• Extraction of data from 'broken' blocks
• Use of dbms_stats