Sydney Oracle Meetup

101 Ways to get SQL Execution Plan. What is the best option to use?

Apr 9 Fri 5:30 PM

Location: Sydney Mechanics’ School of Arts

Level 1, 280 Pitt Street
Sydney 02 9262 7300

This is a private home or office

Attendance: 28 people attended.
4.506 (6 ratings)
Who organized?
Yury Velikanov

This is Development & Performance tuning related topic.

We are planning to start Performance related discussion from the beginning.
And it is getting a SQL Execution plan from Oracle DB.
There are so many ways doing that (Trace - 10006, explan plan for, autotrace, v$ dynamic views).
What is the best option? What way is the best in what case?
What are our members experience in that area?

The content to be confirmed.

Photos of this Meetup

See all photos

Talk about this Meetup

Who attended?

28 attendees
- Andrew Jackson
  
  “ The presentation wandered a little and was longer than scheduled. I found a number of interesting points in it. It would be good to have a timekeeper attempt to keep it on schedule. ”
- Nuno Pinto do Souto
  
  “ Great discussion and exchange of ideas on methods to obtain a correct and effective plan. ”
- Paul Guerin
  
  “ Found new ways to determine the plan.... ”
- Nick Kavadias
  
  “ Great content. IMHO it should have been finished by 8PM, either by starting earlier or being shorter. ”
- nick patten
  
  “ excellent! There's so much more to this topic than meets the eye. Another couple of presentations/discussions. Well worth a look at the presentations when they get posted.. ”
- Casey Dyke
- Fiona
- Patty Gardiner
- Franko Elisha
- Serge Stadnichenko
- Yury Velikanov
- Truong Phan (+2 guests)
- Sebas
- Martin Wisniewski
- Arun Birla
- Frank Cheung
- Patrick Hicks
- Theepan Velayuthan
- Philip Tao
- Richard Burakowski
- Steve Tran
- Jacky Yuan
- Sajeev Gopinath
- Ana Lima