22 Managing an Oracle HTML DB Hosted Service

Determining the HTML DB Engine Schema

Oracle HTML DB administrators may need to perform certain actions within the HTML DB engine schema. For example, in order for an Oracle HTML DB administrator to have the ability to assign Oracle default schemas, the database administrator (DBA) must explicitly grant the privilege by running the HTMLDB_SITE_ADMIN.UNRESTRICT_SCHEMA procedure within the HTML DB engine schema.

To determine the current HTML DB engine schema for your Oracle HTML DB instance:

1. Use SQL*Plus to connect to the database.

2. Run the following query in a schema with DBA privileges (for example, SYSTEM).

   SELECT TABLE_OWNER FROM all_synonyms
   WHERE SYNONYM_NAME = 'WWV_FLOW' and OWNER = 'PUBLIC'
   
   

Understanding Oracle Default Schema Restrictions

When Oracle HTML DB installs, the Oracle HTML DB administrator does not have the ability to assign Oracle default schemas to workspaces. Default schemas (such as SYS, SYSTEM, and RMAN) are reserved by Oracle for various product features and for internal use. Access to a default schema can be a very powerful privilege. For example, a workspace with access to the default schema SYSTEM can run applications that parse as the SYSTEM user.

In order for an Oracle HTML DB administrator to have the ability to assign Oracle default schemas to workspaces, the database administrator (DBA) must explicitly grant the privilege using SQL*Plus to run a procedure within the HTMLDB_SITE_ADMIN_PRIVS package.

Topics in this section include:

• Granting the Privilege to Assign Oracle Default Schemas

• Revoking the Privilege to Assign Oracle Default Schemas

• Working with Restricted Schemas

EXEC HTMLDB_SITE_ADMIN_PRIVS.UNRESTRICT_SCHEMA(p_schema => 'SYSTEM');
COMMIT:

EXEC HTMLDB_SITE_ADMIN_PRIVS.RESTRICT_SCHEMA(p_schema => 'SYSTEM');
COMMIT;

EXEC HTMLDB_SITE_ADMIN_PRIVS.CREATE_EXCEPTION(p_schema => 'SYSTEM', p_schema => 'DBA_WORKSPACE');
EXEC HTMLDB_SITE_ADMIN_PRIVS.CREATE_EXCEPTION(p_schema => 'SYSTEM', p_schema => 'AUDITOR_WORKSPACE');
COMMIT:

EXEC HTMLDB_SITE_ADMIN_PRIVS.REMOVE_WORKSPACE_EXCEPTIONS(p_schema => 'SYSTEM');
COMMIT:

EXEC REMOVE_WORKSPACE_EXCEPTIONS(p_workspace => 'AUDITOR_WORKSPACE');
COMMIT:

SET SERVEROUTPUT ON
EXEC HTMLDB_SITE_ADMIN_PRIVS.REPORT;

SELECT a.schema "SCHEMA",b.workspace_name "WORKSPACE" FROM WWV_FLOW_RESTRICTED_SCHEMAS a, WWV_FLOW_RSCHEMA_EXCEPTIONS b WHERE b.schema_id (+)= a.id;

Managing Workspace to Schema Assignments

When a user logs into the Oracle HTML DB, they log in to a shared work area called a workspace. Each workspace can have multiple associated schemas. By associating a workspace with a schema, developers in that workspace can:

• Build applications that interact with the database objects in that schema.

• Create new database objects in that schema.

About Workspace Provisioning

When an Oracle HTML DB administrator creates a new workspace with a new schema, a new tablespace and datafile are created for that schema. The datafile for the new tablespace is managed by Oracle-managed files if Oracle-managed files is enabled.

Oracle-managed files simplifies the administration of the Oracle database and eliminates the need for the database administrator (DBA) to directly manage the operating system files that comprise the database. Using Oracle-managed files the DBA specifies operations in terms of database objects rather than file names. The datafile for the any new tablespaces will be named according to the Oracle-managed files conventions and the placement of these files will be determined by the database initialization parameter DB_CREATE_FILE_DEST.

If the Oracle-Managed Files is not enabled, the datafile will be created in the same directory as the first datafile of the tablespace in which Oracle HTML DB was installed.

Specifying a Provisioning Mode

As an Oracle HTML DB administrator, you determine how the process of provisioning (or creating) a workspace works for your Oracle HTML DB development instance.

