How to better track processes with stuck/excessive threads

Summary: During Close activities, we've often had latency issues where Oracle support comes back saying it's related to stuck threads or few processes running too many threads, often on the HCM side (but effecting us on the finance side).

Content (please ensure you mask any confidential information): Latency

Version (include the version you are using, if applicable): 23C (soon to be 23D)

Code Snippet (add any code snippets that support your topic, if applicable): N/A