Database Administration (MOSC)

MOSC Banner

Rest API - Oracle DB - 100% CPU

in Database Administration (MOSC) 5 commentsAnswered ✓

Hi Team,

Oracle Version 19.28

Below process id 19703 consuming 100% CPU, appeared in top processes. It calls a Fusion REST API to fetch inventory data,converting the JSON response into rows, and then aggregating those rows.

What all we can do to reduce the CPU usage. Please kindly share your ideas.

PLAN_TABLE_OUTPUT

   SID    SERIAL# USERNAME                       STATUS   SQL_ID        SPID                     PROGRAM

   971      55010 APEX_PUBLIC_USER               ACTIVE   9d5u6sthdv8v5 19703                    Oracle REST Data Services

SQL_ID 9d5u6sthdv8v5, child number 0

SELECT NVL(SUM(ITEM_PRIMARYQUANTITY),0) FROM ( SELECT
ITEMNUMBER,ORGANIZATIONCODE,INVENTORYITEMID,ORGANIZATIONID,ITEM_PRIMARYQ
UANTITY,SUBINVENTORYCODE FROM JSON_TABLE(FUSION_API_CALL(:B1 ||:B2

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

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center