Forum Stats

  • 3,733,750 Users
  • 2,246,814 Discussions
  • 7,856,864 Comments

Discussions

SQLDeveloper - slow execution of large script

user7425388
user7425388 Member Posts: 1 Green Ribbon
edited March 26 in SQL Developer

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

Answers

  • Gaurav Nagpal
    Gaurav Nagpal Member Posts: 49 Blue Ribbon

    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
    thatJeffSmith-Oracle Distinguished Product Manager Posts: 7,691 Employee

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


    Minimize the output panel.

    Consider sqlcl as an alternative.

  • user13437551
    user13437551 Member Posts: 0 Green Ribbon

    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
    thatJeffSmith-Oracle Distinguished Product Manager Posts: 7,691 Employee

    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.

Sign In or Register to comment.