EVENT IS SPONSORED BY ONE NECK IT SOLUTIONS AND IS FREE TO ALL THANKS TO THEIR SUPPORT.
YOU CAN REGISTER BY CLICKING HERE
“Tools and Techniques to Address Performance Problems,” presented by Biju Thomas, Principal Solutions Architect, OneNeck IT Solutions
Refreshments sponsored by OneNeck IT Solutions
To RSVP for this meeting: click HERE.
Please contact firstname.lastname@example.org if your plans change, so we can order the right amount of food.
Texas state government facility (education-related) – use building Entrance C, on the east side of the building
400 East Spring Valley Road
Richardson, Texas 75081
Not everyone is an expert in tuning SQL statements or troubleshooting performance issues. There are a few basic procedures we can perform to analyze the nature of the problem and possibly to solve the problem. You will learn how to approach a performance problem and the tools to use. Tools are available to identify problem SQL, change the execution plan of SQL without rewriting the SQL, copy a good execution plan from another database, and to protect SQL plans during the upgrade. With the features and tools available in the 12c database, any DBA with determination can solve the majority of performance problems.
- Database Performance and SQL Performance
- When to use AWR
- Statistics gather and things to consider
- Tracing session and reading trace file
- Finding the execution plan
- Using SQL Tuning Advisor
- Using SQL Plan Baseline
Biju Thomas is an Oracle ACE Director, Oracle Certified Professional and Certified Oracle Database SQL Expert. He is the Principal Solutions Architect at OneNeck IT Solutions. Biju has been developing and administering Oracle databases since 1993 and Oracle EBS since 2006. He is a frequent presenter at Oracle conferences and writes articles for Oracle technical journals. He has authorized Oracle certification books published by Sybex since Oracle8i, all versions including Oracle Databse 12c OCA. Biju blogs at http://www.bijoos.com/oraclenotes and you can follow him on Twitter (@biju_thomas) or Facebook (@oraclenotes) for daily Oracle Tidbits.