OraFAQ Forum: Server Administration » is it good to kill/ abort a querry ,taking a lot time and resources

Home » RDBMS Server » Server Administration » is it good to kill/ abort a querry ,taking a lot time and resources

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

is it good to kill/ abort a querry ,taking a lot time and resources [message #62415]

Wed, 21 July 2004 01:39

govardhan rao
Messages: 1
Registered: July 2004

Junior Member

hello

is it good to kill/ abort the querry which takes to much of time and resources. this querry is retriving a huge amount of data. i found out the statistics it was an index scan.

pls provide the best results so that i can reduce the querry queue count to normal

Report message to a moderator

Re: is it good to kill/ abort a querry ,taking a lot time and resources [message #62455 is a reply to message #62415]

Thu, 22 July 2004 12:40

Sanjay
Messages: 236
Registered: July 2000

Senior Member

Run it thro Explian Plan first ... saves run time. Then tune the SQL.

cheers

Report message to a moderator

Previous Topic:	redo log buffer
Next Topic:	Oracle10g

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 09 04:38:25 CST 2025