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

Home -> Community -> Usenet -> comp.databases.oracle -> Re: Oracle Database performance on Windows 2003 with IIS 6

Re: Oracle Database performance on Windows 2003 with IIS 6

From: Pratap <pratap_fin_at_rediffmail.com>
Date: 2 Sep 2004 22:13:00 -0700
Message-ID: <830861d2.0409022112.638a6c99@posting.google.com> 





It's a very generic question and there are no straight answer. Just a
few guidelines -



    
  
  1.   Make sure you gather statistics on tables and indexes to be used by
CBO


  
  2.   Identify the problem areas. Drill down to the screens, functions
that are having performance issues.

  
  3.   There is no generic solution to performance problems. Identify the
problem areas to the micro level and then tackle them.






Pratap
Received on Fri Sep 03 2004 - 00:13:00 CDT












Original text of this message













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