OraFAQ Forum: Client Tools » Unable ro run Explain Plan in Toad || "toad explain plan statement

Home » Other » Client Tools » Unable ro run Explain Plan in Toad || "toad explain plan statement_id too long" (Quest Toad for Oracle Version 9.5, Windows, Oracle Clinet 9i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Unable ro run Explain Plan in Toad || "toad explain plan statement_id too long" [message #475992]

Mon, 20 September 2010 08:31

oraranjangmailcom
Messages: 67
Registered: April 2010

Member

Hi,

In Plan table - statemen_id size is VARCHAR2(30) and when I did explain plan(Control+E) on a query, I got the following error "toad explain plan statement_id too long".
I cannot alter the plan table, please let me know how to modifiy the default statement_id in toad.

Thanks in Advance

Ranjan

Report message to a moderator

Re: Unable ro run Explain Plan in Toad || "toad explain plan statement_id too long" [message #475993 is a reply to message #475992]

Mon, 20 September 2010 08:32

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

can TOAD produce EXPLAIN PLAN for SQL below

SELECT SYSDATE FROM DUAL;

[Updated on: Mon, 20 September 2010 08:33]

Report message to a moderator

Re: Unable ro run Explain Plan in Toad || "toad explain plan statement_id too long" [message #475999 is a reply to message #475993]

Mon, 20 September 2010 09:48

oraranjangmailcom
Messages: 67
Registered: April 2010

Member

I got the same error for "SELECT SYSDATE FROM DUAL"

Thanks,
Ranjan

Report message to a moderator

Re: Unable ro run Explain Plan in Toad || "toad explain plan statement_id too long" [message #476001 is a reply to message #475999]

Mon, 20 September 2010 09:54

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

bcm@bcm-laptop:~$ sqlplus

SQL*Plus: Release 11.2.0.1.0 Production on Mon Sep 20 07:52:01 2010

Copyright (c) 1982, 2009, Oracle.  All rights reserved.
SQL> connect dbadmin/admindb
Connected.
SQL> set autotrace traceonly explain statistics
SQL> select sysdate from dual;


Execution Plan
----------------------------------------------------------
Plan hash value: 1388734953

-----------------------------------------------------------------
| Id  | Operation	 | Name | Rows	| Cost (%CPU)| Time	|
-----------------------------------------------------------------
|   0 | SELECT STATEMENT |	|     1 |     2   (0)| 00:00:01 |
|   1 |  FAST DUAL	 |	|     1 |     2   (0)| 00:00:01 |
-----------------------------------------------------------------


Statistics
----------------------------------------------------------
	  1  recursive calls
	  0  db block gets
	  0  consistent gets
	  0  physical reads
	  0  redo size
	530  bytes sent via SQL*Net to client
	524  bytes received via SQL*Net from client
	  2  SQL*Net roundtrips to/from client
	  0  sorts (memory)
	  0  sorts (disk)
	  1  rows processed

SQL>

Report message to a moderator

Re: Unable ro run Explain Plan in Toad || "toad explain plan statement_id too long" [message #476003 is a reply to message #476001]

Mon, 20 September 2010 10:07

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

TOAD is a bullshit.
Anyone that uses must live with its numerous bugs.

Regards
Michel

Report message to a moderator

Re: Unable ro run Explain Plan in Toad || "toad explain plan statement_id too long" [message #476021 is a reply to message #475992]

Mon, 20 September 2010 13:47

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

oraranjangmailcom wrote on Mon, 20 September 2010 15:31

I cannot alter the plan table

Do you own it? If so, then you CAN alter it.

If you don't own it (i.e. you use PLAN_TABLE's (public) synonym), then create your own table.

By the way, you never said which Oracle and TOAD versions you use.

Report message to a moderator

Previous Topic:	EXCEL preventing large numbers being displayed in scientific notation
Next Topic:	Unable to connect Error: The networ adaptercould not establish connection

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 22 06:06:20 CST 2024