Home » RDBMS Server » Performance Tuning » run explain plan syntax , show error (window series)
run explain plan syntax , show error [message #469039] Tue, 03 August 2010 01:26 Go to next message
JADYCHEN
Messages: 82
Registered: July 2010
Member
Hi!! All Export ,
when i runnung the explain plan syntax , show error :
running --- SELECT * FROM TABLE(dbms_xplan.display) ;
ERROR: an uncaught error in function display has happened;
please contact Oracle support
Please provide also a DMP file of the used plan table
PLAN_TABLE
ORA-00904: "OTHER_TAG": 無效的 ID

Please help me , Thanks!!
Re: run explain plan syntax , show error [message #469043 is a reply to message #469039] Tue, 03 August 2010 01:32 Go to previous messageGo to next message
rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.
Senior Member
ORA-00904: string: invalid identifier 

Cause: The column name entered is either missing or invalid. 

Action: Enter a valid column name. A valid column name must begin with a letter, 
be less than or equal to 30 characters, and consist of only alphanumeric characters 
and the special characters $, _, and #. If it contains other characters, then it must 
be enclosed in double quotation marks. It may not be a reserved word.  

Re: run explain plan syntax , show error [message #469044 is a reply to message #469043] Tue, 03 August 2010 01:33 Go to previous messageGo to next message
rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.
Senior Member
Explain plan


   set pagesize 25
   set linesize 121

   EXPLAIN PLAN FOR
   < Your Query >;


    SELECT * FROM TABLE(dbms_xplan.display);


Re: run explain plan syntax , show error [message #469045 is a reply to message #469039] Tue, 03 August 2010 01:34 Go to previous messageGo to next message
Michel Cadot
Messages: 68648
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use a plan table that is delivered with your Oracle version.
You have an old one, recreate it using $ORACLE_HOME/rdbms/admin/utlxplan.sql script

Regards
Michel
Re: run explain plan syntax , show error [message #469069 is a reply to message #469039] Tue, 03 August 2010 02:44 Go to previous message
JADYCHEN
Messages: 82
Registered: July 2010
Member
Thanks all Exports ,
This error is fix , I will go on ... Thanks!!

Thanks!! Thanks!!
Previous Topic: Need help with shared pool sizing
Next Topic: Query doesn't use Materialized View
Goto Forum:
  


Current Time: Sat May 04 05:38:27 CDT 2024