- 3,733,742 Users
- 2,246,813 Discussions
- 7,856,862 Comments
Forum Stats
Discussions
Howdy, Stranger!
Categories
- 380.9K All Categories
- 2.1K Data
- 203 Big Data Appliance
- 1.9K Data Science
- 446.1K Databases
- 220.4K General Database Discussions
- 3.7K Java and JavaScript in the Database
- 22 Multilingual Engine
- 506 MySQL Community Space
- 459 NoSQL Database
- 7.7K Oracle Database Express Edition (XE)
- 2.8K ORDS, SODA & JSON in the Database
- 438 SQLcl
- 3.9K SQL Developer Data Modeler
- 185.4K SQL & PL/SQL
- 20.8K SQL Developer
- 291.3K Development
- 6 Developer Projects
- 117 Programming Languages
- 288K Development Tools
- 96 DevOps
- 3K QA/Testing
- 645.2K Java
- 18 Java Learning Subscription
- 36.9K Database Connectivity
- 148 Java Community Process
- 104 Java 25
- 22.1K Java APIs
- 137.7K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 12 Java Essentials
- 138 Java 8 Questions
- 85.9K Java Programming
- 79 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.2K Java SE
- 13.8K Java Security
- 195 Java User Groups
- 22 JavaScript - Nashorn
- Programs
- 177 LiveLabs
- 34 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 165 Deutsche Oracle Community
- 1.2K Español
- 1.9K Japanese
- 225 Portuguese
SQLDeveloper - slow execution of large script
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
-
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.
-
Just @script.sql the file vs actually opening it.
Minimize the output panel.
Consider sqlcl as an alternative.
-
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.
-
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.
