Re: 10gR2 Performance sux!

  • From: "Alex Gorbachev" <gorbyx@xxxxxxxxx>
  • To: oracle-l <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 15 Jun 2007 23:53:06 -0400

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@xxxxxxxxx> 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


Other related posts: