Oracle 10g performance after upgrade from Solaris 5.8 to 5.10

From: <Joel.Patterson_at_crowley.com>
Date: Thu, 25 Feb 2010 14:28:32 -0500
Message-ID: <0684DA55864E404F8AD2E2EBDFD557DA041E09BA_at_JAXMSG01.crowley.com>

Just checking.

We are trying to track down an issue that seems to have come up all of a sudden. Some sorts to temp tablespace, and some batch jobs are taking 50 to 100% longer. Has anyone ever noticed anything like that with reference to an upgrade of the Solaris OS ? Maybe some io, or configuration parameter/issue?

Running on a Solaris OS 5.10, V880 with 1Gig full Nic, 4X1.2G CPUs, 5 Oracle instances, (2 main, 3 little) Version 10.2.0.4.0 for all. Not sure yet if all databases are affected the same way, these queries only run against one database, the little ones none, and the 2nd main database doesn't do batch jobs either, (or large sorts).

Joel Patterson
Database Administrator
904 727-2546

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

Received on Thu Feb 25 2010 - 13:28:32 CST

This message: [ Message body ]
Next message: Stephane Faroult: "Re: Faster selecting tablespace fill level"
Previous message: Oliver Jost: "RE: Performance issue after creating higher block size tablespace"
In reply to: Denis: "Re: ** ssh to copy/ftp files with compress"
Next in thread: przemolicc_at_poczta.fm: "Re: Oracle 10g performance after upgrade from Solaris 5.8 to 5.10"
Reply: przemolicc_at_poczta.fm: "Re: Oracle 10g performance after upgrade from Solaris 5.8 to 5.10"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message