Skip to main content

MarkView Admin - System Status queries return a false over-limit status in a RAC environment.

Article # 303984 - Page views: 74



Applies To

  • ERP System: Oracle, SAP
  • MarkView Version: All


  • In an Oracle RAC environment, Status Lookups which query v$session can provide misleading results. It is likely that these status queries will falsely indicate an over-limit condition. This may in turn lead to duplicate status emails being generated in error. The standard delivered Status Lookups affected are:
    • Disconnected Bar Code Server
    • Disconnected Fax Server
    • Disconnected Import Server


  • Although the v$ views continue to exist in Oracle environments where RAC is implemented, they do not span all nodes in the cluster. As a consequence, a Status Lookup query will report an over-limit condition if it runs on a different node to that where the queried program is running.


With Oracle RAC implemented, there exists gv$ views (e.g. gv$instance, gv$session) which span all nodes in the cluster. Therefore, to resolve the issue, Status Lookup queries can be modified to query the gv$session view rather than the v$session view.

For example, the original and modified query behind the Status Lookup 'Disconnected Bar Code Server' is shown below:

  • select decode(count(distinct(program)),1,0,1) from v$session where upper(program) ='MVBARSVR.EXE' -
    • original
  • select decode(count(distinct(program)),1,0,1) from gv$session where upper(program) ='MVBARSVR.EXE'
    • new

Keywords: v$session, gv$session, "status lookups", "system status"

  • Was this article helpful?