# SQL Nav 6.2 - Problem on "Session Browser"

**URL:** <https://forums.toadworld.com/t/sql-nav-6-2-problem-on-session-browser/3933>\
**Category:** SQL Navigator\
**Created:** [August 26, 2009, 8:26am UTC](https://forums.toadworld.com/t/sql-nav-6-2-problem-on-session-browser/3933 "2009-08-26T08:26:10Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![andrea.danieli\_515](https://avatars.discourse-cdn.com/v4/letter/a/e19b73/32.png) [@andrea.danieli\_515](https://forums.toadworld.com/u/andrea.danieli_515)\
**Post date:** [August 26, 2009, 8:26am UTC](https://forums.toadworld.com/t/sql-nav-6-2-problem-on-session-browser/3933/1 "2009-08-26T08:26:10Z")

</div>

Hello,

I have problems on Session Browser.  
It is working, but I cannot see some session belonging to a specific program (frmweb.exe).  
There are no filter neither further selection and I cannot understand why not all sessions are visible on Session Browser. (Please, see Image1 for session browser and Image2 for list of all sessions in the Oracle instance).

Please can you give me some advice to solve the problem?

Thanks in advance.  
Best regards

Andrea  
 ![sqlserver_alter.png](https://global.discourse-cdn.com/quest/original/1X/206fbeb8d087bf7f899d8288004ea07d715fddd2.png)

---

<div class="post-metadata">

**Author:** ![Gwen](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/gwen/32/75_2.png) [@Gwen](https://forums.toadworld.com/u/Gwen)\
**Post date:** [August 31, 2009, 2:35am UTC](https://forums.toadworld.com/t/sql-nav-6-2-problem-on-session-browser/3933/2 "2009-08-31T02:35:48Z")

</div>

SELECT S.SchemaName,

S.UserName,

S.STATUS,

S.SERVER,

S.SID,

S.SERIAL#,

S.AUDSID,

S.OSUSER,

S.MACHINE,

S.TERMINAL,

UPPER (S.PROGRAM) PROGRAM,

S.TYPE,

S.PADDR,

S.TADDR,

S.LOGON\_TIME,

S.MODULE,

S.ACTION,

S.CLIENT\_INFO,

S.LAST\_CALL\_ET,

S.INST\_ID

FROM GV$SESSION S

WHERE ( (S.USERNAME IS NOT NULL)

AND (NVL(s.osuser,‘x’) \<\> ‘SYSTEM’)

AND (S.TYPE \<\> ‘BACKGROUND’)

)

By default, we ignored the sessions that was created by Oracle database(System). We can raise a CR to add a preference to include these.

Gwen

Hi Andrea,

The query fired by Nav is as follow:  
ORDER BY “PROGRAM”, OWNERID;

---

<div class="post-metadata">

**Author:** ![andrea.danieli\_515](https://avatars.discourse-cdn.com/v4/letter/a/e19b73/32.png) [@andrea.danieli\_515](https://forums.toadworld.com/u/andrea.danieli_515)\
**Post date:** [September 1, 2009, 2:53am UTC](https://forums.toadworld.com/t/sql-nav-6-2-problem-on-session-browser/3933/3 "2009-09-01T02:53:10Z")

</div>

Hi Gwen,

yes, if possible it will be really GREAT!

Thanks for your help.

Best regards  
Andrea