Oracle Performance Tuning online Training and Support

Feel free to contact

Call : +91-8870903864
Or E-mail
contactexpertsonline@gmail.com

ORACLE PERFORMANCE TUNING
1 – 1: Introduction to Oracle tuning
The top-down approach to tuning
The history of Oracle tuning
A review of the Oracle architecture
The goals of Oracle tuning
Overview of SQL tuning
Oracle network bottlenecks

1 – 2: Oracle disk I/O tuning
History of DASD
Understanding disk I/O
Monitoring disk I/O (AWR, dba_hist_filestatxs)
Sorted hash cluster tables
Disk I/O waits
Oracle data buffer internals (db_cache_size)
Caching data blocks in the PGA (parallel full-table scans)
Blocksize and I/O performance

1 – 3: Oracle CPU Tuning
Finding your cpu_count
Measuring CPU usage with vmstat
_optimizer_cost_model=cpu
Parallel query and CPU

1 – 4: Oracle RAM tuning
all_rows and first_rows optimization and RAM
Multiple data buffers
Multiple blocksizes
Measuring RAM paging
Oracle SGA RAM
Oracle PGA RAM
Using the KEEP pool
Automatic Memory Management (AMM)

1 – 5: Oracle Instance Tuning
Global tuning techniques
Display possible unnecessary large-table full-table scans
Library cache tuning
1 – 6: Oracle SQL Tuning Introduction
SQL tuning hierarchy
SQL tuning goals
optimizer modes
query re-write
cursor_sharing
viewing execution plans (autotrace)
verifying optimal join techniques
parallelizing SQL execution
dynamic statistics
Exercise – count times when a table is invoked
12c new SQL features
function-based virtual column
adaptive execution plans
12c new optimizer metadata collection features

2 – 1: AWR and ASH
AWR vs STATSPACK
Reading an AWR report
AWR report analyzer
Basics of predictive modeling for performance
Finding repeating signatures of data
2 - 2: Oracle RAC Tuning
RAC architecture tuning
Tuning disk I/O on RAC
Tuning the cache fusion layer on RAC
2 – 3: Oracle Tuning Pack
creating SQL Profiles
Recommending new indexes
“automatic” SQL Tuning
SQL Performance Advisor (SPA)
recommending object reorganization
2 – 5: Oracle Diagnostic pack
AWR and ASH
real time SQL monitoring
comparing performance periods
Oracle monitoring & alert notifications (setting thresholds)
2 – 6: Oracle Tracing
10046 tracing
TKPROF tracing
Trace analyzer
Autotrace
3 –2: Optimizing Oracle SQL
Parsing a SQL statement
Semantic parsing

3 –3: Optimizer statistics
Types of metadata
System stats

3 – 4: Exposing & Reading Execution Plans
autotrace
SQL*Trace
Determine the steps of an execution plan
3 – 5: altering execution plans
Changing CBO statistics
Using hints
Using the opt_param hint

3 – 6: Oracle indexing
Overview of Oracle indexing
function-based indexes (FBI)
index usage monitoring
fishing in the library cache
optimizing indexes
Identifying EOW, EOM and EOY SQL.
Creating on-demand indexing
oracle text indexes

DAY 4 Advanced Topics in Tuning
4 – 1: Boolean/Built-in functions
Boolean evaluation
Decode and case
Basics of B PGA to avoid disk sortsIFs
Function-based indexing
Creating a custom BIF using PL/SQL
The effect of BIFs on SQL execution

4 – 2: tuning Oracle sorting
Basics of sorting
RAM usage in a hash join
Use autotrace to see sorts

4 – 3: Tuning Oracle subqueries
Scalar subqueries
In-Line views
Correlated vs non-correlated subqueries
The merge_aj hint
The anti-join hints

4 – 4 Tuning with temp objects (materialized views, global temporary tables)
Tuning with temporary tables

4- 5: Tuning full-table scans
Basics of file multiblock I/O
Deciding when to invoke full-table scan
RAM caching in the SGA
Tracking full-scans over time with AWR

4- 6 tuning parallel query
Parallel query

Oracle Performance Tuning training online, Oracle Performance Tuning training material, IBM Websphere Application Server training cost, Oracle Performance Tunning training pdf, Websphere Application Server training in USA uae India, Oracle Performance Tuning training, online Corporate training malaysia Singapore, Oracle Performance Tuning software, Oracle Performance Tuning training in bangalore, Oracle Performance Tuning training institutes in hyderabad, Oracle Performance Tuning training in chennai, Oracle Performance Tuning training in hyderabad, Delhi, Mumbai, Pune, Oracle Performance Tunning, Oracle Performance Tuning training webinar, online training singapore, Oracle Performance Tuning eam, Oracle Performance Tuning as a service,Oracle Performance Tuning online Training Oracle Performance Tuning online Training Oracle Performance Tuning online Training Oracle Performance Tunning online Training maximo scheduler, Oracle Performance Tunning (consumer product) Oracle Performance Tunning online Training Oracle Performance Tuning online Training Oracle Performance Tuning online Training Oracle Performance Tuning online Training Oracle Performance Tuning online Training , Post Training Support