Get free 1Z0-033, exam, test, oracle, braindumps, cheat, sheet, braindumps, sheets,
brain dumps, cheet, cheetsheets, testking, cheetsheet, cheatsheet, test questions, exam study guides.

1Z0-033

Oracle Certified Professional Database Administrator
Exam #1Z0-033: Oracle9i: Performance Tuning
 
1Z0-033 Braindumps
 
 
Overview of Oracle9i Performance Tuning
  • Describe the roles associated with the database tuning process
  • Describe the dependency between tuning in different development phases
  • Describe service level agreements
  • Describe appropriate tuning goals

Diagnostic and Tuning Tools

  • Explain how the alert.log file is used
  • Explain how background trace files are used
  • Explain how user trace files are used
  • Describe the statistics kept in the dynamic performance views
  • Explain how StatsPack collects statisticsd
  • Collect statistics using StatsPack
  • Collect statistics using Enterprise Manager
  • Use other tuning tools

Sizing the Shared Pool

  • Measure and tune the library cache hit ratio
  • Measure and tune the dictionary cache hit ratio
  • Size and pin objects in the shared pool
  • Tune the shared pool reserve space
  • Describe the UGA and session memory considerations
  • Explain other tuning issues related to the shared pool
  • Set the large pool

 
 

Index
 

1Z0-030  |  1Z0-032  |  1Z0-033  |  1Z0-035