EM 13c: Results from Enterprise Manager 13c Cloud Control Search Sessions (Search for SID) shows one Result for a CLuster Database
Last updated on JANUARY 24, 2018
Applies to:Enterprise Manager for Oracle Database - Version 188.8.131.52.0 and later
Information in this document applies to any platform.
Enterprise Manager (EM) 13.2 Cloud Control
Navigate: Targets > Databases > [select Cluster Database target link] > [expand Performance drop down menu] > Search Sessions > Specify Search Criteria > [select Filter=SID, provide SID name]
The search displays only one result in the search for SID from a cluster database.
If you have processes running on two different instances of the RAC database, with the same SID, the search for SID will display the result from one instance only. The result does not display both of the processes as you would assume.
However, if you check the same thing using SQL*Plus, connect to the cluster database and querying gv$session, it returns the correct values.
1* select inst_id, sid, serial#, process, status from gv$session order by 2 desc
INST_ID SID SERIAL# PROCESS STATUS
2 2004 38024 7444 ACTIVE
2 2000 21760 21839 ACTIVE
2 1997 50444 6004 INACTIVE
2 1996 54457 3284 ACTIVE
1 1996 5708 26129 ACTIVE
This query returns SID# 1996 running on instances 1 and 2, but in EM 13.2 Cloud Control, it displays only one instance.
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