SQLDeveloper - slow execution of large script

user7425388

Hello,

I've quite large SQL script (~11MB) which creates database objects (tables, procedures, functions)

Because script is automatically generated all procedures and function in script are created in alphabetalical order. That's why during script execution I have a lot compiler errors which is totally ok, since at the end of the script I compile all database objects.

Problem is that creation of each procedure/function in SQLDeveloper takes around 5-10 second for each procedure. I think problem is related to fact that SQLDeveloper shows me details of compilation error which I don't need at these time.

Function DPsp_EvalSl compiled

LINE/COL ERROR

----------------------------------------------

21/15 PL/SQL: ORA-00904: "DPsp_Val": invalid identifier

23/17 PL/SQL: ORA-00904: "DPsp_WalSopA": invalid identifier

Errors: check compiler log.

Is there any option in SQLDeveloper to turn off detailed compiler log and speed up execution process a little ?

Regards

Gaurav Nagpal

Please try with SQL*Plus. Should be quick.

Don't forget to write at the end

Spool off

SET TERM ON

SET ECHO ON

EXIT;

At start, it should be like

ACCEPT db_service Prompt "ENTER Database Name(R12PDEV): "

Prompt

COLUMN RUNDATETIMES FORMAT A50

SET HEADING OFF

SET PAGESIZE 1000

SET LINESIZE 125

SET ECHO OFF

SET TERM OFF

Thank you.

Gaurav Nagpal.

thatJeffSmith-Oracle

Just @script.sql the file vs actually opening it.

Minimize the output panel.

Consider sqlcl as an alternative.

user13437551

I don't know if this is the same situation, sometimes my SQL Developer hangs when I am running a query. I will have to close it using ALT,CTRL&DELETE.

thatJeffSmith-Oracle

No, most likely not the same issue. When the UI freezes, grab a jstack dump of the sqldev process and post here as a new thread for someone to take a look at - assuming you don't have access to My Oracle Support.