Allow Hostnames
|
Enter a comma separated list of hostnames
that can be used to access this workspace. If you leave
this attribute empty, the instance-level value applies.
If you enter one or more hostnames, the incoming HTTP
request URL's hostname part must match one of the listed
hostnames.
For example, you can register the DNS alias
hr.example.com for your web server
www.example.com . If you set the HR
workspace's Allow Hostnames to
hr.example.com , users have to
access HR applications using
hr.example.com and all other
applications of this instance
usingwww.example.com . With this
configuration, the browser's Same
Origin security policy provides a client-side
barrier between HR applications and other applications
of the instance, which run in another browser tab or
window.
If your workspace uses RESTful services, you
have to additionally configure a pool in the
url-mapping.xml configuration file
of Oracle REST Data Services for isolation. Note that
Oracle REST Data Services will ignore the
RESTful Path Prefix workspace
attribute if Allow Hostnames is
configured.
The configuration example below specifies
that RESTful services of the HR workspace can only be
accessed using
https://hr.example.com/apex/resource-handler :
<pool
base-url="https://hr.example.com/apex" name="apex"
workspace-id="hr" />
|
Resource Consumer
Group |
Specify the Database Resource Manager
consumer group to be used for all page events associated
with this workspace. If you leave this attribute empty,
the instance level value applies. The Resource Consumer
Group provides more control of hardware resources such
as CPU and I/O requests. Workspace-level settings
override instance-level settings to enable
administrators to provide more or less resources
depending on the needs or importance of a workspace.
At the beginning of every request, the
Application Express engine switches the current consumer
group of the current database session to the consumer
group that is defined at workspace or instance-level.
This applies to both executing applications and any of
the applications used within the Application Express
development environment.
These limitations apply to all page
requests, where application code executes using the
Application Express engine which enables the assigned
Resource Manager settings. However, they do not apply to
Oracle Scheduler jobs that workspace developers create,
or to ORDS REST requests, where Application Express is
not in the code path.
A call to set the workspace, such as
apex_util.set_workspace('MY_WORKSPACE');
at the beginning of the scheduler job, enables the right
consumer group. However, there is often no reason for
developers to add this type call. Therefore,
administrators should apply the Resource Manager
consumer groups both to Application Express workspaces
and to the workspace schemas (that is, the underlying
database users).
You must grant privilege to switch to a
consumer group to either PUBLIC or the
Application Express schema. This privilege is typically
granted using the procedure
DBMS_RESOURCE_MANAGER_PRIVS.GRANT_SWITCH_CONSUMER_GROUP .
See Also: "Managing Resources with Oracle Database Resource
Manager" in Oracle Database
Administrator’s Guide
|
|
Maximum
Concurrent Workspace Requests |
Enter the maximum number of concurrent page
events that Oracle Application Express supports for all
applications of this workspace. If you leave this
attribute empty, the instance-level value applies.
Instead of processing a page event, Application Express
shows an error message when the limit is already
reached.
Application Express keeps track of session
requests by querying the CLIENT_INFO
column of GV$SESSION . This tracking
will not work if developers overwrite
CLIENT_INFO , for example, with a
call to
DBMS_APPLICATION_INFO.SET_CLIENT_INFO .
|
Maximum
Concurrent Session Requests |
Enter the maximum number of concurrent page
events that Oracle Application Express supports for each
session for applications in this workspace. Instead of
processing a new page event, Application Express shows
an error message when the limit is already reached.
Alternatively, use the Concurrent Session Requests Kill
Timeout attribute to kill an active database session, to
process the new page event.
Application Express keeps track of session
requests by querying the
CLIENT_IDENTIFIER column of
GV$SESSION . This tracking will not
work if developers overwrite
CLIENT_IDENTIFIER , for example with
a call to
DBMS_SESSION.SET_IDENTIFIER .
|
Concurrent
Session Requests Kill Timeout |
If a new page event comes in that is outside
the limits of Maximum Concurrent Session
Requests, Application Express can
execute alter system kill session on
the oldest active database session which processes
another page event for this Application Express session.
This attribute specifies the number of seconds a
database process has to be active, before it can be
killed. If you leave this attribute empty, the
instance-level value applies.
Warning: Killing sessions can cause
problems with the application server's database session
pool.
|
Maximum Size of
Files in Workspace |
Enter the total size (in bytes) of all files
that can be uploaded to this workspace.
|
Maximum Email
Messages |
Enter the maximum number of email messages
that can be sent with the APEX_MAIL API
per 24 hour period.
This value overrides the instance-level
setting.
|
Maximum Web Service
Requests |
Enter the maximum number of email messages
that can be sent with the APEX_MAIL API
per 24 hour period. This value will override the
instance-level setting.
|
Content Cache target
size |
Denotes the target size for the content cache
on workspace-level. The content cache can currently
being used by Web Source and REST Enabled SQL services.
The Cache Size Target acts as a soft limit, which, for
performance reasons, is only maintained by the
Application Express scheduler jobs. In other words,
Application Express might exceed the specified limit
during normal operations. With the next run of the
maintenance job, cached content with the shortest
remaining validity will be removed until the cache size
is below the specified limit.
This value overrides the instance-level
setting.
|
Content Cache maximum entry
size |
Denotes the maximum size for content to be
placed into the content cache. This value will override
the instance-level setting.
This value overrides the instance-level
setting.
|