Oracle Corporation Oracle Database 11g Performance tuning exam 1Z0-054 E-Learning
Oracle Database 11g Performance tuning exam 1Z0-054 E-Learning
€159,00
Oracle Corporation

Oracle Database 11g Performance tuning exam 1Z0-054 E-Learning

EUR 159,00 Excl. btw
  • Koop 2 voor €155,82 per stuk en bespaar 2%
  • Koop 3 voor €154,23 per stuk en bespaar 3%
  • Koop 4 voor €152,64 per stuk en bespaar 4%
  • Koop 5 voor €151,05 per stuk en bespaar 5%
  • Koop 10 voor €143,10 per stuk en bespaar 10%
  • Koop 25 voor €135,15 per stuk en bespaar 15%
  • Koop 50 voor €127,20 per stuk en bespaar 20%

Training Oracle Database 11g Performance tuning exam 1Z0-054- Online E-Learning training. Bestellen en direct starten voor de beste prijs.

  • E-Learning - Online toegang: 365 dagen
  • Taal: Engels (US)
  • Certificaat van deelname
Op voorraad
Bestel voor 16:00 uur en start vandaag.
Aantal
- +
  • Voor 23:00 uur besteld, morgen in huis
  • Certificaat van deelname
  • Bedrijven bestellen op factuur
  • Betaal in 3x geen extra kosten 0% rente en zonder BKR met in3
  • Meer informatie? Neem contact op over dit product
Productomschrijving

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

Bestel deze geweldige E-Learning Training Oracle Database 11g Performance tuning exam 1Z0-054 online, 1 jaar 24/ 7 toegang tot rijke interactieve video’s, spraak, praktijkopdrachten, voortgangsbewaking door rapportages en testen per onderwerp om de kennis direct te toetsen. Na de cursus ontvangt u een certificaat van deelname.


Cursusinhoud

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

Specificaties
Duur 25 uur
Taal Engels
Certificaat van deelname Ja
Online toegang 365 dagen
Voortgangsbewaking Ja
Award Winning E-learning Ja
Geschikt voor mobiel Ja
Wat onze klanten zeggen

average of 0 review(s)

Geen reviews gevonden
Help ons en andere klanten door het schrijven van een review
Mijn account
You are not logged in. Log in to make use of all the benefits. Or create an account now.
Taal
Winkelwagen
Uw winkelwagen is leeg
Menu
Zoeken
Search suggestions
Geen cursussen of trainingen gevonden...
Wij slaan cookies op om onze website te verbeteren. Is dat akkoord? Ja Nee Meer over cookies »