RE: 10gR2 Performance sux!

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

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Clarke, Andrew Sent: Friday, June 15, 2007 4:02 AM
To: yoursraju007_at_gmail.com; amit.poddar_at_yale.edu; oracle-l Subject: RE: 10gR2 Performance sux!  

>> Well, I could not user opt_param.. as I can't touch SQLs, they come
>> from 3rd party tool. So, I have created an after login trigger to
set
>> this parameter at session level.

Dan Hotka has a presentation called "Tuning SQL when you cannot change the code!"

It could help you understand what your options are for tackling your problem. Good luck!

http://www.itcork.ie/files/eventresources/ITCorkOracle.pdf

Cheers, APC

A P Clarke
Software Architect
LogicaCMG UK Public Sector Division
Stephenson House
75 Hampstead Road
London
UK
NW1 2PL
Direct Tel: +44 (0)207 446 4006
Fax: +44 (0)207 446 1352
Email: andrew.clarke_at_logicacmg.com

This e-mail and any attachment is for authorised use by the intended recipient(s) only. It may contain proprietary material, confidential information and/or be subject to legal privilege. It should not be copied, disclosed to, retained or used by, any other party. If you are not an intended recipient then please promptly delete this e-mail and any attachment and all copies and inform the sender. Thank you.

--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l