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.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s