Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Why Is SQL*Developer Running Queries In the Background?

user10527903Mar 25 2022

I have users complaining about response time for queries, even simple ones, such as "describe objectl", within the query pane. When we examine the statements log, we find that such a single query can generate numerous statements, some of which run for a very long time, since they are querying dictionary views that are quite large. This happens very often, with a number of activities, making it very difficult to use the product.
Screen Shot 2022-03-23 at 1.10.46 PM.png (1.97 MB)Screen Shot 2022-03-23 at 12.48.16 PM.png (2 MB)

Comments
Post Details
Added on Mar 25 2022
8 comments
1,096 views