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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Clarke, Andrew Sent: Friday, June 15, 2007 4:02 AM To: yoursraju007@xxxxxxxxx; amit.poddar@xxxxxxxx; 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@xxxxxxxxxxxxx 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. -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l