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 -> scheduling stored procedures to run as jobs

scheduling stored procedures to run as jobs

From: Fith <pfith_at_ibm.net>
Date: Mon, 12 Apr 1999 13:31:09 +0100
Message-ID: <37123c46@news3.us.ibm.net>


Does anyone know why a procedure that runs from SQL+ (when executed manually) in around 38 minutes without affecting the processor much would max out the processor and take over 6 hours when scheduled as a job (through the enterprise manager)? I'm using version 7.3.3.

Thanks. Received on Mon Apr 12 1999 - 07:31:09 CDT

Original text of this message

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