Forum Stats

  • 3,814,253 Users
  • 2,258,850 Discussions
  • 7,892,637 Comments

Discussions

Default value for maximum Web Service Requests

user1175340
user1175340 Member Posts: 59
edited Sep 6, 2018 5:48AM in APEX Discussions

Hello apexers,

How can i figure out default value for the workspace "maximum Web Service Requests"?

thank you in advance!

wsr.jpg

Best Answer

  • Carsten Czarski-Oracle
    Carsten Czarski-Oracle Consulting Member of technical Staff Munich, GermanyMember Posts: 1,310 Employee
    edited Sep 6, 2018 3:44AM Answer ✓

    Hi,

    if you don't do anything, the default value will be 1000. That value applies for a rolling window of 24 hours.

    You can set a new value either at the instance level or individually for each workspace.

    Best regards

    -Carsten

«1

Answers

  • Franck N
    Franck N Member Posts: 1,019 Silver Trophy
    edited Sep 6, 2018 3:00AM

    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

  • user1175340
    user1175340 Member Posts: 59
    edited Sep 6, 2018 3:35AM

    Hi Frank,

    thanks for the quick reply.

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

  • Carsten Czarski-Oracle
    Carsten Czarski-Oracle Consulting Member of technical Staff Munich, GermanyMember Posts: 1,310 Employee
    edited Sep 6, 2018 3:44AM Answer ✓

    Hi,

    if you don't do anything, the default value will be 1000. That value applies for a rolling window of 24 hours.

    You can set a new value either at the instance level or individually for each workspace.

    Best regards

    -Carsten

  • Franck N
    Franck N Member Posts: 1,019 Silver Trophy
    edited Sep 6, 2018 3:49AM

    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

  • Carsten Czarski-Oracle
    Carsten Czarski-Oracle Consulting Member of technical Staff Munich, GermanyMember Posts: 1,310 Employee
    edited Sep 6, 2018 3:53AM

    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

  • user1175340
    user1175340 Member Posts: 59
    edited Sep 6, 2018 3:57AM
    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!!!

  • user1175340
    user1175340 Member Posts: 59
    edited Sep 6, 2018 4:04AM

    sorry another, but very related qestion,

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

  • Carsten Czarski-Oracle
    Carsten Czarski-Oracle Consulting Member of technical Staff Munich, GermanyMember Posts: 1,310 Employee
    edited Sep 6, 2018 4:19AM

    Hi,

    have a look into the APEX_WEBSERVICE_LOG view ...

    Best regards

    -Carsten

  • Pierre Yotti
    Pierre Yotti Member Posts: 4,040 Bronze Crown
    edited Sep 6, 2018 4:29AM

    Hi Carsten,

    Thanks for the useful informations.

    - I did select * from APEX_WEBSERVICE_LOG

    Bildschirmfoto 2018-09-06 um 10.26.47.png

    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

  • Carsten Czarski-Oracle
    Carsten Czarski-Oracle Consulting Member of technical Staff Munich, GermanyMember Posts: 1,310 Employee
    edited Sep 6, 2018 4:51AM

    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

This discussion has been closed.