Home » RDBMS Server » Performance Tuning » Explain Plan in TOAD
Explain Plan in TOAD [message #65042] Tue, 06 April 2004 01:20 Go to next message
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 #65047 is a reply to message #65042] Tue, 06 April 2004 07:32 Go to previous messageGo to next message
sverch
Messages: 582
Registered: December 2000
Senior Member
From TOAD Help:

Explain plan will not work unless you first run the TOADPREP.SQL script.
Re: Explain Plan in TOAD [message #65050 is a reply to message #65047] Wed, 07 April 2004 02:46 Go to previous messageGo to next message
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 Go to previous message
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
Previous Topic: High overhead on DBA_SEGMENTS
Next Topic: DBA_SEGMENTS Alternate code?
Goto Forum:
  


Current Time: Fri Mar 29 01:58:13 CDT 2024