Oracle Database 11g: Performance Tuning

Technology : Oracle

Course Brief

This Oracle Database 11g Performance Tuning training starts with an unknown database that requires tuning. You will then learn the steps a DBA performs to identify problem areas, diagnose common problems and fix them.

Learn To:

  • Describe Oracle tuning methodology.
  • Use Oracle supplied tools for monitoring and diagnosing SQL and Instance tuning issues.
  • Use database advisors to correct performance problems proactively.
  • Identify problem SQL statements & tune SQL performance problems.
  • Monitor the Instance Performance using Enterprise Manager.
  • Tune instance components, primarily using Instance parameters.

Benefits to You

Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling smooth and rapid consolidation within your Datacenter.

Audience

  • Database Administrators
  • Support Engineer
  • Technical Consultant
Course Duration - Full Time: The course lasts 5 days. Course Duration - Part Time: The course lasts 1 month.

Topics
Introduction to Database Security
Choosing Security Solutions
Basic Database Security
Auditing Database Users, Privileges, and Objects
Auditing DML Statements
Using Basic User Authentication
Using Strong Authentication
Using Enterprise User Security
Using Proxy Authentication
Using Privileges and Roles
Access Control
Implementing Virtual Private Database
Oracle Label Security Concepts
Implementing Oracle Label Security
Using the Data Masking Pack
Encryption Concepts
Using Application-Based Encryption
Applying Transparent Data Encryption
Applying File Encryption
Oracle Net Services: Security Checklists
Securing the Listener
Start Date End Date Timing Duration

Full Name

Email

Phone

Course Name

Select Schedule

Select Program