Home » RDBMS Server » Server Administration » 10.2.0.4 Upgrade performance slow (Oracle Enterprise Server, 10.2.0.4, AIX 5.3 64bit)
10.2.0.4 Upgrade performance slow [message #392575] Wed, 18 March 2009 08:33 Go to next message
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
Re: 10.2.0.4 Upgrade performance slow [message #392579 is a reply to message #392575] Wed, 18 March 2009 08:58 Go to previous messageGo to next message
babuknb
Messages: 1734
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 Go to previous messageGo to next message
BlackSwan
Messages: 25033
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/
Re: 10.2.0.4 Upgrade performance slow [message #392934 is a reply to message #392583] Thu, 19 March 2009 13:06 Go to previous message
varunvir
Messages: 363
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
Previous Topic: Moving Partitions between Tables of Same Structure
Next Topic: Installing Oracle on LINUX (merged 6)
Goto Forum:
  


Current Time: Fri Dec 02 14:27:01 CST 2016

Total time taken to generate the page: 0.26782 seconds