2 Replies Latest reply on Aug 7, 2018 4:55 AM by MaxOrgiyan-Oracle

    JSON GET_KEYS performance issue

    AnandKumar

      Hi All,

       

      When we are using JSON GET_KEYS to validate JSON data, CPU is going to 100% and memory is leaking. The RES memory in top command grows exponentially and database is not responding. 

       

      When we reduce the number of elements in the JSON data, we managed to execute the procedure without any issues. We have attached the Working and not working JSON files and procedure to simulate. The procedures are attached. We suspect the issue occurs when there are multiple nested JSON. 

       

      In our case there are 4 levels,

      riskcoverdtls1001

         "vehicledetails1001"

              "applicableproducts"

                    "policy"

      1. If we remove policy attribute or if we have very less elements in policy attributes, proc is working.

      2. 4th level policy has got 136 elements. if we give all 136 elements it is failing.

       

      https://drive.google.com/file/d/0Byv486cjpefiSG9OYkpGTHhhOXZLbms4bHU0VVJ0T1lEN2JZ/view?usp=drivesdk

       

      Regards,

      Anand.