Why Is The Session Status In Session Manager Shown As Active Or Inactive? (Doc ID 465555.1)

Last updated on JULY 01, 2015

Applies to:

Oracle Demand Planning - Version 11.5.10.2 and later
Information in this document applies to any platform.
***Checked for relevance on 23-Jan-2014***


Goal

Log in as Demand Planning System Administrator and choose System Administrator.  From there you can see the status of the sessions for a particular plan.  But it is not clear what the statuses represent.

While a planner is opening DP workbench (still not opened) the session status is ACTIVE. But when the DP workbench has opened and the planner works on it, the session status is displayed as INACTIVE.

When planner clicks on Save to save his updates, then the session status changes to ACTIVE for a few seconds. After the save has completed, the status is again INACTIVE.

Using the following SQL to check sessions:

select ''''||session_id||', '||serial#||'''' sessionid, attach_mode, a.awname
from v$aw_olap,sys.aw$ a, v$session s
where v$aw_olap.aw_number = a.awseq# and session_id = s.sid;


you can see that there is READ WRITE session for user in SQL, however in session manager, the sessions status is INACTIVE.

How is the session status calculated?
How does the administrator see the difference between a hung session (status INACTIVE) and working session (status also INACTIVE)?

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms