This is a must attend seminar/webinar aimed at Oracle professionals (both DBAs and Developers) who are interested in Performance Tuning. The seminar/webinar will detail how to maximise the performance of both Oracle databases and associated applications and how to diagnose and address any performance issues as quickly and effectively as possible.
When an application suddenly runs “slow” or when people start complaining about the “poor performance” of the database, there’s often some uncertainty in how to most quickly and most accurately determine the “root” cause of any such slowdown and effectively address any associated issues. In this seminar, we explore a Tuning Methodology that helps Oracle professionals to both quickly and reliably determine the actual causes of performance issues and so ensure the effectiveness of any applied resolutions.
Looking at a number of real world scenarios and numerous actual examples and test cases, this seminar/webinar will show participants how to confidently and reliably diagnose performance issues. The seminar/webinar explores in much detail the various diagnostics tools and reports available in Oracle to assist in determining any database performance issue and importantly WHEN and HOW to effectively use each approach. Additionally, participants are also invited to share their own database/SQL reports where we can apply the principles learnt in diagnosing the performance of their actual databases/applications (we can communicate prior to the event on how to best get any reports of interest).
One of the more common reasons for poor Oracle performance is inefficient or poorly running SQL. This seminar explores in much detail how SQL is executed within the Oracle database, the various issues and related concepts important in understanding why SQL might be inefficient and the many capabilities and features Oracle has in helping to both resolve SQL performance issues and to maintain the stability and reliability of SQL execution.
It’s a fun, but intense, content rich seminar/webinar that is suitable for people of all experiences (from beginners to seasoned Oracle experts).
Note: Numbers are strictly limited due to the small class nature of the seminars/webinars. Please book early to avoid disappointment as seminars/webinars are not scheduled regularly.
For a list of all upcoming seminars/webinars, see the Seminar and Webinars Dates page.
If you have 5 or more persons in your organisation who would like to attend the seminar/webinar, contact me as I can customise it and run it exclusively at your premises for a great price. No waiting for the seminar to come near you and no travel expenses for your employees. Just the seminar for your staff, with just the topics that are of most interest to your organisation. We can even look at your specific issues and address them as part of the seminar.
All seminars include:
- Detailed course notes
Seminar/Webinar Content (subject to minor change)
Section One: Basic Tuning Concepts
- Common (but flawed) Tuning Methodology
- THE Correct Tuning Methodology
- Importance of Response Times
- Importance of Database Time and Concurrent Active Sessions
- Introduction to Oracle Wait Interface
- The Correct Mentality To Performance Tuning
- Importance Of Instrumentation
Section Two: Database Tuning
In Section Two, we explore how to best diagnose any performance issues as quickly as possible to accurately determine any root issue(s) and so apply the most appropriate resolutions. We explore a number of real world examples as well as providing the opportunity to go through any reports participants may wish to share.
As part of determining how to best resolve a number of real world examples, we get the opportunity to explore the internals of the database and the importance of understanding a number of crucial Oracle database concepts (e.g. latch contention, redo log mechanism, RAC cache fusion).
Because of the abundance of Oracle database instrumentation and the wealth of data available in (say) AWR Reports, many Oracle professionals feel swamped and are uncertain how to correctly read these types of reports when trying to diagnose a performance issue. In this section, we look at both WHEN and HOW to read the various reports to very quickly and reliably determine any performance issues and so know with certainty how to apply the most appropriate solution.
We explore the following Oracle supplied database diagnostics methods and when each of them are most appropriate to determine and resolve performance issues using a methodical tuning methodology:
- Statspack Reports
- Automatic Workload Repository (AWR) Reports
- Automatic Database Diagnostic Monitor (ADDM) Reports
- Active Session History (ASH) Reports
- (Advanced) SQL Trace Files
Section Three: SQL Tuning
One of the most common reasons for poor performance is related to poorly running, inefficient SQL statements. In this section we explore in detail a number of important concepts and Oracle capabilities (up to and including Oracle Database 18c) in relation to maximising the performance and stability of SQL statements. Attendees will learn not only how to effectively tune SQL statements, but how to do so in a consistent manner to maximise both SQL performance and stability, by understanding how to determine the root cause of performance issues and hence implement the most appropriate solution to resolve any issues.
Topics covered include:
- CBO Internals And How The CBO Costs SQL Statements
- Why Is The More “Expensive” Costed SQL Often The Faster
- Differences between ALL_ROWS and FIRST_ROWS(n) optimization
- Setting Optimizer Based Parameters
- CPU Cost Model and System Statistics
- Schema Statistics Gathering Tips
- Histogram Internals
- Extended Statistics and Virtual Columns
- Dynamic Sampling
- Displaying and Reading Execution Plans
- GATHER_PLAN_STATISTICS Hint
- Managing Outlier Data
- Join Processing, Join Types and Join Methods
- Adaptive Query Optimization
- Adaptive Plans
- Cardinality Feedback
- Adaptive Statistics
- SQL Plan Directives
- SQL Blocks
- SQL Transformations
- 10053 Trace Report
- SQL Monitor Reports
- SQL Hints (and when/how to use appropriately)
- SQL Patching
- SQL Plan Stability
- SQL Profiles
- SQL Stored Outlines
- Migrating Stored Outlines to SQL Plan Management (Baselines)
- SQL Plan Management (Baselines)
- Baselines Use Cases
“Performance Diagnostics and Tuning” Webinar
Webinars run for 4 hours each day, spanning a four day period (Tuesday to Friday) in various time zones that are friendly to different parts of the world. So you can attend the webinar for part of the day and still have time for other work activities.
Webinar Booking and Payment Instructions
To book your place, please email me at email@example.com and I will send you an invoice with payment instructions. You can pay either by credit card via PayPal (you do not need a PayPal account for this), via a PayPal account or via direct bank transfer. Note: payment must be received before you can attend the webinar.
Once registered, you will be sent a unique link for each booking with instructions on how to attend the webinar. Prior to the webinar, you will also be sent a soft copy of the webinar materials, with almost 400 pages of amazing content, that includes many useful tips and strategies to effectively and reliably diagnose and address database performance issues and reliably determine and permanently address SQL performance issues.
Webinar Terms and Conditions
You are prohibited from allowing unregistered individuals to view your webinar event.
You may not make unauthorized recordings, copies, or transmissions of webinar content.
You may not make unauthorized copies or distribute in any way webinar materials.
You must view the webinar event from the country that you listed when receiving webinar registration details.
How do I register? Please contact me at firstname.lastname@example.org and I will give you all the necessary registration and payment instructions.
How much does it cost? To attend the full 4 day x 4 hours webinar series costs $1250.00 Australian Dollars. If you’re from Australia, the full cost will be $1375.00 which includes the 10% GST.
What are the payment options? You can pay either by direct bank transfer (I will provide you with all the necessary banking information) or by Credit Card (I will send you a PayPal invoice which allows for Credit Card payments. You do not need a PayPal account for this service).
Are there group discounts? Yes, if you have 3 or more persons from your organisation that is interested in attending a webinar, please contact me for group discount rates.
If my payment hasn’t come through yet, can I still join the webinar? No. For obvious reasons, I must receive full payment before you can be registered for the webinar. I try to provide plenty of prior warning before the webinars to enable obtaining managerial permission and completing payments. Please don’t leave it too late.
Can I get a refund? No. However, if you’re unable to join for some reason, you can either transfer the registration to someone else within your organisation, or you can attend a later webinar at not addition cost. Please contact me ASAP if you’re not able to attend.
Do you run customer dedicated webinars? Yes, if you have 8 or more persons in your organisation interested in attending a webinar, contact me to determine if a webinar just for your organisation might be the better option.
What are the start and end times for each webinar? They are detailed within the webinar description. All times listed are in local Australian time as I’m based in Australia. You will need to convert these times to determine your corresponding local times. Webinars are scheduled to be more favourable in different parts of the world so select the webinar series that best suits you. Note: because of time differences, the webinar could be run in a different day to those listed in your part of the world. For example, a webinar scheduled for 6-10 November 2018 starts on Tuesday, 6 November at 5am in Australia, but this is actually Monday, 5 November at 10am in San Francisco.
What is the schedule for each webinar series? Each webinar series runs for 4 days (Tuesday-Friday at the targeted time zone), with 4 hours of activity per day. Each day, there are 3 x approx. 1 hour, 10 min sessions, with a 15 minute break following each one. During the 15 minute break, there is an opportunity for further questions to be asked.
Is the material covered the same as the in person seminars? Yes, the same material is covered.
Will I be able to ask questions during the webinar? Yes. However, I will mute all connections during the webinar, with questions during the sessions possible via a texting interface. This will reduce noise issues and unnecessary questions from disrupting the presentations. I will try to answer appropriate questions during the presentations or during the 20 minute break following each presentation session. You can also ask me follow up questions after the webinar.
Do you get any webinar materials to keep? Yes. Each attendee will get a softcopy of the nearly 400 pages of content in PDF format. This will allow everyone to review all the material after the webinar and to also cut ‘n’ paste the numerous demos I cover and re-run them in your own environments. Note this material is of course copyrighted and that replicating or distributing this material is strictly prohibited.
What webinar software is used? I will be using GoToWebinar.
Are the webinars recorded? No, not initially anyways. Remember, you do have a copy of all the webinar content covered in the supplied PDF.
How do I join the webinar? I will provide full instructions on how to join the webinar beforehand. You will be given a unique link that allows you to join in the fun. Do not distribute this link to anyone else as only one connection is possible per supplied link. I recommend downloading the GoToWebinar interface (I will provide the instructions) in plenty of time prior to joining in the webinar.
When should I login to the webinar? I will start the webinar session 30 minutes prior to the official start to give everybody plenty of time to logon and iron out any issues you might have.
Are there any exercises or hands on labs? No. There are parts where I get customer participation, but there are no labs or requirements to have a database environment on hand. That said, some people do like to periodically cut ‘n’ paste some of my demos from the supplied PDFs and run them in their own database environments during the class. However, the pace I set makes this difficult to do while keeping up with the presentation.
Do I get a certificate for attending? Yes. Everyone will get a certificate of attendance.
Is there a limit to the number of attendees per webinar? Yes. To keep the webinar running smoothly and to give everyone an opportunity to ask some questions, numbers will be strictly limited.
How often are these webinars scheduled? Unsure. I will try and run a webinar series in different time zone friendly every “few months”, but this will depend largely on demand and my availability.
Is the “Oracle Indexing Internals and Best Practices” learning experience really as good as people say? Yes, it really is
For more information or to request a seminar near you, please email email@example.com.