De Meest Voordelige Opleider van Nederland
Award winning E-Learning & Gecertificeerde Trainers
Upgrade uw cv met een certificaat van deelname van OEM
SpringestMicrosoft PartnerEC-CouncilOfferte Aanvragen
0

Tip: we verzorgen onze trainingen tegenwoordig ook VirtueelTip: we verzorgen onze trainingen tegenwoordig ook VirtueelKlik hier voor meer informatie

Tip: we verzorgen onze trainingen tegenwoordig ook VirtueelTip: we verzorgen onze trainingen tegenwoordig ook VirtueelKlik hier voor meer informatie

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

Product description
Oracle Database 11g Performance tuning exam 1Z0-054 E-Learning  Order this great E-Learning Training Oracle DataBasics 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 yo...

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

Order this great E-Learning Training Oracle DataBasics 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 specifications

Availabilty
25 hours
Language
English
Certificate of participation
Yes
Online access
365 days

Reviews

0 / 5Based on 0 reviews

There are no reviews written yet about this product..

Create your own review

Eerder bekeken door jou

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

Training Oracle Database 11g Performance tuning exam 1Z0-054- Online E-Learning training. Order and start immediately for the best price.

€159,00 Excl. tax
Please accept cookies to help us improve this website Is this OK? YesNoMore on cookies »