In manual provision mode, an Oracle HTML DB administrator creates new workspaces and notifies the Workspace administrator of the login information. In request provision mode, users request workspaces directly in a self-service fashion. In this scenario, users use a link on the login page to access a request form. After the workspace request has been granted, users are automatically e-mailed the appropriate login information.

To specify a provisioning mode:

1. Log in to Oracle HTML DB Administration Services. See "Logging in to Oracle HTML DB Administration Services".

2. Click Manage Service.

3. Select Manage Environment Settings.

4. Under Self Service, select a provisioning status:

   • Manual - Oracle HTML DB administrator manually creates new workspaces and notifies the Workspace administrator of the login information.

   • Request - Users request workspaces directly in a self-service fashion.

5. If you select Request in the previous step, enter a URL in Development Service URL (optional).

   The value you enter will used in the e-mail when the request is approved. This setting defines the URL for the service. If this setting is not present, the URL will be derived from your environment.

6. Click Apply Changes.

Creating a Workspace Manually

Oracle HTML DB administrators can provision a workspace manually by running the Create Workspace Wizard.

To create a workspace manually:

1. Log in to Oracle HTML DB Administration Services. See "Logging in to Oracle HTML DB Administration Services".

2. Click Manage Workspaces.

3. Select Create Workspace.

   The Create Workspace Wizard appears.

4. Specify a workspace name and description and click Next.Specify whether you are re-using an existing schema or creating a new one.

   If you are using an existing schema:

   1. Re-use existing schema, select Yes.

   2. Select a schema from the list and click Next.

   If you creating a new schema:

   1. Re-use existing schema, select No.

   2. Enter a schema name and password.x

   3. Specify a space quota and click Next.

5. Specify a Workspace administrator by providing a username, password, and e-mail address. Click Next.

6. Confirm your selections and click Provision.

Viewing Workspace Reports

Oracle HTML DB administrators can view detailed information about a specific workspace by viewing the Workspace Utilization Report.

To view a workspace report:

1. Log in to Oracle HTML DB Administration Services. See "Logging in to Oracle HTML DB Administration Services".

2. Click Manage Workspaces.

3. Select Workspace Details.

4. Select a workspace from the list and click Go.

   The Workspace Utilization Report appears. Table 22-1 describes the various sections of the Workspace Utilization Report.

Viewing a Pending Service Request

You can view existing service requests on the Notifications list on the Oracle HTML DB Administration Services home page or the Service Requests page.

Topics in this section include:

• Viewing a Pending Service Request on the Notifications List

• Viewing Requests from the Service Requests Page

Viewing a Pending Service Request on the Notifications List

The Notifications list on the Oracle HTML DB Administration Services home page displays pending or approved service requests.

Figure 22-1 Notifications List

Description of the illustration notifi.gif

To view service requests on the Notifications list:

1. Log in to Oracle HTML DB Administration Services. See "Logging in to Oracle HTML DB Administration Services".

2. Locate the Notifications list.

   The Notifications list displays a summary of total and pending service requests.

3. To view additional details, click the appropriate service request number.

Approving or Declining a Pending Service Request

To approve or decline a pending service request:

1. Log in to Oracle HTML DB Administration Services. See "Logging in to Oracle HTML DB Administration Services".

2. Click Manage Service.

3. Select Manage Service Requests.

   The Service Requests page appears.

4. From the Status list, select Requested and click Go.

5. Locate a request to review.

6. To view request details, click the Edit icon associated with the appropriate request.

7. Click Provision in the Actions column:

   • To approve the request, click Approved.

   • To decline the request, click Declined.

Changing an Existing a Service Request

To change an existing service request:

1. Log in to Oracle HTML DB Administration Services. See "Logging in to Oracle HTML DB Administration Services".

2. Click Manage Service.

3. Select Manage Service Requests.

   The Service Requests page appears.

4. To filter the report, make a selection from the Status list and click Go.

5. Locate a request to review.

6. Click Adjust in the Actions column.

   The Adjust Request page appears.

7. Select a new status from the Project Status list.

8. Click Apply Changes.

Deleting a Service Request

To delete an existing service or change request:

1. Log in to Oracle HTML DB Administration Services. See "Logging in to Oracle HTML DB Administration Services".

2. Click Manage Service.

3. Select Manage Service Request.

4. From Status, select the type of request you want to delete.

5. Click the Edit icon associated with the request you want to delete.

6. Click Delete.

Viewing a Pending Change Request

