procedure timed out?

le9569 — Wed, 18 Feb 2009 05:00:00 GMT

Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif";}

Hello Experts,

We currently have a procedure that pulls data from other databaselink. This procedure takes quite a long time (2 hours+) to process and dump the data into one table. The user gets the browser timed out. Here are my questions:

· What happens to the current procedure processing if the browser timed out or closed? Is it still running or it drops right after the browser closed?

· Is there a way to know if the proc is still running?

· If that process is running, is there a way we can kill it? By command line?

Your guidance/help is truly appreciated.

le9569

Search results matching tags 'Oracle' and 'procedure'

procedure timed out?