Training Course:Oracle Performance Tuning and MonitoringSchool/Trainer:Computer Training Unit, North Carolina State University
Raleigh, North Carolina, United States
Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced
Course Description:
'' Students will learn how to effectively maintain and administer a Oracle Database. This course prepares you to appear for the Oracle DBA exam. 32 Hrs
Suggested Prerequisites: Sound Knowledge of Windows, and Microsoft applications (MS Word, MS Excel and Microsoft Access) required. Knowledge of using Application packages for data entry
Attend and You Will Learn
Lesson 1: Overview of Oracle 9i 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
Describe the most common tuning problems
Describe the tuning considerations during development and production
Describe performance and safety tradeoffs
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 statistics
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 ...''
Please go to the school's official website for training price and schedule:
http://www.ncsu.edu/
http://www.ncsu.edu/ctu/
Phone:919.515.8163
School Address:
Computer Training Unit
NC State University
McKimmon Center
1101 Gorman Street
Raleigh, NC 27606 USA
Jobs & Resumes: Raleigh
Houses & Roommates: Raleigh
Other training courses offered by Computer Training Unit, North Carolina State University:
Microsoft Office User Specialist Test Prep
Certificate in Network Security
CompTIA Network+
Oracle 9i: SQL
Oracle Database Administrator 10g (DBA)
Oracle Database 10g Administrator Certified Professional
Oracle Database 10g: Program with PL/SQL
Oracle Database 10g: Security
Oracle Database 10g Administrator Certified Associate
Oracle DBA
CompTIA Security+
Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
Tips:
Want to find a place to stay close to the school? Or homestay in a different country? Try the house rental message board where you can search for roommates and post shared rooms or apartments for rent. |
|
| 
