RE: 10gR2 Performance sux!

Exec dbms_stats.gather_dictionary_stats;

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Guerra, Abraham J Sent: Friday, June 15, 2007 10:31 AM
To: oracle-l
Subject: 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



------------------------------------------------------------------------------
NOTICE:  This electronic mail message and any attached files are confidential.  The information is exclusively for the use of the individual or entity intended as the recipient.  If you are not the intended recipient, any use, copying, printing, reviewing, retention, disclosure, distribution or forwarding of the message or any attached file is not authorized and is strictly prohibited.  If you have received this electronic mail message in error, please advise the sender by reply electronic mail immediately and permanently delete the original transmission, any attachments and any copies of this message from your computer system. Thank you.

==============================================================================

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