Cart
You have no items in your shopping cart
Oracle Training Oracle Database 11g Performance tuning exam 1Z0-054
Training Oracle Database 11g Performance tuning exam 1Z0-054
€259,00

Cheaper somewhere else?

Let us know!

+31367601019 [email protected]

Training Oracle Database 11g Performance tuning exam 1Z0-054

Brand: Oracle
|
Click to enlarge
€259,00 Excl. tax
€313,39 Incl. tax
In stock
|
Order before 4:00 PM and start today.
You have got counting... hours
  • Gecertificeerde docenten
  • Beste opleider 2018
  • Cursist staat centraal
Information

Order this great Elearning Training Oracle Database 11g Performance tuning exam 1Z0-054 online, 1 year 24/7 access to rich interactive videos, voice, practice assignments, progress monitoring through reports and tests per subject to test the knowledge directly. After the course you will receive a certificate of participation..

Course content

Oracle Database 11g: Performance Tuning Methodology and Tools

  • identify the steps in both the general and Oracle tuning methodologies
  • identify the characteristics of effective tuning goals
  • recognize the three types of performance data gathered by diagnostic tools
  • recognize the factors to consider when tuning DB time
  • recognize how to use the time model to diagnose performance issues
  • recognize how to view diagnostic information in Enterprise Manager
  • recognize how you can use dynamic performance to view statistics
  • recognize how to use dynamic performance views to display wait events
  • recognize how to use Alert Logs to perform tuning
  • identify ways to generate user trace files
  • view diagnostic information in a given scenario

Oracle Database 11g: Using AWR and Defining Problems

  • identify the features of the AWR
  • recognize how to create and manage AWR snapshots
  • recognize how to run an AWR report
  • recognize how to generate a Compare Periods report
  • generate an AWR report in a given scenario
  • generate a Compare Periods report in a given scenario
  • recognize how to define problems
  • recognize how to set tuning priorities
  • identify factors to consider when tuning for different application life cycle phases
  • identify the seven steps for implementing migration, upgrade, and environment changes
  • recognize how business requirements affect performance
  • identify how to file a performance service request
  • recognize how to install Statspack
  • recognize how to capture and manage Statspack snapshots
  • recognize how to read Statspack performance reports

Oracle Database 11g: Metrics, Alerts, Baselines, AWR Tools, and Services

  • identify the features of metrics, alerts, and baselines
  • recognize how to view metric history information, metric details, and histogram views
  • recognize how to receive an alert when a specified threshold is exceeded
  • identify the features of AWR baselines
  • recognize how to create AWR baselines
  • recognize how to manage AWR baselines
  • recognize how to manage thresholds
  • create and manage AWR baselines and thresholds
  • recognize how to tune automatic maintenance tasks
  • recognize how to generate and read ADDM reports
  • identify the features of the Active Session History
  • recognize how to generate ASH reports
  • recognize how to configure and manage services
  • recognize how to use services with client applications, the Database Resource Manager, and the Scheduler
  • recognize how to set performance-metric thresholds on services
  • recognize how to configure services aggregation and tracing

Oracle Database 11g: Problem SQL Statements and Oracle Optimizer

  • match each phase in SQL statement processing with its features
  • identify the steps in DML processing
  • identify the operations performed by the Oracle optimizer
  • recognize the features of execution plans
  • recognize how to generate and view execution plans
  • recognize how to use the SQL*Plus AUTOTRACE command options to view execution plans and statistics
  • identify the steps involved in using the SQL Trace facility
  • identify the functions of the query optimizer
  • recognize how to influence and control the optimizer's behavior
  • identify the scan types for retrieving data from the database
  • recognize how to work with bitmap and B*Tree indexes
  • identify when to use different join methods
  • identify common sort operations
  • recognize how to manage and maintain indexes
  • recognize how to reorganize tables
  • use AUTOTRACE to analyze statistics and execution plans in a given scenario

Oracle Database 11g: SQL Performance Management and Database Replay

  • recognize the steps in the SQL Performance Analyzer process
  • recognize how to use the SQL Performance Analyzer with PL/SQL
  • recognize how to manage changes to optimizer statistics to maintain SQL performance
  • recognize how to use Automatic SQL Tuning to automate the SQL tuning process
  • recognize how to set up SQL plan management
  • seed SQL plan baselines from SQL Performance Analyzer in a given scenario
  • recognize the steps in using Database Replay to test the impact of a system change
  • recognize how to use the Enterprise Manager to capture workloads
  • recognize how to replay workloads using the Enterprise Manager
  • recognize how to use PL/SQL to capture and replay workloads

Oracle Database 11g: Shared Pool and Buffer Cache Tuning

  • recognize the features of the shared pool
  • identify the role of AWR and Statspack reports indicators when diagnosing problems
  • recognize how to avoid hard parses
  • recognize how to avoid soft parses
  • recognize how to reserve space in the shared pool
  • recognize how to manage the results cache
  • recognize the features of the buffer cache architecture
  • identify the symptoms that indicate a buffer cache problem
  • identify methods to resolve common performance issues related to the buffer cache
  • recognize how to properly size the buffer cache
  • manage the buffer cache in given scenarios

Oracle Database 11g: Tuning PGA, Temporary Space, and AMM

  • identify how to diagnose PGA memory issues
  • recognize how to size the PGA memory
  • recognize how to manage temporary tablespaces
  • identify the components of Automatic Shared Memory Management
  • recognize how to configure Automatic Shared Memory Management (ASMM)
  • recognize how to configure Automatic Memory Management
  • configure memory in a given scenario
  • tune PGA memory in a given scenario
  • create a temporary tablespace group in a given scenario

Oracle Database 11g: Segment Space, I/O, and Performance Tuning

  • identify the characteristics of extents
  • identify the characteristics of blocks
  • identify the characteristics of Automatic Segment Space Management (ASSM)
  • recognize how to manage row migration and chaining
  • recognize how to shrink segments using SQL or the Enterprise Manager
  • recognize how to use table compression
  • identify the characteristics of I/O
  • recognize how to tune I/O effectively
  • identify the characteristics of RAID
  • recognize how to manage and monitor ASM
  • recognize best practices for performance tuning
  • tune I/O in a given scenario
  • view I/O statistics in a given scenario

 

Product tags
Heeft u niet gevonden wat u zocht?
Let us help!
Specifications
Product
General properties
Availabilty: 25 hours
Language: English
Certificate of participation: Yes
Online access: 90 days
Progress monitoring: Yes
Award Winning E-learning: Yes
Suitable for mobile: Yes
Reviews
average of 0 review(s)
No reviews found
Read or write a review
Write a review




Please accept cookies to help us improve this website Is this OK? Yes No More on cookies »