package compilation

[rbrooker]

is there anyway that package compilation could be on a thread of its own? when compiling a large package, the program hangs and there is squat that you can do. likewise when rinning the compile invalid objects window, if you are compiling many packages and you switch windows, you cannot switch back until the compile is finished. this can take some time. also, you cannot monitor the progress of the compile as you cannot scroll the window while compiling.

cheers.

------------------
richard.brooker@vuw.ac.nz

 

[Marco Kalter]

Compilation is currently performed in the main thread of the application, using the main session. As a result PL/SQL Developer does not allow you to do anything else when it is compiling.

I have added an enhancement request to perform compilations in the background.

------------------
Marco Kalter
Allround Automations

[This message has been edited by mkalter (edited 05 February 2003).]

 

[rbrooker]

excellent.

cheers.

------------------
richard.brooker@vuw.ac.nz

 

[Bullitt]

go to your MS Windows start menu and open another PL/SQL Developer window.

login into the database that is currently being compiled.

Then use the TOOLS - SESSIONS menu option

find and click on your session in the list that is doing the compilation

click on the "SQL text" tab in the detail window. click refresh...

it will show you which package or object is currently being compiled.

continue to click refresh to monitor the compilation progress.

 

[rbrooker]

yes, this would work, and i have done this in the past. i thought that background compilation would be a good idea tho'.

------------------
richard.brooker@vuw.ac.nz