RAC and Sessions window.

[Carlo Sirna]

The PL/SQL Developer Sessions view does not support RAC environments: it queries the v$XXXX views which show only the sessions running on the RAC node you have been connected to. I

To support RAC (and show all sessions running in the cluster) you simply have to switch from the v$session view to the gv$session and, in the detail views, add to the master/detail fields also the INSTANCE_ID of the selected session.

It is very easy to fix the queries by myself, (and I have been doing for years, since this fix has never been applied), but I have no way of fixing the "alter system kill session" command that is used to implement the "Kill Session" context menu (it uses just 'sid,serial' as argument, while it should use 'sid,serial,@instance_number').

So I am asking:

• Since the gv$views are available also in NON RAC environments, why doesn't PL/SQL Developer use them by default?. or at least: why aren't added by default to the list of the queries currently available?
• I can already define my custom session queries and custom detail queries... It would be nice to be able to define anche my custom context menu actions, So I could write my own "RAC-aware" Kill Session menu item.

The idea is to ad a third tab to the configuration dialog where I can define context men

 

[Marco Kalter]

I have added this to the list of enhancement requests.

 

[Carlo Sirna]

Hi, I noticed just now that I posted a draft, sorry.
1. the idea about the "third configuration tab" was about being able to define custom new context menu items for the session window, defined by pl/sql blocks. In the pl/sql blocks I could use the same variables that are available for define a custom detail query.
2. "anche" means "also", in Italian... weird error..

Thank you again

 

[Ron E]

I was just about to ask about this. Alternatively, they could have it work like their T*** competitor, and have a 'Use RAC Views' checkbox.

 

[Marcel Hoefs]

Hi Marco,

Using 13.0.6.1911. When will the kill button in the session browser be fixed so that I can use it in a RAC environment? Now this button is useless when connected to a RAC database.

RAC was introduced by Oracle in 2001 so I think making PL/SQL Developer RAC compatible is way overdue.

 

[Marco Kalter]

This is still on the list of enhancement requests.

 

[Sjoerd]

Any news on this topic - Seriously, I wasn't aware of the behavior and expected that, especially when you select one of the standard "pre-selects" called "Really all sessions" that I really would get all sessions, but no, in a RAC environment it only shows the sessions for the instance you're connected to Ok, it's easy to change the pre-selects (gv$session in stead of v$session) but it's extremely irritating that I can only "kill" sessions that are on "my" instance.
Also, it would help if you could write some filters, once the list is loaded, in stead of having to write an new "pre-select"

 

[Marco Kalter]

We will add this for version 15.0.

 

[Sjoerd]

Thanks, would really help a lot.

 

[Marcel Hoefs]

In version 14 you can define your own RAC compatible kill session command in the "actions" tab of the "Define Session Queries" window.

I agree, it is still just a workaround but at least you get rid of the annoying ORA-00026: missing or invalid session id error.