Re: 10gR2 Performance sux!

From: Alex Gorbachev <gorbyx_at_gmail.com>
Date: Fri, 15 Jun 2007 23:53:06 -0400
Message-ID: <c2213f680706152053x23c28dd1s80bc185699a2aac4@mail.gmail.com>

While you let us all shot in the dark trying to pinpoint your possible problem, why don't you trace the session, see for yourself what's the problem and go from there?
Do you think that implementing half-random recommendations would be faster?

[repost after over-quote]

On 6/15/07, Guerra, Abraham J <AGUERRA_at_amfam.com> wrote:
> Hello gurus,
>
> I'm also having performance issues with 10g. Why would my dictionary
> queries take a long time to return... in 9i they used to take seconds,
> now they take minutes or they just never come back... This happens when
> I query dba_data_files or dba_tablespaces... The application queries
> are not too bad.
>
> Any tips will be appreciated.
>
> The database is in HP-UX11,10.2.0.3, FIRST_ROWS. (Migrated from
> 9.2.0.7) PeopleSoft Financials.
>
> Thanks.
>
> Abraham

-- 
Best regards,
Alex Gorbachev, Oracle DBA Brewer, The Pythian Group
http://www.pythian.com/blogs/author/alex http://blog.oracloid.com
--
http://www.freelists.org/webpage/oracle-l

Received on Fri Jun 15 2007 - 22:53:06 CDT