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.
--
http://www.freelists.org/webpage/oracle-l

Other related posts: