Hello,
In Session Browser in Toad for Oracle there is a default filter called “Exclude NULL and SYSTEM OS USER”.
I would like to modify or extend this filter so that it still excludes NULL and SYSTEM OS USER sessions, but also allows me to easily identify sessions coming from FRMWEB.EXE and other non-certified programs in the Active Sessions list.
Currently it seems that the underlying filter query cannot be edited in Toad.
Is there any way to customize or override this filter so that specific programs (for example FRMWEB.EXE or other non-certified applications) can be included or highlighted in the results?
Thank you.
You can create your own filters to be used in addition to that one.
The video below will show you how
JohnDorlon Thanks for the feedback.
I understand everything. I'm just wondering if it's possible to run supported programs and unsupported programs together in active sessions. Because sometimes I can't detect problems with unsupported programs and need a quick response. Switching filters is a waste of time.
I don't know what you consider a supported vs unsupported program, but...
I see you are on Toad Version 26 R1. I made a lot of improvements to the Session Browser so it's quite flexible. Details are in this document.
Initially you said that you wanted to modify the "Include Null and SYSTEM OS Users" to include frmweb.exe and other programs" Are you saying that FRMWEB and some other programs is currently excluded by that filter and you don't want that to happen?
If so, then don't use that filter and make your own filter to use instead. Here, I have made a filter called Exclude NULL and SYSTEM OS User Unless Program is FRMWEB:
The filter text that I put it in was:
((s.USERNAME is not null) and (NVL(s.osuser,'x') <> 'SYSTEM') and (s.type <> 'BACKGROUND')) OR (upper(s.program) in ('FRMBWEB.EXE'))
....but maybe some other filter text would work better for you so that you don't have to specify program names. Maybe one of these?
s.type <> 'BACKGROUND'
(upper(s.program) not like '%ORACLE%')
Anyway, after making whatever filter you need, it will appear here in the list (also note that I've turned off the built in "null and system user" filter)
If this doesn't help you, please let me know what I'm missing. I'm not sure that that I understand your need completely.
Thank you very much for your help. I modified the script and got the result I wanted. All programs' sessions are visible in the active sessions. I corrected the script and removed the following condition (NVL(s.osuser,'x') <> 'SYSTEM').
Thank you very much.
1 Like
