APEX

Hi,

you can do the settings for the Maximum web Requests in the internal Workspace using the Admin credentials.

• Manage Workspaces-->Existing Workspaces--> Select your Workspace-->Edit Workspace Information--> Tab Worspace isolation.

if you have no value there then you must set it according to your requirements.

regards,

Franck

Hi Frank,

thanks for the quick reply.

Does it mean that if value is empty than web requests are unlimited?

Hi,

since it´s einable for your workspace you need to add a value there that will reset itself every 24 hours in order for it to work efficiently.

And no empty does not mean  unlimited.

regards,

Franck

Hi Franck,

what do you mean by "you need to add a value there that will reset itself every 24 hours in order for it to work efficiently" ...?

Actually set value applies to a rolling window of 24 hours. That means when a APEX_WEB_SERVICE call is being made, APEX counts the requests of the last 24 hours and compares that to the maximum value. When below, the request can succeed, if not, you'll see an error message.

APEX first looks into a workspace setting, then into the instance default.

Best regards

-Carsten

if you don't do anything, the default value will be 1000. 

Carsten, thank you for the respond.

This is exaclty what i needed to know, unfotunately i was not able to find anything about default val in the docs (if you have a link can you please share it here).

Thanks a lot!!!

sorry another, but very related qestion,

is there any api or something where we can monitor how many calls are already made?

Hi,

have a look into the APEX_WEBSERVICE_LOG view ...

Best regards

-Carsten

Hi Carsten,

Thanks for the useful informations.

- I did select * from APEX_WEBSERVICE_LOG

Here are old Request.

- Right now i call that API

https://apex.oracle.com/pls/apex/pierrealli/v2/oj/articles

and made select * from APEX_WEBSERVICE_LOG again, but the Request is not available in APEX_WEBSERVICE_LOG View.

Any Idea why?

Regards

Pierre

HI Alli-Pierre,

that view is workspace aware ...

So you need the APEX_ADMINISTRATOR role in order to see everything or you will be restricted to your workspace (and you need the APEX session context to be set up).

Best regards

-Carsten

Hi Carsten,

thanks for the quick Feedback. You can call me Pierre .

1- My schema Docker has a APEX_ADMINISTRATOR Role

2 -" and you need the APEX session context to be set up"

I create a Session like here https://docs.oracle.com/database/apex-18.1/AEAPI/APEX_SESSION.htm#AEAPI-GUID-710E9F4F-157C-4EBA-BBA9-3E0B9EE4002A

But it does not works. Can you tell me what you means with "APEX session context" or how to do that?

and APEX_WEBSERVICE_LOG View is not documented . I did not find a Documentation about that in the Doc

Thanks

Pierre