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!

Monitor Sessions not showing current sql

EdStevensJul 27 2017 — edited Sep 26 2017

SQL Dev 17.2.0.188 64-bit on Win7 Pro

Am doing side-by-side comparisons between SQL Dev and SQL Navigator, hopeing to be able to drop SQL Nav and save the money.

As one test I have a somewhat long running PL/SQL script that performs several sql statements, and also calls some stored procedures which of course have their own activity. While this is running (from sql plus, at a command line, not within either product) I put SQL Dev on one screen and SQL Nav on the other.  In each I open their respective session browser tool and select the test session, and the 'current sql' tab.  Set both to auto-refresh the view every 10 seconds.  What I see is that SQL Nav will show a sql statement, while at the very same time SQL Dev reports "No text available".  I can watch each "blink" when it refreshes the view, within 1 second of each other, and consistently SQL Nav will show me some sql from my test session, while SQL Dev continues to insist "No text available"  In both products I am connected to the database with the same account, having the DBA role.

This post has been answered by thatJeffSmith-Oracle on Jul 28 2017
Jump to Answer

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 27 2017
Added on Jul 27 2017
7 comments
2,082 views