Ihr Warenkorb
Keine Artikel in Ihrem Warenkorb
Oracle Oracle Database 11g Performance tuning exam 1Z0-054 E-Learning Kurs
Oracle Database 11g Performance tuning exam 1Z0-054 E-Learning Kurs
€139,00 €159,00

Woanders günstiger?

Lass uns wissen!

+31367601019 [email protected]

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

Marke: Oracle
|
Klicken um zu vergrößern
€139,00 €159,00 exkl. MwSt.
€161,24 €184,44 Inkl. MwSt.
  • Kaufen Sie 2 für je €155,82 und sparen Sie 2%
  • Kaufen Sie 3 für je €154,23 und sparen Sie 3%
  • Kaufen Sie 5 für je €147,87 und sparen Sie 7%
  • Kaufen Sie 10 für je €143,10 und sparen Sie 10%
  • Kaufen Sie 25 für je €135,15 und sparen Sie 15%
  • Kaufen Sie 50 für je €124,02 und sparen Sie 22%
  • Kaufen Sie 100 für je €111,30 und sparen Sie 30%
  • Kaufen Sie 200 für je €79,50 und sparen Sie 50%
Auf Lager
|
Bestellung vor 16.00 Uhr und heute starten.
Sie haben counting... stunden
  • 1 Jahr Zugang
  • Beginnen Sie noch heute
  • Teilnahmezertifikat
Informationen

Oracle Database 11g Performance tuning exam 1Z0-054

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
Haben Sie nicht gefunden, wonach Sie suchen?
Lassen Sie uns helfen!
Eigenschaften
Produkt
Allgemeine Eigenschaften
Studiengebühr: 5 Stunden Dauer plus Übungen (variabel)
Sprache: Englisch
Online-Zugang: 1 Jahr
Teilnahmebescheinigung: Ja, nach 70% der erfolgreichen Einsätze
Fortschrittsüberwachung: Ja
Geeignet für Handys: Ja
Preisgekröntes E-Learning: Ja
Bewertungen
Durchschnitt von 0 Bewertungen
Kein Bewertungen
Lesen oder schreiben Sie einen Kommentar
Schreiben Sie eine Bewertung!




Wir benutzen Cookies nur für interne Zwecke um den Webshop zu verbessern. Ist das in Ordnung? Ja Nein Für weitere Informationen beachten Sie bitte unsere Datenschutzerklärung. »