RE: 10gR2 Performance sux!
- From: "Clarke, Andrew" <andrew.clarke@xxxxxxxxxxxxx>
- To: <yoursraju007@xxxxxxxxx>, <amit.poddar@xxxxxxxx>, "oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 15 Jun 2007 10:01:43 +0100
>> 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
Other related posts:
