Oracle Job which calls a stored procedure taking too much time [message #360917] |
Mon, 24 November 2008 06:15  |
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
|
|
|
|