1 long query stuck all other queries
Posted by:
Jack Wang
Date: September 12, 2012 02:23AM
Hi All
my case is as below:
because of my database size, if there is a long query running.
let's say it running more than 5 hours, then all my other simple queries seems to go very slow.
could someone explain to me about this, and how to solve it?
thanks so much.
Subject
Views
Written By
Posted
1 long query stuck all other queries
2410
September 12, 2012 02:23AM
887
September 13, 2012 01:56AM
765
September 16, 2012 09:05PM
846
September 16, 2012 10:49PM
812
September 17, 2012 12:48AM
809
September 17, 2012 08:55AM
869
September 14, 2012 01:43AM
825
September 14, 2012 10:36PM
829
September 20, 2012 06:06AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.