You can view existing service requests and change requests from the Notifications list on the Oracle HTML DB Administration Services home page or from the Change Requests pages.

Figure 22-2 Notifications List

Description of the illustration notifi.gif

Topics in this section include:

• Viewing a Pending Change Request from the Notifications List

• Viewing a Change Request from the Workspace Utilization Report

• Viewing Requests from the Change Requests Page

Approving or Declining a Pending Change Request

To approve or decline a pending change request:

1. Log in to Oracle HTML DB Administration Services. See "Logging in to Oracle HTML DB Administration Services".

2. Click Manage Service.

3. Select Manage Change Requests.

4. Locate the request and click View Request under the Action column.

   The Process Change Request page appears.

5. Select one of the following:

   • To approve a request for a schema, click Create Schema.

   • To approve a request for additional disk space, click Provision Space.

   • To approve a request to terminate the service, click Terminate Service

   • To deny a request, click Deny Request.

   • To delete a request and deny it, select Delete this request if denying? and then click Deny Request.

6. Follow the on-screen instructions.

Creating New User Accounts

To create a new user account:

1. Log in to Oracle HTML DB Administration Services. See "Logging in to Oracle HTML DB Administration Services".

2. Click Manage Workspaces.

3. Select Manage Developers and Users.

   The Manage Application Developers and Users page appears.

4. Click Create.

5. Under User Attributes, enter the appropriate information. Fields marked with a red asterisk (*) are required.

6. Under Password, type a case-sensitive password for this account.

7. Under Developer Privileges, specify the developer's privileges:

   • User is a developer - These users can create and edit applications as well as view developer activity, session state, workspace activity, application, and schema reports.

   • User is an administrator - Workspace administrators additionally can create and edit user accounts, manage groups, alter passwords of users within the same workspace, and manage development services as described in "Managing a Development Workspace".

8. Click Create or Create and Create Another.

Editing an Existing User Account

To edit an existing user account:

1. Log in to Oracle HTML DB Administration Services. See "Logging in to Oracle HTML DB Administration Services".

2. Click Manage Workspaces.

3. Select Manage Developers and Users.

   The Manage Application Developers and Users page appears.

4. Locate a user as follows:

   • To locate a specific user, type a username or partial string in the Find User field and click Go.

   • To view all users, leave the Find User field blank and click Go

5. To edit account details, select the user name.

6. Make the appropriate changes and click Apply Changes.

About Purging Inactive Workspaces

If you are managing a large hosted Oracle HTML DB instance, periodically purging inactive workspaces can free up resources for other users. The process of purging inactive workspaces consists of the following steps:

• Identify inactive workspaces

• Remove the resources associated with each inactive workspace

• Delete the inactive workspaces

Identifying Inactive Workspaces

The first step in determining if a workspace is inactive is to establish some basic rules. A common approach is to base the rules on the Oracle HTML DB activity records found in the current HTML DB engine schema.

The following DDL (data definition language) creates a table of all workspaces requested before June 28, 2004 but that have been inactive since June 10, 2004. In this example, inactivity is determined by checking a key within the HTML DB engine schema for the most recent updates by each workspace.

CREATE TABLE ws_to_purge AS
 SELECT c.security_group_id, c.company_name, c.admin_email, c.request_date,
 SYSDATE last_updated_on, 'Y' ok_to_delete
   FROM wwv_flow_provision_company c
  WHERE
c.request_date <= to_date('20040628','YYYYMMDD') AND
     (  not exists
 (SELECT NULL /* Activity Log */
        FROM wwv_flow_activity_log l
       WHERE l.security_group_id = c.security_group_id
         AND l.time_stamp > to_date('20040610','YYYYMMDD'))
 )
    AND NOT EXISTS
     (SELECT NULL /* workspace applications */
        FROM wwv_flows f
       WHERE f.security_group_id = c.security_group_id
         AND f.last_updated_on > to_date('20040610','YYYYMMDD'))
    AND NOT EXISTS
     (SELECT NULL /* Pages */
        FROM wwv_flow_steps s
       WHERE s.security_group_id = c.security_group_id
         AND s.last_updated_on > to_date('20040610','YYYYMMDD'))
    AND NOT EXISTS
     (SELECT NULL /* Regions */
        FROM wwv_flow_page_plugs p
       WHERE p.security_group_id = c.security_group_id
         AND p.last_updated_on > to_date('20040610','YYYYMMDD'))
    AND NOT EXISTS
     (SELECT NULL /* Items */
        FROM wwv_flow_step_items i
       WHERE i.security_group_id = c.security_group_id
         AND i.last_updated_on > to_date('20040610','YYYYMMDD'))
    AND NOT EXISTS
     (SELECT NULL /* Templates */
        FROM wwv_flow_templates t
       WHERE t.security_group_id = c.security_group_id
         AND t.last_updated_on > to_date('20040610','YYYYMMDD'))
    AND NOT EXISTS
     (SELECT NULL /* Files uploaded */
        FROM wwv_flow_file_objects$ o
       WHERE o.security_group_id = c.security_group_id
         AND o.created_on > to_date('20040610','YYYYMMDD'))
    AND NOT EXISTS
     (SELECT NULL /* SQL Workshop history */
        FROM wwv_flow_sw_sql_cmds s
       WHERE s.security_group_id = c.security_group_id
         AND s.created_on > to_date('20040610','YYYYMMDD'));

