OraFAQ Forum: Server Administration » 10.2.0.4 Upgrade performance slow

Home » RDBMS Server » Server Administration » 10.2.0.4 Upgrade performance slow (Oracle Enterprise Server, 10.2.0.4, AIX 5.3 64bit)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

10.2.0.4 Upgrade performance slow [message #392575]

Wed, 18 March 2009 08:33

EdGrimm
Messages: 1
Registered: March 2009

Junior Member

The other day upgraded from 10.2.0.3 with some one-offs to 10.2.0.4. On the 10.2.0.3 server things run to user expectations, 4-10 second turn around on java-type reports. On the 10.2.0.4 upgrade server, the same queries are running in 55sec+.

Does anyone know of anything internal/undocumented that might have caused this. I am currently using the sqltxplain tool to gather data from both servers.

thanks in advance

Ed

Report message to a moderator

Re: 10.2.0.4 Upgrade performance slow [message #392579 is a reply to message #392575]

Wed, 18 March 2009 08:58

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

Hello,

Welcome to OraFaq !!!

It's depents your configration (from OS and database level)

Post your explain plan stat. report with SQL query; We can try to solve your issue.

Also you may need to run statspack/awr report.

PS: Don't start same thread.

Babu

[Updated on: Wed, 18 March 2009 08:59]

Report message to a moderator

Re: 10.2.0.4 Upgrade performance slow [message #392583 is a reply to message #392575]

Wed, 18 March 2009 09:10

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>On the 10.2.0.3 server things run to user expectations, 4-10 second turn around on java-type reports.
>On the 10.2.0.4 upgrade server, the same queries are running in 55sec+.

It appears you have 2 separate systems.
Prior to the upgrade how did the query run on both systems?
What is Operating System name & version on both systems?
Compare & contrast the Oracle data between the 2 systems.

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: 10.2.0.4 Upgrade performance slow [message #392934 is a reply to message #392583]

Thu, 19 March 2009 13:06

varunvir
Messages: 389
Registered: November 2007

Senior Member

Did you gather statistics after upgrading the database.If not
please gather the statistcs with dbms_Stats package.
Regards,
Varun Punj

Report message to a moderator

Previous Topic:	Moving Partitions between Tables of Same Structure
Next Topic:	Installing Oracle on LINUX (merged 6)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 01 19:50:31 CST 2024