Winkelwagen
U heeft geen artikelen in uw winkelwagen
Oracle Training Oracle Database 11g Performance tuning exam 1Z0-054
Training Oracle Database 11g Performance tuning exam 1Z0-054
€259,00

Goedkoper ergens anders?

Laat het ons weten!

+31367601019 [email protected]

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

Merk: Oracle
|
Klik om te vergroten
€259,00 Excl. btw
€313,39 Incl. btw
Op voorraad
|
Bestel voor 16:00 uur en start vandaag.
Je hebt nog counting... uur
  • Gecertificeerde docenten
  • Beste opleider 2018
  • Cursist staat centraal
Cursusinhoud/-informatie

Bestel deze geweldige Elearning 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

 

Product tags
Heeft u niet gevonden wat u zocht?
Laat ons helpen!
Specificaties
Product
Algemene eigenschappen
Duur: 25 uur
Taal: Engels
Certificaat van deelname: Ja
Online toegang: 365 dagen
Voortgangsbewaking: Ja
Award Winning E-learning: Ja
Geschikt voor mobiel: Ja
Beoordelingen
average of 0 review(s)
Geen reviews gevonden
Help ons en andere klanten door het schrijven van een review
Schrijf uw beoordeling!




Wij slaan cookies op om onze website te verbeteren. Is dat akkoord? Ja Nee Meer over cookies »