After you identify inactive workspaces, you can purge them. Purging inactive workspaces is a two step process:

• First, remove the resources (that is, the database schemas, tablespaces, and data files) associated with each inactive workspace

• Second, drop the inactive workspaces from Oracle HTML DB

Removing the Resources Associated with Inactive Workspaces

After you have identified inactive workspaces in a single table, the next step is to remove them.

To remove the resources associated with inactive workspaces:

1. Identify the schemas used by the workspaces to be deleted by joining the table containing the identified inactive workspaces to wwv_flow_company_schemas.

2. Drop the schemas, tablespaces, and data files used exclusively by the inactive workspaces from the database. You can identify the schemas to drop by running a query similar to the following.

   SELECT s.schema
     FROM ws_to_purge ws,
          wwv_flow_company_schemas s
   WHERE s.security_group_id = ws.security_group_id
      AND ws.ok_to_delete = 'Y';
   
   

Deleting Inactive Workspaces

Once you remove the resources associated with an inactive workspace, you can delete it. You can delete inactive workspaces manually using the Oracle HTML DB Administration Services application. Or, you can delete them programmatically as shown in the following PL/SQL example.

BEGIN 
     FOR c1 IN (SELECT security_group_id  
                 FROM ws_to_purge
                 WHERE ok_to_delete = 'Y')
     LOOP
         WWV_FLOW_PROVISIONING.TERMINATE_SERVICE_BY_SGID(c1.security_group_id);
     END LOOP;
 END;

Removing a Workspace

Removing a workspace does not remove any of the associated database objects. To remove the associated schemas, a database administrator (DBA) must use a standard database administration tool such as Oracle Enterprise Manager or SQL*Plus.

To remove a workspace:

1. Log in to Oracle HTML DB Administration Services. See "Logging in to Oracle HTML DB Administration Services".

2. Click Manage Workspaces.

3. Select Remove Workspace.

4. Select a workspace name and click Next.

5. Follow the on-screen instructions.

Exporting and Importing a Workspace

To move a workspace and all associated users to a new Oracle HTML DB instance, you must export the workspace. When you export a workspace, Oracle HTML DB generates a text file. This file contains information about your workspace, all the users in your workspace, and any groups in your workspace (if applicable). You can use this file to import your workspace into another Oracle HTML DB instance.

Keep in mind, this method only imports workspace, users, and groups. This file does not contain:

• The schemas associated with this workspace, or the objects in those schemas.

• Any applications, images, cascading style sheets and static text files.

All of these items must be exported separately.

To export a workspace:

1. Log in to Oracle HTML DB Administration Services. See "Logging in to Oracle HTML DB Administration Services".

2. Click Manage Workspaces.

3. Select Export Workspace.

4. Select a workspace name and click Export Workspace.

5. To export the selected workspace, click Save File.

6. Follow the on-screen instructions.

To import a workspace:

1. Log in to Oracle HTML DB Administration Services. See "Logging in to Oracle HTML DB Administration Services".

2. Click Manage Workspaces.

3. Select Import Workspace.

4. Select a workspace name and click Next.

5. To install the workspace, click Install.

6. Follow the on-screen instructions.

Deleting SQL Workshop Logs

The SQL Workshop logs maintain a history of recent commands and scripts run in the SQL Command Processor.

To delete log files entries:

1. Log in to Oracle HTML DB Administration Services. See "Logging in to Oracle HTML DB Administration Services".

2. Click Manage Service.

3. Select Manage Logs.

   The Manage Logs page appears.

4. Select SQL Workshop logs.

5. Select one of the following:

   • Script File executions log entries

   • SQL Command Processor history entries

6. To delete entries by age:

   • Specify the age of the entries to deleted.

   • Click Delete Entries.

7. To delete all entries, click Truncate Log.

Deleting Page View Activity Log Entries

Page view activity logs track user activity for an application. Developers enable logging within their application on the Edit Application Attributes page.

The HTML DB engine actually uses two logs to track user activity. At any given time, one log is designated as current. For each rendered page view, the HTML DB engine inserts one row into the log file. A log switch occurs at the interval listed on the Manage Activity Logs page. At that point, the HTML DB engine removes all entries in the noncurrent log and designates it as current.

To truncate the activity logs manually:

1. Log in to Oracle HTML DB Administration Services. See "Logging in to Oracle HTML DB Administration Services".

2. Click Manage Service.

3. Select Manage Logs.

   The Manage Logs page appears.

4. Select Page View Activity Log, with option to truncate.

5. Click Truncate Logs.

6. Click either Truncate Log 1 or Truncate Log 2.

Deleting Developer Activity Log Entries

The Developer Activity Log tracks changes to applications within an individual workspace. Log entries older than one month are automatically deleted.

To delete Developer Activity Log entries:

1. Log in to Oracle HTML DB Administration Services. See "Logging in to Oracle HTML DB Administration Services".

2. Click Manage Service.

3. Select Manage Logs.

   The Manage Logs page appears.

4. Select Developer Activity Logs, with option to delete entries.

5. On the Developer Activity Logs page, click Manage.

6. Specify the age of the entries to be deleted and click Delete Entries.

Deleting Click Counting Log Entries

The External Clicks Log counts clicks from an Oracle HTML DB application to an external site. You can implement this functionality using COUNT_CLICK procedure.

To delete click counting log entries:

1. Log in to Oracle HTML DB Administration Services. See "Logging in to Oracle HTML DB Administration Services".

2. Click Manage Service.

3. Select Manage Logs.

   The Manage Logs page appears.

4. Select External Click Counting Log, with option to truncate.

5. On the Click Counting Log page, click Manage.

6. Specify the age of the entries to be deleted and click Delete Entries.

Deleting the HTML DB Mail Log Entries

The HTML DB Mail Log records message header information and send date of successfully sent mail message.

To truncate the mail log:

1. Log in to Oracle HTML DB Administration Services. See "Logging in to Oracle HTML DB Administration Services".

2. Click Manage Service.

3. Select Manage Logs.

   The Manage Logs page appears.

4. Select Mail Log.

5. On the Manage Mail Log page, click Truncate Log.

Purging Sessions by Age

Using the Purge Session page, administrators can purge sessions by age.

To view specific session details:

1. Log in to Oracle HTML DB Administration Services. See "Logging in to Oracle HTML DB Administration Services".

2. Click Manage Service.

3. Select Manage Session State.

4. Select Purge Sessions by age.

5. On the Purge Session page, specify:

   • The maximum number of sessions to be purged

   • The age of session to be purged

6. To view a report of session statistics, click Count Sessions.

7. To purge the selected sessions, click Purge Sessions.

Viewing Session Details Before Purging

Before purging sessions, administrators can use the Recent Sessions page to first view a listing of recent sessions and then drill down on session details.

To purge sessions by age:

1. Log in to Oracle HTML DB Administration Services. See "Logging in to Oracle HTML DB Administration Services".

2. Click Manage Service.

3. Select Manage Session State.

4. Select Recent Sessions, with drill down to session details.

5. On the Recent Sessions page, you can:

   • Click a session ID to view additional details.

   • Click Purge Session to delete the displayed sessions.

Viewing Session Statistics Before Purging

On the Session State Statistics page, administrators can view statistics about current sessions prior to purging.

To view session state statistics:

1. Log in to Oracle HTML DB Administration Services. See "Logging in to Oracle HTML DB Administration Services".

2. Click Manage Service.

3. Select Manage Session State.

4. Select Session State Statistics.

5. Click Purge Sessions to delete the current sessions.

Viewing Current Environment Settings

To view existing environment settings:

1. Log in to Oracle HTML DB Administration Services. See "Logging in to Oracle HTML DB Administration Services".

2. Click Manage Service.

