RE: Stored Procedure Performance Problem --- Please Help

[Jack C. Applewhite]

Title: Stored Procedure Performance Problem --- Please Help

Viral,

 

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!

 

If you have multiple 13GB drives, then you need to tell us more about table, index and tablespace distribution.

 

Jack

--------------------------------
Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]
(512)327-9068

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Viral Amin
Sent: Friday, August 31, 2001 9:00 AM
To: Multiple recipients of list ORACLE-L
Subject: 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

 ... 

Regards

Viral Amin