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: Solaris 9 and Orcale Performance Question

Re: Solaris 9 and Orcale Performance Question

From: chao_ping <zhuchao_at_gmail.com>
Date: 24 May 2005 07:20:52 -0700
Message-ID: <1116944452.759390.292680@g43g2000cwa.googlegroups.com> 





First, you should check the num_rows,table size, execution plan is
identical in both servers, to confirm it is solaris problem, not oracle
problem.


SQL*Plus autotrace will be great for this.



Second, in both case, you should be able to re-produce the problem. For
example, run the same query multiple times in both server.



I don't know how much more memory solaris 9 use than solaris 7, but if
oracle sga is not pagedout, then performance should not be different.
Received on Tue May 24 2005 - 09:20:52 CDT












Original text of this message













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