Re: explain plan error in TOAD 9.0

"Ian M" <me_at_NOSPAM.com> wrote in message news:456ad937$0$336$e4fe514c_at_news.xs4all.nl...
> "Tomo" <tkokoska_at_varteks.com> wrote in message
> news:ekea85$jko$2_at_ss408.t-com.hr...
>> i'm connected to 9.2.0.1 database.
>> I've tried to run explain plan but, got ora error ora-00933: SQL command
>> not properly ended.
>>
>> plan_table is created (see script) and in menu/toad options i use
>> system.plan_table. Any idea to solve problem. TNX
>> create table SYSTEM.PLAN_TABLE (
>> statement_id varchar2(30),
>> plan_id number,
>> timestamp date,
>> remarks varchar2(4000),
>> operation varchar2(30),
>> options varchar2(255),
>> object_node varchar2(128),
>> object_owner varchar2(30),
>> object_name varchar2(30),
>> object_alias varchar2(65),
>> object_instance numeric,
>> object_type varchar2(30),
>> optimizer varchar2(255),
>> search_columns number,
>> id numeric,
>> parent_id numeric,
>> depth numeric,
>> position numeric,
>> cost numeric,
>> cardinality numeric,
>> bytes numeric,
>> other_tag varchar2(255),
>> partition_start varchar2(255),
>> partition_stop varchar2(255),
>> partition_id numeric,
>> other long,
>> distribution varchar2(30),
>> cpu_cost numeric,
>> io_cost numeric,
>> temp_space numeric,
>> access_predicates varchar2(4000),
>> filter_predicates varchar2(4000),
>> projection varchar2(4000),
>> time numeric,
>> qblock_name varchar2(30)
>> );
>>
>
> It is caused by the new editor and multiple sql statements, just
> select/highlight the sql that you want to run an explain on then click
> explain - your right enough it's annoying compared to the old method.
>

funny...we used to use toad 6.x...now we have toad 9.0 new way of calling explain plan is completly diferent..Anyway it is better!! TNX IanM Received on Tue Nov 28 2006 - 17:10:51 CET