Home » RDBMS Server » Performance Tuning » Explain plan (oracle 10g windows 7)
Explain plan [message #632329] Thu, 29 January 2015 02:07 Go to next message
hdba
Messages: 16
Registered: January 2015
Location: INDIA
Junior Member
Using explain plan how to check performance of query
can you give any good example.

i tried but get confused
Re: Explain plan [message #632330 is a reply to message #632329] Thu, 29 January 2015 02:18 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Perhaps posting the query, the plan, all other relevant details, and saying what it is that you find confusing would be a good start.
Re: Explain plan [message #632331 is a reply to message #632329] Thu, 29 January 2015 02:18 Go to previous messageGo to next message
Roachcoach
Messages: 1576
Registered: May 2010
Location: UK
Senior Member
Not really, because you can't check performance based on that.

Query performance come down to one thing - acceptable resource consumption and those resources are: time, IO, memory and CPU cycles.

Most often end users complain about time - if that is the case then you need work out where it is spending its time and fix that. If we are to assist, please post the data in the sticky at the top of this forum. Explain plan alone isn't going to give you this information.
Re: Explain plan [message #632332 is a reply to message #632329] Thu, 29 January 2015 02:24 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Performance Tuning Guide
Chapter 19 Using EXPLAIN PLAN

Re: Explain plan [message #632346 is a reply to message #632330] Thu, 29 January 2015 04:22 Go to previous messageGo to next message
hdba
Messages: 16
Registered: January 2015
Location: INDIA
Junior Member
as i am new to oracle dba job so not deep knowledge about this all things i refer this all things by myself only.

hope you all can guide me well.

thanx a lot
Re: Explain plan [message #632347 is a reply to message #632346] Thu, 29 January 2015 04:25 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

First read the documentation.

Re: Explain plan [message #632348 is a reply to message #632329] Thu, 29 January 2015 04:54 Go to previous messageGo to next message
hdba
Messages: 16
Registered: January 2015
Location: INDIA
Junior Member
yes i am doing that only.

is there any site who provide example with screen shots so i can get better idea about that topic
Re: Explain plan [message #632351 is a reply to message #632348] Thu, 29 January 2015 05:14 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
I recorded this a couple of months ago:
Oracle-SQL-Tuning-Execution-Plans-for-Beginners
Re: Explain plan [message #632354 is a reply to message #632351] Thu, 29 January 2015 05:54 Go to previous messageGo to next message
hdba
Messages: 16
Registered: January 2015
Location: INDIA
Junior Member
ohk thanx a lot sir...

and on performance tuning which topics are more important to refer as i am fresher dba so not that much idea

hope you can guide well
Re: Explain plan [message #632355 is a reply to message #632354] Thu, 29 January 2015 06:19 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

- Performances Tuning sticky
- OraFAQ Performance Tuning
- Rosco's SQL Tuning Guide
- Tuning High-Volume SQL Wiki page

You can also have a look at Database Performance Tuning Guide.

Re: Explain plan [message #632356 is a reply to message #632355] Thu, 29 January 2015 06:26 Go to previous message
hdba
Messages: 16
Registered: January 2015
Location: INDIA
Junior Member
ohk sure thanx a lot sir
Previous Topic: What should be recommended percentage of memory to be used for oracle
Next Topic: what is ** TRANSIENT: 12029568
Goto Forum:
  


Current Time: Thu Mar 28 08:23:41 CDT 2024