RE: 10gR2 Performance sux!

  • From: "Elliott, Patrick" <patrick.elliott@xxxxxxxxxxxxx>
  • To: <AGUERRA@xxxxxxxxx>, "oracle-l" <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 15 Jun 2007 10:49:15 -0500

You might need to analyze the system tables.  You can do that now in
10g.  You also need to make sure the dbms_scheduler has an automated job
that is computing your stats for you.  


Pat

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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@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



___________________________________________________________________________________________________
CONFIDENTIALITY AND PRIVACY NOTICE
Information transmitted by this email is proprietary to Medtronic and is 
intended for use only by the individual or entity to which it is addressed, and 
may contain information that is private, privileged, confidential or exempt 
from disclosure under applicable law. If you are not the intended recipient or 
it appears that this mail has been forwarded to you without proper authority, 
you are notified that any use or dissemination of this information in any 
manner is strictly prohibited. In such cases, please delete this mail from your 
records.

To view this notice in other languages you can either select the following link 
or manually copy and paste the link into the address bar of a web browser: 
http://emaildisclaimer.medtronic.com
--
//www.freelists.org/webpage/oracle-l


Other related posts: