Configuring Features

Use the Feature Configuration page to configure application development and SQL Workshop option as well as control database monitoring.

Topics:

Disabling PL/SQL Program Unit Editing
Disabling the Creation of Sample Application in a New Workspace
Disabling the Creation of Websheet Objects
Configuring SQL Workshop
Enabling Database Monitoring

Disabling PL/SQL Program Unit Editing

By default, developers can change and compile PL/SQL source code when browsing database procedures, packages, and functions in Object Browser. As an Instance administrator, you can control PL/SQL program unit editing for an entire instance by making a selection from Allow PL/SQL Program Unit Editing.

To disable PL/SQL program unit editing:

Log in to Oracle Application Express Administration Services. See "Logging in to Oracle Application Express Administration Services".
Click Manage Instance.
Under Instance Settings, click Feature Configuration.
Locate the Application Development section.
For Allow PL/SQL Program Unit Editing, select No.
Click Apply Changes.

Disabling the Creation of Sample Application in a New Workspace

When an Instance administrator creates a new workspace, Oracle Application Express automatically creates a demonstration application within the workspace.

To disable the creation of demonstration applications:

Log in to Oracle Application Express Administration Services. See "Logging in to Oracle Application Express Administration Services".
Click Manage Instance.
Under Instance Settings, click Feature Configuration.
Locate the Application Development section.
For Create demonstration objects in new workspaces, select No.
Click Apply Changes.

Disabling the Creation of Websheet Objects

When an Instance administrator creates a new workspace, Oracle Application Express automatically creates Websheet objects within the workspace.

To disable the creation of Websheet objects:

Log in to Oracle Application Express Administration Services. See "Logging in to Oracle Application Express Administration Services".
Click Manage Instance.
Under Instance Settings, click Feature Configuration.
Locate the Application Development section.
For Create Websheet objects in new workspaces, select No.
Click Apply Changes.

Configuring SQL Workshop

As an Instance administrator, you can use the attributes under SQL Workshop to configure basic SQL Workshop behavior.

To configure SQL Workshop:

Log in to Oracle Application Express Administration Services. See "Logging in to Oracle Application Express Administration Services".
Click Manage Instance.
Under Instance Settings, click Feature Configuration.

Under SQL Workshop, enter the attributes described in Table: SQL Workshop Attributes.

SQL Workshop Attributes

Attribute	Description
SQL Commands Maximum Inactivity in minutes	Identify the maximum amount of time a transactional command in the SQL Command Processor waits before timing out.
SQL Scripts Maximum Script Output Size in bytes	Identify the maximum amount of output a single SQL script can generate. SQL scripts are run from the SQL Workshop.
SQL Scripts Maximum Workspace Output Size in bytes	Identify the maximum amount of space all scripts within a workspace may consume. SQL script results are the output generated when running SQL scripts from the Script Editor or from the SQL Scripts home page.
SQL Scripts Maximum Script Size in bytes	Identify the maximum size of a SQL script used within the SQL Workshop.
Enable Transactional SQL Commands	Select Yes to enable transactional SQL commands for the entire Oracle Application Express instance. Enabling this feature permits SQL Command Processor users to issue multiple SQL commands within the same physical database transaction. When you select Yes, an Autocommit check box appears on the SQL Command Processor page. By default, this option is set to No.

Click Apply Changes.

Enabling Database Monitoring

Setting Enable Database Monitoring to Yes enables monitoring within SQL Workshop. Before you can access the Database Monitoring page, an Instance administrator must enable database monitoring.