3. Select Manage Environment Settings.

4. Scroll down to the bottom of the page and select Settings.

   The current selected settings appears

Controlling 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. You can control PL/SQL program unit editing for an entire workspace by making a selection from Allow PL/SQL Program Unit Editing.

To disable PL/SQL program unit editing:

1. Log in to Oracle HTML DB Administration Services. See "Logging in to Oracle HTML DB Administration Services".

2. Click Manage Service.

3. Select Manage Environment Settings.

4. Locate the section Application Development.

5. From Allow PL/SQL Program Unit Editing, select No.

6. Click Apply Changes.

Including Demonstration Applications in a New Workspace

When you create a new workspace, Oracle HTML DB automatically creates demonstration applications within the workspace.

To disable the creation of demonstration applications:

1. Log in to Oracle HTML DB Administration Services. See "Logging in to Oracle HTML DB Administration Services".

2. Click Manage Service.

3. Select Manage Environment Settings.

4. Locate the section Application Development.

5. From Create demonstration objects in new workspaces, select No.

6. Click Apply Changes.

Configuring Oracle HTML DB to Send Mail

To enable users to request a workspace or reset their passwords using links on the login page, you must configure Oracle HTML DB to send mail. In order to enable Oracle HTML DB to send mail, you must configure a number of settings on the Environment Preferences page.

To configure Oracle HTML DB to send mail:

1. Log in to Oracle HTML DB Administration Services. See "Logging in to Oracle HTML DB Administration Services".

2. Click Manage Service.

3. Select Manage Environment Settings.

4. Under Email, enter the following:

   1. SMTP Host Address - Defines the server address of the SMTP server. On installation, this will be set to localhost. If you are using another server as an SMTP relay, change localhost to that server's address.

   2. SMTP Host Port - Defines the port the SMTP server listens to for mail requests. By default, this setting will be set to 25 at the time of installation.

   3. Administration Email Address - Defines the "from" address for administrative tasks such as approving a provision request, or resetting a password generates an e-mail.

5. Click Apply Changes.

Configuring SQL Workshop

Use the attributes under SQL Workshop to configure basic SQL Workshop behavior.

To configure SQL Workshop:

1. Log in to Oracle HTML DB Administration Services. See "Logging in to Oracle HTML DB Administration Services".

2. Click Manage Service.

3. Select Manage Environment Settings.

4. Under SQL Workshop, enter the attributes described in Table 22-2.

   Table 22-2 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 HTML DB 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.

   
   

5. Click Apply Changes.

Enabling Database Monitoring

The Database Monitoring page contains a variety of reports that describe the activity, storage, and configuration of the current database instance. Once enabled, only users having a database user account that has been granted a DBA role can access the Database Monitor page.

Before you can access the Database Monitoring page, you must enable database monitoring on Manage Environment Settings page.

To enable database monitoring:

1. Log in to Oracle HTML DB Administration Services. See "Logging in to Oracle HTML DB Administration Services".

2. Click Manage Service.

3. Select Manage Environment Settings.

4. From Enable Database Monitoring, select Yes.

5. Click Apply Changes.

Configuring Security Settings

Use the Security section of the Manage Environment Settings page to disable administrator and workspace login as well as restrict user access by IP address.

Topics in this section include:

• Disabling Access to Oracle HTML DB Administration Services

• Disabling Access to Oracle HTML DB Internal Applications

• Restricting User Access by IP Address

BEGIN
    WWV_FLOW_API.SET_SECURITY_GROUP_ID(p_security_group_id=>10);
    WWV_FLOW_PLATFORM.SET_PREFERENCE( 
        p_preference_name => 'DISABLE_ADMIN_LOGIN',
        p_preference_value => 'N' );
end;
/

commit
/

Changing Application Build Status

Every Oracle HTML DB application has an application-level attribute called Build Status. You can use this attribute to prevent an application from being modified by other developers. Build Status has two settings:

• Run and Build Application - Developers can both run and edit an application

• Run Application Only - Developers can only run an application

Setting the Build Status to Run Application Only is an effective way to prevent other developers from modifying it. You can change the Build Status by:

• Changing the Build Status attribute on the Edit Application Attributes page. See "Availability".

• Changing the Build Status during the deployment process. See "How to Deploy an Application to Another Oracle HTML DB Instance".

Deploying an application from one Oracle HTML DB instance to another is a four step process:

1. Move any supporting database objects (if appropriate).

