RE: Stored Procedure Performance Problem --- Please Help

From: Jack C. Applewhite <japplewhite_at_inetprofit.com>
Date: Fri, 31 Aug 2001 07:28:58 -0700
Message-ID: <F001.0037F411.20010831073727@fatcity.com>

<SPAN

class=593251014-31082001>Viral,
<SPAN

class=593251014-31082001> 
Are
you saying your entire database is on one 13GB drive?  If so, it's no wonder this operation takes a very long time - you're I/O bound in a big way!  The inserts and updates of tables and indexes, not to mention disk sorts in the Temp segment, as well as rollback, redo, etc. are thrashing the heck out of that drive!
<SPAN

class=593251014-31082001> 
If you
have multiple 13GB drives, then you need to tell us more about table, index and tablespace distribution.
<SPAN

class=593251014-31082001> 
<SPAN

class=593251014-31082001>Jack

--------------------------------Jack C. 

ApplewhiteDatabase Administrator/DeveloperOCP Oracle8 DBAiNetProfit, Inc.Austin,
Texaswww.iNetProfit.comjapplewhite_at_inetprofit.com(512)327-9068

  <FONT face=Tahoma
  size=2>-----Original Message-----From: root_at_fatcity.com   [mailto:root_at_fatcity.com]On Behalf Of Viral AminSent:   Friday, August 31, 2001 9:00 AMTo: Multiple recipients of list   ORACLE-LSubject: Stored Procedure Performance Problem --- Please   Help
  Hi All,
  Hardware : Dell server - 256MB RAM, 13GB Hard Disk,   Single CPU Software : Oracle 8.1.7
  (Non-parallel server option) OS : Windows   NT 4.0 SP6
  BackGround: Following is the table structure and   record count
  <SPAN
  class=593251014-31082001> ... 
  Regards
  Viral Amin Received on Fri Aug 31 2001 - 09:28:58 CDT