| Explain Plan in TOAD [message #65042] |
Tue, 06 April 2004 01:20  |
Ajendra
Messages: 165
Registered: February 2004
|
Senior Member |
|
|
Could anyone please tell me how to see the explain plan in TOAD. WHen I cick that EXPLAIN PLAN tab in TOAD. It shows me Ora-01039 insufficent privilage on underlying objects or view. And in AutoTrace it shows the following 2 tables shd have accees to Atutotrace. Sys.V$statname and sys.v$sesstat. I gave the following command in SYS user.
GRANT ALL ON V_$STATNAME TO USER1
GRANT ALL ON V_$SESSTAT TO USER1
But still Im unable to use the Auto trace or Explain Plan from TOAD.
With the same user USER1 Im able to use the Explain Plan from SQLPLUS.
Helps appreciated. Thanks
Ajendra
|
|
|
|
|
|
| Re: Explain Plan in TOAD [message #65050 is a reply to message #65047] |
Wed, 07 April 2004 02:46  |
Ajendra
Messages: 165
Registered: February 2004
|
Senior Member |
|
|
Thanks it helped but how abt the autotrace option. it shows u dun have access to the following two tables.
V_$STATNAME
V_$SESSTAT
I gave access to these tables to the user. Still it dun work. Could you please explain how does AutoTrace in TOAD helps ?
Ajendra
|
|
|
|
| Re: Explain Plan in TOAD [message #65054 is a reply to message #65050] |
Thu, 08 April 2004 13:11 |
sverch
Messages: 582
Registered: December 2000
|
Senior Member |
|
|
You can go to TOAD's Help and find out how to set up Toad environment.
From TOAD Help:
You get to this dialog via the DBA > Server Statistics menu item.
Use this dialog to view information about how the Oracle instance is performing.
This dialog is composed of the following tabs:
Analysis
To set the warning light threshold values, see How to create your TOADtempstoadstats.ini file. The following queries are required to see the Analysis information:
SYS.V_$SESS_IO
SYS.V_$SESSION
SYS.V_$PROCESS
SYS.V_$STATNAME
SYS.V_$ROWCACHE
SYS.V_$SYSSTAT
SYS.V_$SYSTEM_EVENT
SYS.V_$LIBRARYCACHE
SYS.SESSION_PRIVS
Waits
The following queries are required to see the Waits information:
SYS.V_$SYSTEM_EVENT
Latches
The following queries are required to see the Latches information:
SYS.V_$LATCH
Sessions
The following queries are required to see the Sessions information:
SYS.V_$SESS_IO
SYS.V_$SESSION
SYS.V_$PROCESS
SYS.V_$STATNAME
Instance Summary
The following queries are required to see the Instance Summary information:
SYS.V_$SYSSTAT
Locks
The following queries are required to see Locks information:
SYS.V_$LOCKED_OBJECT
SYS.ALL_OBJECTS
SYS.V_$SESSION
Quest Software
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
