X

يمكنك إضافة المزيد من الدورات التدريبية هنا.
سيتم حفظ القائمة.

الصفحة الرئيسية دورات الإمارات العربية المتحدة دورات معتمدة من أوراكل Oracle SQL Performance Tuning Tips & Techniques

تفاصيل الدورة

The focus of this tuning course is to illustrate coding techniques that insure a consistent response time between instances and releases of the Oracle database. This course works closely with performance tuning of actual SQL statements as well as covering a variety of Oracle Server tuning topics. 

Prerequisites:
A working knowledge of SQL. A knowledge of SQL Explain Plans is helpful but not necessary.
Topics covered:
  •  How Oracle arrives at an Execution Plan
  •  Index Review/Index Statistics/How Oracle Selects Indexes
  •  Advanced problem-solving topics using V$ Table information
  •  In-depth look at Explain Plans
  •  SQL Trace/Stats Pack
  •  PL/SQL Tuning/Profiling
  •  SQL Troubleshooting/problem solving
Attendees Receive:
  •  Study guide with presentations and relevant white papers
  •  Book: Oracle SQL Tuning Pocket Reference by Mark Gurry
  •  Diskette full of tuning and problem discovery scripts
  •  Opportunity to ask the tough Oracle questions
  •  A hands-on opportunity to learn more about Oracle, SQL Developer, Eagle Eye, and TOAD
Day 1: SQL Statement Tuning:
  •  Oracle RDBMS Architecture overview
  •  Understanding/Reading/Interpreting Explain Plans
  •  Understanding the Rule-based Optimizer
  •  Understanding the Cost-based Optimizer
  •  Working with Hints
Day 2: SQL Troubleshooting Tips and Techniques:
  •  Index Review/Tips & Techniques
  •  A close look at sub-query techniques
  •  Tuning Tool Review: Statspack, Events, Tracing/Tkprof
  •  Troubleshooting SQL
  •  Profiling and tuning PL/SQL
Optional Day 3: SQL Troubleshooting Tips and Techniques (Advanced Topics):
  •  Oracle Internals: How Oracle writes 
  • Various Space Management Issues discussed
  • Monitoring Sorting
  •  Finding Problem SQL using v$ information
  •  Monitoring SQL using V$LongOps
  •  Tuning the network/Tuning the client
  •  Troubleshooting SQL
  •  Tuning by Object Placement
About Dan Hotka:
Dan Hotka is a Training Specialist who has over 30 years in the computer industry and over 25 years of experience with Oracle products. He is an internationally recognized Oracle expert with Oracle experience dating back to the Oracle V4.0 days. Dan’s latest book is the SQL Developer Handbook by Oracle Press. He is also the author of Oracle9i Development By Example and Oracle8i from Scratch by Que and has co-authored 7 other popular books including the Database Oracle10g Linux Administration by Oracle Press. He is frequently published in Oracle trade journals, and regularly speaks at Oracle conferences and user groups around the world. 
تحديث بتاريخ 08 November, 2015

الموقع

عرض الخريطة الموقع Westland Square Pearse St Dublin 2 Ireland

نبذة عن معهد Professional Training Solutions Ltd

Professional Training is a group of experienced specialists providing specific training and consultancy solutions, within Management Skills, I.T. systems, Human Restheirce Development, Credit Management, Sales, Finance and Engineering.
they believe in using a combination of tailored, flexible approaches and real-life business knowledge to develop and provide techniques and solutions for immediate implementation.
their recent projects include supporting major initiatives for clients in utilities, telecoms, manufacturing and software, covering:
restructuring for competitiveness
productivity improvements through updating work processes to match new technology
managing outstheircing
strategic financial planning and engineering
their methodology is to:
Work closely with clients to understand and help them prioritise their needs
Design and deliver the best mix of training activities and consultancy to establish the competencies required
Provide ongoing coaching to sustain the improved practices and processes
they create relevant, targeted, enjoyable, and interactive, training sessions which are designed to improve the retention of information by participants and create a clear link from the training to the workplace. This creates a planned, visible improvement in key business indicators such as productivity, motivation, loyalty, employee retention, and ultimately, profit.
their collaborative approach builds long-term relationships with clients. Together, they can deal effectively with the inevitable challenges all businesses face.
عرض الجميع دورات Professional Training Solutions Ltd
اسأل ليمون
عرض جميع دورات دورات معتمدة من أوراكل
عرض جميع الوظائف المتاحة حالياً في مجال SQL Server and Oracle في الإمارات العربية المتحدة

SQL Server أسئلة ذات صلة

Are you from Professional Training Solutions Ltd ? Claim your course!
دورات يمكنك الالتحاق بها على الفور... خذ دورة عبر الإنترنت على SQL Server ابتداءً من الآن. See all courses
عرض جميع دورات دورات معتمدة من أوراكل

هل هذه الدورة التدريبية الاختيار المناسب لك؟

قيِم هذه الصفحة

لم تجد ما كنت تبحث عنه؟

جرب البحث عنه!
أو
تصفح المقررات دورات معتمدة من أوراكل

لست واثقًا أي الدورات التدريبية تحضر؟ دعنا نرشدك