Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Performance Problems on Oracle 7.3.2.3 after HPUX 10.20 upgrade

Re: Performance Problems on Oracle 7.3.2.3 after HPUX 10.20 upgrade

From: Joel Garry <joelga_at_pebble.org>
Date: Wed, 17 Jun 1998 23:16:40 GMT
Message-Id: <slrn6ogjtu.k3v.joelga@pebble.org>


On 17 Jun 1998 17:23:11 GMT, Linda Montgomery <montgolh_at_jmu.edu> wrote:
>We just upgraded to HPUX 10.20 from 10.10 and are
>seeing extreme slowdowns in response times. The
>Unix version was the only change made. Oracle
>version is 7.3.2.3, same as it was on 10.10.
>There is no apparent problem in the Oracle database
>based on all the performance monitoring we have
>done, and the slow response times are seen in more
>than just one instance on that machine, by many users, excuting various
>queries. The only clue we see is that the index tablespace datafile
>is getting sustained high disk read rates on every
>query against the database, but that may be
>perfectly normal.

Have you rebuilt any of these indices lately? It could just be normal unbalancing over time.

>
>Our Unix Admins think all the unix parameters are
>the same as they were before, and the init.ora
>files are unchanged.
>
>Has anyone else experience this problem?? OR can
>anyone suggest where we can look for answers??
>

--
These opinions are my own and not necessarily those of Information Quest

or Pebble In The Sky                     http://www.informationquest.com

http://ourworld.compuserve.com/homepages/joel_garry jgarry@nospameiq.com
"See your DBA?"  I AM the @#%*& DBA!     Remove nospam to reply.  Sorry.
Received on Wed Jun 17 1998 - 18:16:40 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US