Menu
suddenly my update queries are not executing . i can make select queries but when i try to update records the database hangs infinitly. i tried even from sql plus and nothing happens.
742
On a large table this could take a long time either way, maybe even longer than the 4 or 5 minutes you're seeing. Once the data is retrieved, the temporary index would be dropped in the background. When you do another query, Oracle needs to build a new temporary index, which is why it takes that long for every query.
If you are running a query and it's slow, it could benefit from indexes. Indexes are often the most useful when created on columns as part of the Join clause and the Where clause. So, check which columns are used there, check if they have indexes, and create them if they don't.
The most common causes of slow performance are as follows: Excessive round-trips from the application server to the database. Ideally, each UI operation should require exactly one round-trip to the database. Sometimes, the framework will require additional round-trips to retrieve and make session data persistent.
Most likely you have another open uncommitted transaction for the same set of records, so they are locked for that transaction.
And, most likely, you locked them, running the same UPDATE in another transaction.
Just Commit/rollback your transactions, you should be fine.
168
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
