Oracle Application Express (MOSC)

MOSC Banner

Multi-logon question - Part 2

edited Aug 23, 2012 4:40AM in Oracle Application Express (MOSC) 9 commentsAnswered
   Hi,

I have broken the 3038788 thread with my reply. Therefore as I am not able to fix the reply, I have decided to move to this new thread.

lloon, thank you for your reply. I have read the suggested article, How to Determine which APEX user, application and page is associated with a long running database session id 732793.1 I have run the sql statement mention in this article:

select sid, serial#, client_info, client_identifier, module, action
  from v$session
where status = 'ACTIVE'
    and type <> 'BACKGROUND'
    and ouser <> 'SYSTEM';

If I run the query from APEX SQL Command window, the return sql output does not contain any information of the currently connected application users. I only get a single output line containing the following:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center