Home » SQL & PL/SQL » SQL & PL/SQL » Want to execute 900 query's, is there any faster way to execute (Oracle SQL Developer)
Want to execute 900 query's, is there any faster way to execute [message #670093] Mon, 04 June 2018 13:20 Go to next message
KavitaSSwami
Messages: 7
Registered: May 2018
Junior Member
I have around 900 querys, i want to execute it faster. Is there any way to execute it.
I am executing it in SQL Developer.
Re: Want to execute 900 query's, is there any faster way to execute [message #670094 is a reply to message #670093] Mon, 04 June 2018 13:40 Go to previous messageGo to next message
BlackSwan
Messages: 26648
Registered: January 2009
Location: SoCal
Senior Member
KavitaSSwami wrote on Mon, 04 June 2018 11:20
I have around 900 querys, i want to execute it faster. Is there any way to execute it.
I am executing it in SQL Developer.
We need a few more details.
http://www.orafaq.com/forum/mv/msg/84315/433888/#msg_433888
Please refer to URL above & be sure to provide the details requested:
1) DDL for all tables & indexes
2) EXPLAIN PLAN
3) output from SQL_TRACE & tkprof



Re: Want to execute 900 query's, is there any faster way to execute [message #670095 is a reply to message #670093] Mon, 04 June 2018 14:05 Go to previous messageGo to next message
Michel Cadot
Messages: 66776
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Use SQL*Plus.

Re: Want to execute 900 query's, is there any faster way to execute [message #670096 is a reply to message #670093] Mon, 04 June 2018 14:35 Go to previous messageGo to next message
John Watson
Messages: 8120
Registered: January 2010
Location: Global Village
Senior Member
Is the problem that the queries individually take too long, or that you have to run them consecutively?
Re: Want to execute 900 query's, is there any faster way to execute [message #670097 is a reply to message #670096] Mon, 04 June 2018 14:55 Go to previous messageGo to next message
KavitaSSwami
Messages: 7
Registered: May 2018
Junior Member
I have to run them consecutively
Re: Want to execute 900 query's, is there any faster way to execute [message #670098 is a reply to message #670097] Mon, 04 June 2018 15:31 Go to previous messageGo to next message
BlackSwan
Messages: 26648
Registered: January 2009
Location: SoCal
Senior Member
KavitaSSwami wrote on Mon, 04 June 2018 12:55
I have to run them consecutively
if you enable SQL_TRACE=TRUE & then run all of them.
The trace file content will report the elapsed time for each & then you concentrate tuning the longest running SQL statements
Re: Want to execute 900 query's, is there any faster way to execute [message #670099 is a reply to message #670098] Mon, 04 June 2018 19:40 Go to previous messageGo to next message
BlackSwan
Messages: 26648
Registered: January 2009
Location: SoCal
Senior Member
Below sent via PM
KavitaSSwami wrote on Mon, 04 June 2018 14:00
Where do i find SQL_TRACE in SQL Developer
Is GOOGLE broken for you? Click URL below

http://lmgtfy.com/?q=oracle+sql_trace%3Dtrue
Re: Want to execute 900 query's, is there any faster way to execute [message #670100 is a reply to message #670097] Tue, 05 June 2018 01:26 Go to previous messageGo to next message
John Watson
Messages: 8120
Registered: January 2010
Location: Global Village
Senior Member
THere are any number of possibilities. For example:
Write one SQL script that calls the 900.
Write a shell script that will run them consecutively, or concurrently if you prefer.
Use the Scheduler to run them - again, consecutively or concurrently.

How are you doing it at the moment?

Re: Want to execute 900 query's, is there any faster way to execute [message #670108 is a reply to message #670096] Wed, 06 June 2018 07:19 Go to previous messageGo to next message
gazzag
Messages: 1082
Registered: November 2010
Location: Bristol, UK
Senior Member
How long is "too long"?
Re: Want to execute 900 query's, is there any faster way to execute [message #670113 is a reply to message #670108] Wed, 06 June 2018 15:08 Go to previous message
Bill B
Messages: 1926
Registered: December 2004
Senior Member
What are you going to do with the results. If they are being loaded into a table then write a script to submit 900 scheduler jobs running the selects. The database will run up to the maximum number of job processes allowed in the database at the same time. But to give better advice, we really need to know why you need to run 900 queries. If they are similar except for key values (for example) then they can probably be combined into one massive query. Any additional information would be appreciated.
Previous Topic: Multiple tables joining
Next Topic: How to restrict IN parameter length in Procedure
Goto Forum:
  


Current Time: Sun Jan 19 20:46:12 CST 2020