nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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?

Find more posts tagged with

Accepted answers

Derek Law

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,

Geodatabase connections sample.zip

All comments

Royce_Simpson

Thanks @DerekLaw Will giver 'er a go.

Derek Law

> 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,

Geodatabase connections sample.zip

Derek Law

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.

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.

Derek Law

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,

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.