 | |
Catalog access taking 10 seconds or more
comp.databases.oracle.server comp.databases.oracle.server
 |
| | Thread Tools | Display Modes |
#31
 
| |||
| |||
|
Re: Catalog access taking 10 seconds or more -
04-03-2006
, 02:19 PM
|
SELECT /*+ RULE */ '',owner,table_name,column_name,0,data_type, data_precision, decode(data_type, |
statistics, with catalog statistics.
--
Regards,
Frank van Bortel
Top-posting is one way to shut me up...
#32
| |||
| |||
|
|
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. |
generated by some development application or the ODBC driver it uses.
Thanks
#33
| |||
| |||
|
|
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 |
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...
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.