How to Create an Analysis View of Oracle SDE sessions broken out by client type

[Royce_Simpson]

I want to create a view that shows current Oracle SDE sessions broken out by client type (Arcmap, Pro, and Server).

I've started creating the view. I add a serial chart, and then I need to create or select a dataview. I've created a custom "database dataview," but I'm not sure I need to or that the one I created is getting me what I want. When I test the dataview, I don't see any fields for "sessions" by client. I see fields for GDB version, DB Version, Name, etc., but no "sessions"-related stuff.

Thanks for any advice or pointers to docs that explain this in detail. I see this serial chart doc, but that doesn't get to the detail I need.

Or, perhaps, is there a way to go to any given component (my oracle database), then a given metric (database sessions - arcpro), and duplicate the graph on that page over to an analysis view?

[DerekLaw]

Hi @Royce_Simpson,

> I want to create a view that shows current Oracle SDE sessions broken out by client type (Arcmap, Pro, and Server).

Unfortunately, this is not possible in ArcGIS Monitor. We don't collect a metric that distinguishes the type of clients making connections to an enterprise geodatabase. Sorry. Please submit an enhancement request on the ArcGIS Monitor Ideas forum. 

Hope this helps,

[Royce_Simpson]

Thanks for getting back @DerekLaw .

Really?  When I go to Monitoring -> Components -> myGDB Oracle Database -> Metrics, I see several metrics for "database sessions" - Arcmap, ArcPro, and ArcServer, each of which has a graph that is delivering legit-looking data.  Was hoping there was a way to recreate those in a custom view.

[DerekLaw · Accepted solution]

Hi @Royce_Simpson,

Okay, I learned something new from your post. It looks like for Oracle-based databases and geodatabases, ArcGIS Monitor reports some additional metrics, including the ones you asked about. These are not reported back from SQL Server and PostgreSQL; which is why the metrics you asked about were not documented.

> I want to create a view that shows current Oracle SDE sessions broken out by client type (Arcmap, Pro, and Server).

I've configured a serial chart to show the number of geodatabase connections, separated out by connection type,

This is the dataview expression to generate this,

 

And the configuration settings for the serial chart element,



I have also attached the exported JSON file for the sample analysis view, so you can easily import it into your ArcGIS Monitor instance, but you will have to edit the dataview expression (because mine uses component name). 

Hope this helps, 

[Royce_Simpson]

Thanks @DerekLaw Will giver 'er a go.

[DerekLaw]

Hi @Royce_Simpson,

> When I go to Monitoring -> Components -> myGDB Oracle Database -> Metrics, I see several metrics for "database sessions" - Arcmap, ArcPro, and ArcServer, each of which has a graph that is delivering legit-looking data.  Was hoping there was a way to recreate those in a custom view.

Wow, interesting. I just registered an Oracle-based enterprise geodatabase with my Monitor instance and see these metrics. When I compare against the metrics reported for a SQL Server-based enterprise geodatabase, I don't see these metrics.

I also noticed in the Register Oracle databases help topic, there's no mention of these metrics. 

Let me check into this a bit and I will post an update. Thanks for your patience.