Oracle Rest Data Services (ORDS) (MOSC)

MOSC Banner

ords apex - v$session

Dear Team,

We are using ords in stand alone mode and apex in our environment. We have minimum connections set to 25 and max to 350 in settings.xml

Does APEX_PUBLIC_USER use connection pool?

Max idle session timeout is high for some schemas, all these are custom application schemas. Just want to check if any parameter was set to wrong inspite of high max idle time.


SQL> SELECT
username,
status,
2 3 4 COUNT(*) AS session_count,
ROUND(MIN(last_call_et) / 60, 1) AS min_idle_min,
ROUND(MAX(last_call_et) / 60, 1) AS max_idle_min
5 6 7 FROM v$session
WHERE type = 'USER'
GROUP BY username, status

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center