CODEWITHSUNDEEP
oracle-databaseperformanceoracle-ords
joluinfante
joluinfante

Reputation: 31

About check Oracle REST Data Services (ORDS) load

In my company, we launched oracle ORDS, and we are serving 3 REST modules. But, I can't understand how to match the activity of the base with the activity of each module.

That is, I have the ords_handlers table, where in source, I have the sql that will be executed when that handler is executed, and I can associate that sql with a module, but when I see the sqls in v$sql, I am not finding how to do it the relationship.

I'm currently running ords 19.4.0, but, I'm not finding any information even going to newer versions. That is, I need to correlate the activity of the applications that use ords, with sqls that are executed in the database, in some way, to determine the load that each module produces.

Upvotes: 2

Views: 730

Answers (1)

thatjeffsmith
thatjeffsmith

Reputation: 22412

The ORDS module templates will appear as the MODULE in v and gv$session views.

My REST API with a template of 'long_running/', as defined in my 101 module:

enter image description here

Then when I call the API, if I go into v$session, I can see it appear as it's running.

enter image description here

/101/long_running/

That is the module + template of the API.

And once you have the session ID, SERIAL#...you can pull up the associated SQL of the session.

Disclaimer: I am the product manager for Oracle REST Data Services.

Upvotes: 1

Related Questions