Around 6 months ago I raised an SR with Oracle pointing out the queries the then current version (4.2) was using for the various session monitor tabs were wrong in a RAC instance. I even provided the correct versions of all the queries.
Thanks for doing that. But that is the LIMIT of what you can do.
Rather than pass the information on to the SQL Developer team, it seemed the support analyst wanted to engage me in an endless cycle of discussion and testing when all I wanted him to do was pass the information on.
Sorry - but you have NO control over how a vendor responds, or even IF they respond, other than not using their product.
The forums are for helping people with problems/issues USING a product. There is NOTHING we can help you with in this forum other than the obvious - if you know the correct queries to get the info you need then run those queries yourself and/or create a report that runs them.
Then you can run that report(s) whenever you need the data.
This is really frustrating. I assumed raising an SR was the right thing to do, but they seem not in the slightest bit interested in improving the product. The lack of knowledge/understanding in the support analysts is astounding.
The ONLY place to 'vent' is directly to Oracle since they are the ONLY ones that can, if they choose, do anything about it.
The support engineers aren't secretaries, they're supposed to validate customer input before passing it on.
That being said, I'm not sure why this would be set as an enhancement request. I'm out on personal leave until tomorrow, and I'll look into this then.
Support is the proper channel for reporting bugs, and will continue to be so.
The community is for users helping users.
For the SQL Developer community, myself and quite a few developers do want to help users, so we hang out on the community. It's not an end-around on Support though.
Thanks for your persistence, we have addressed this for 17.4.
>>s there any way for us to override queries used by the Session Monitor? These incorrect queries make it next to useless for a RAC instance.
Yes. You can copy the monitor session report to a user defined report, and make it do anything you want. I talk about how to do that here.