Home » SQL & PL/SQL » 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)
Unable ro run Explain Plan in Toad || "toad explain plan statement_id too long" [message #475992] Mon, 20 September 2010 08:31 Go to next message
oraranjangmailcom
Messages: 65
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
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 Go to previous messageGo to next message
BlackSwan
Messages: 23134
Registered: January 2009
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 Go to previous messageGo to next message
oraranjangmailcom
Messages: 65
Registered: April 2010
Member
I got the same error for "SELECT SYSDATE FROM DUAL"


Thanks,
Ranjan
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 Go to previous messageGo to next message
BlackSwan
Messages: 23134
Registered: January 2009
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> 
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 Go to previous messageGo to next message
Michel Cadot
Messages: 59978
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
TOAD is a bullshit.
Anyone that uses must live with its numerous bugs.

Regards
Michel
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 Go to previous message
Littlefoot
Messages: 19883
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.
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:
  


Current Time: Thu Dec 18 06:50:10 CST 2014

Total time taken to generate the page: 0.06306 seconds