Toad World® Forums

SQL Nav 6.2 - Problem on "Session Browser"


#1

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


#2

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;


#3

Hi Gwen,

yes, if possible it will be really GREAT!

Thanks for your help.

Best regards
Andrea