ORDS, SODA & JSON in the Database

Hi All,

I implemented Oracle REST Data Service and the ords.war file is deployed to Weblogic Managed Server.

However, we got a performance issue in first access of plsql function when the Weblogic managed server or the ords application is restarted.

Steps to reproduce the issue:

1. Restart WLS_ORDS1 managed server

2. Open URL: http://host.domain:13185/pls/XXCUSTOM/

<Wait for 20 seconds to return data>

3. Open URL: http://host.domain:13185/pls/XXCUSTOM/

<Wait for 1 second to return data>

4. Open URL: http://host.domain:13185/pls/XXCUSTOM/

<Wait for 1 second to return data>

5. Restart ORDS war application

6. Open URL: http://host.domain:13185/pls/XXCUSTOM/

<Wait for 20 seconds to return data>

7. Open URL: http://host.domain:13185/pls/XXCUSTOM/

<Wait for 1 second to return data>

8. Open URL: http://host.domain:13185/pls/XXCUSTOM/

<Wait for 1 second to return data>

Any idea?

Regards,

Kenneth