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