Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Catalog access taking 10 seconds or more

Re: Catalog access taking 10 seconds or more

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Tue, 04 Apr 2006 20:01:57 +0200
Message-ID: <e0uc9n$79u$1@news6.zwoll1.ov.home.nl>


J Huntley Palmer wrote:
> Frank van Bortel wrote:

>> J Huntley Palmer wrote:
>>
>>> SELECT /*+ RULE */ '',owner,table_name,column_name,0,data_type,
>>> data_precision, decode(data_type,
>>
>> The Rule based optimizer died in 10G. Try without, with system
>> statistics, with catalog statistics.
>>

>
> Any directions would be greatly appreciated. Also this is being
> generated by some development application or the ODBC driver it uses.
>
> Thanks

What exactly do you mean by directions?
Open a SQL*Plus session, start tracing,
fire your:
SELECT '',owner,table_name,column_name,0,data_typ... and run the trace through tkprof?
(Note: NO hints!)
Or should I know how your "some development app" generates this query? Or how your ODBC driver works? What version is it anyway?
What tables are you querying - I don't care about the fields.

I'd go back to the developers; the very first field signals a misunderstanding of Oracle ('' is NULL as far as Oracle is concerned)

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...
Received on Tue Apr 04 2006 - 13:01:57 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US