Last updated on JULY 01, 2015
Applies to:Oracle Demand Planning - Version 22.214.171.124 and later
Information in this document applies to any platform.
***Checked for relevance on 23-Jan-2014***
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:
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)?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms