Re: 10gr2 Catalog access issues

J Huntley Palmer wrote:
> From the time I upgraded to 10gr2 on SPARC SOL9, I have run into oracle
> process hitting the ceiling in processor usage when developer
> applications such as MS Access or reporting programs like Crystal
> Reports accesses catalog related info such as column names and types
> through ODBC. Regular queries from user data tables are a quick.
> Oracle: Release 10.2.0.1.0 (SPARC)
>
> Why is this?

Have no idea. Have you used DBMS_STATS to generate statistics for the optimizer? Whose ODBC driver are you using? Have you run explain plans?

You should not be using Crystal with an ODBC driver. Use the native Oracle driver that comes with Crystal.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)