Home » SQL & PL/SQL » SQL & PL/SQL » Sql query taking long time to execut
Sql query taking long time to execut [message #676210] Tue, 21 May 2019 02:20 Go to next message
haider_1pk
Messages: 135
Registered: March 2009
Location: PAKISTAN
Senior Member
Hello friend,


Sql query taking long time to execute in oracle. Kindly guide me .
How solved this problem.

Regards

Haider
Re: Sql query taking long time to execut [message #676212 is a reply to message #676210] Tue, 21 May 2019 02:57 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
You'd find out what the query is spending it's time doing by looking at the explain plan / execution plan / tkprof of a session trace.
You'd then change the query / add indexes / make other changes.

If you want a more specific answer I suggest you post the query along with an execution plan.
Re: Sql query taking long time to execut [message #676217 is a reply to message #676212] Tue, 21 May 2019 06:37 Go to previous message
Bill B
Messages: 1971
Registered: December 2004
Senior Member
It is Really hard to work on a query without knowing what the query is, table and index information and an execution plan.
Previous Topic: minus query using dblink
Next Topic: Help in building a Query
Goto Forum:
  


Current Time: Thu Mar 28 15:33:22 CDT 2024