Home » SQL & PL/SQL » SQL & PL/SQL » Oracle Job which calls a stored procedure taking too much time (Oracle 10g)
Oracle Job which calls a stored procedure taking too much time [message #360917] Mon, 24 November 2008 06:15 Go to next message
krishnamohanpnv
Messages: 4
Registered: November 2008
Junior Member
Hello all,

I have a stored procedure which is having around 32 select into statements and 2 insert , update statements which update a table with the values from the above select statements.
I have individually executed the queries and all the script at once and in all these cases the queries are not taking more than 30sec.
But When I created a job which calls the above stored procedure the job is getting failed and even if it runs also it is taking too much of time. So please suggest me where should I analyze more regardint this.

Thanks
Krishna Mohan
Re: Oracle Job which calls a stored procedure taking too much time [message #360946 is a reply to message #360917] Mon, 24 November 2008 07:32 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Have a look in the alert log and see what error the script failed with.

Add code to the procedure to record the time at which it starts and finishes each section - that will show you where the slow part of the procedure is.
Previous Topic: Simplify the Query
Next Topic: Need procedure to display all the rows
Goto Forum:
  


Current Time: Mon Dec 05 02:34:17 CST 2016

Total time taken to generate the page: 0.10464 seconds