Training

Don’t see the class that fits your schedule ! Let us know we will add it for you !

Training calendar
DATE	TIME	TITLE	LANGUAGE	LOCATION	PRICE
17/03/2016	09h-15h (GMT+1)	Troubleshooting Oracle performance using trace data (Event 10046)	French	Tunisia	380 TND
13/04/2016	09h-15h (GMT+1)	Troubleshooting Oracle performance using trace data (Event 10046)	French	Online	380 EURO
28/04/2016	09h-15h (GMT+1)	Troubleshooting Oracle performance using trace data (Event 10046)	English	Online	380 EURO
Due to restrictions on using paypal in our country(TUNISIA),we accept only payment via a Purchase Order/Invoice. In order to register for a class, please send an email to training@mahmoudc.pro with your company information and purchase order attached.

All online training will be conducted online using Citrix’gotowebinar.com service and Amazon Cloud Instances (For exercises)

Troubleshooting Oracle performance using trace data (Event 10046)

Oracle Extended SQL trace can be a valuable asset in performance optimization, debugging and learning.Armed with the right methods and tools it can help us diagnose performance problem very quickly.

You will learn:

Fast and effective Methods for approaching a performance problem.
Different techniques available for creating trace files.
Reading and interpreting raw trace file.
Profiling Extended Sql Trace file (TKPROF,TRCANLZR ,TVD$XTAT,TrcExtProf).
Profiling PL/SQL code using “DBMS_PROFILIER” and “DBMS_HPROF”
Extracting SQL information using “SQLTEXTRACT” and “SQLD360”
Clearer understanding of waits events (tracing wait events at system level using systemtap/strace)

Agenda :

Performance and methodology.
Why trace ?
When and how to trace ?
Reading a trace file
A little bit of arithmetic
Profiling tools
Case study
PL/SQL profiling
SQLTEXTRACT & SQLD360

6 hours with Q&A ,discussion and breaks (breaks coincide with exercises or approximately every 90 minutes)

How to attend our training courses

Due to restrictions on using paypal in our country(TUNISIA),we accept only payment via a Purchase Order/Invoice. In order to register for a class, please send an email to training@mahmoudc.pro with your company information and purchase order attached.

For any question please email me training@mahmoudc.pro

Cancellation Policies :

For all training, any cancellation notice must be emailed to training@mahmoudc.pro no less than seven business days in advance of the class start date.
We reserves the right to reschedule or cancel the date, time and location of a training class at any time.
In the event a training class is cancelled, the Customer is entitled to a full refund less any fees incurred.