2. Export the application definition and all related files

3. Import the exported files into the target Oracle HTML DB instance.

   Note that if the target instance is a different schema, you also need to export and import any required database objects.

4. Install the exported files from Export Repository

During steps 1 and 2, you have the option of setting the Build Status to Run Application Only. Be aware that if you set the Build Status to Run Application Only during deployment, you can only change it in Oracle HTML DB Administration Services.

To change a Build Status set during deployment:

1. Log in to Oracle HTML DB Administration Services. See "Logging in to Oracle HTML DB Administration Services".

2. Click Manage Applications.

3. Select Build Status.

   The Build Status page appears.

4. Locate an application by making selections from the Build Status, Workspace, and Application lists and clicking Go.

5. Click the Edit icon adjacent to the appropriate application.

   The Edit Build Status page appears.

6. Select an alternate build status and click Apply Changes.

Viewing the Application Attributes Report

Oracle HTML DB administrators can view applications by workspace on the Application Attributes page.

To view the Application Attributes page:

1. Log in to Oracle HTML DB Administration Services. See "Logging in to Oracle HTML DB Administration Services".

2. Click Manage Applications.

3. Select Application Attributes.

   The Application Attributes page appears.

4. Filter the display by making selections from the Display, Application, and Workspace lists and clicking Go.

5. To sort by column, select a column heading.

Viewing the Parse As Schemas by Application Report

To change a Build Status set during deployment:

1. Log in to Oracle HTML DB Administration Services. See "Logging in to Oracle HTML DB Administration Services".

2. Click Manage Applications.

3. Select Parse as Schemas.

   The Parse As Schemas page appears.

4. Filter the display by making selections from the Parse As, Application, and Workspace lists and clicking Go.

Viewing the Mail Queue

Oracle HTML DB administrators can use the Manage Mail Queue page to monitor e-mail messages in the mail queue.

To monitor messages in the mail queue:

1. Log in to Oracle HTML DB Administration Services. See "Logging in to Oracle HTML DB Administration Services".

2. Click Manage Service.

3. Select Manage Mail Queue.

   The Manage Mail Queue page appears.

4. To send e-mail messages, click Send All Mail.

5. To delete e-mail messages, select the messages to be deleted and click Delete.

Viewing the HTML DB Mail Log

The HTML DB Mail Log records message header information and send date of successfully sent mail message.

To view the mail log:

1. Log in to Oracle HTML DB Administration Services. See "Logging in to Oracle HTML DB Administration Services".

2. Click Manage Service.

3. Select Manage Logs.

   The Manage Logs page appears.

4. Select Mail log.

5. To control the number of rows that display, make a selection from the Display list and click Go.

6. To delete all log entries, click Truncate Log.

Adding a New Task

To add new task to a Site-Specific Tasks lists:

1. Log in to Oracle HTML DB Administration Services. See "Logging in to Oracle HTML DB Administration Services".

2. Click Manage Service.

3. Select Manage Site-Specific Task Lists.

   The Site-Specific Tasks page appears.

4. To create a new link, click Create.

5. On the Site-Specific Tasks page you can specify the following:

   1. Display Sequence - Indicate the relative order of this task within the list.

   2. Display Location - Indicate the page on which the task should display (that is, the Workspace Login page or Workspace home page).

   3. Task Name - Enter a name for this task.

   4. Tasks Link - Enter the link target for this task using either a relative URL (for example, using f?p syntax) or an absolute URL (such as http://otn.oracle.com).

   5. Displayed - Determines whether a task or link displays. Select Yes to enable display, or select No to disable display.

   
   

   See Also: "Using f?p Syntax to Link Pages"

   
   

6. Click Create.

Editing an Existing Task

To edit an existing task:

1. Log in to Oracle HTML DB Administration Services. See "Logging in to Oracle HTML DB Administration Services".

2. Click Manage Service.

3. Select Manage Site-Specific Task Lists.

   The Site-Specific Tasks page appears.

4. Select the task name.

5. On the Site-Specific Tasks page, edit the appropriate attributes.

6. Click Apply Changes.

Deleting a Task

To delete an existing task:

1. Log in to Oracle HTML DB Administration Services. See "Logging in to Oracle HTML DB Administration Services".

2. Click Manage Service.

3. Select Manage Site-Specific Task Lists.

   The Site-Specific Tasks page appears.

4. Select the task name.

5. Click Delete.