Guidance Required on High CPU Usage Observed - 19c

Hi Team,

We are using an Oracle Database environment with APEX installed, which supports our Fusion integration. Our application code invokes various Fusion REST APIs through database procs and APEX components.

During CPU utilization alerts, we have observed that several database sessions are waiting on the event "TCP Socket (KGAS)". While this wait event itself may not indicate a database issue, we are seeing corresponding database server processes (SPIDs) intermittently consuming close to 100% CPU at the OS level. Although the CPU spikes do not persist for extended periods, they occur frequently enough to warrant investigation.

We suspect there may be an inefficiency in the way the application is invoking or processing Fusion API responses. During our analysis, we identified the following SQL statements.