|
Re: not able to execute the explain plan in development in TOAD [message #602109 is a reply to message #602104] |
Fri, 29 November 2013 09:29 |
gazzag
Messages: 1118 Registered: November 2010 Location: Bedwas, UK
|
Senior Member |
|
|
The user you are using to log into TOAD does not have privileges on its default tablespace by the sound of it. Whoever created that user should also have specified something like:
ALTER USER <username> QUOTA <quota> ON default_data;
E.g.
ALTER USER <username> QUOTA 100M ON default_data;
HTH
-g
|
|
|
Re: not able to execute the explain plan in development in TOAD [message #602126 is a reply to message #602109] |
Fri, 29 November 2013 13:12 |
Lalit Kumar B
Messages: 3174 Registered: May 2013 Location: World Wide on the Web
|
Senior Member |
|
|
I can't help you if it is just a TOAD problem. Its a third party tool.
However, if you want to check the execution plan of a SQL statement, then use SQL*Plus and execute the statement EXPLAIN PLAN FOR <your query>.
If plan table does not exist, then go to performance tuning forum, have a look at the sticky on top. Blackswan has mentioned the steps to do the needful.
|
|
|