Skip Headers
Oracle® Application Express Administration Guide
Release 3.2

E12512-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

Managing Service

Oracle Application Express administrators use the settings under Manage Service to create a site-specific tasks list, manage activity log entries, manage session state, monitor the mail queue, and view a report of installed translations.

Topics in this section include:

Creating a Site-Specific Tasks List

The Site-Specific Tasks list is a list of links that appears on the Workspace home page. If links are defined, a Site-Specific Tasks region appears. If no Site-Specific Tasks are defined, the region does not display. This feature enables Oracle Application Express administrators to customize the Workspace home page for an entire development instance. Typical uses for the Site-Specific Tasks list include links to training, discussion forums, and user feedback applications.

Topics in this section include:

Adding a New Task

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

  1. Log in to Oracle Application Express Administration Services. See "Logging in to Oracle Application Express Administration Services".

  2. Click Manage Service.

  3. Under Manage Service, click Site-Specific Tasks.

    The Site-Specific Tasks page appears.

  4. To create a new link, click Create.

  5. On the Create/Edit 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 - Select Yes to display the task link.

  6. Click Create.

See Also:

"Using f?p Syntax to Link Pages" in Oracle Application Express Application Builder User’s Guide

Editing an Existing Task

To edit an existing task:

  1. Log in to Oracle Application Express Administration Services. See "Logging in to Oracle Application Express Administration Services".

  2. Click Manage Service.

  3. Under Manage Service, click Site-Specific Tasks.

    The Site-Specific Tasks page appears.

  4. Select the task name.

  5. On the Create/Edit 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 Application Express Administration Services. See "Logging in to Oracle Application Express Administration Services".

  2. Click Manage Service.

  3. Under Manage Service, click Site-Specific Task Lists.

    The Site-Specific Tasks page appears.

  4. Select the task name.

  5. Click Delete.

Managing Log Entries

Oracle Application Express administrators can delete log entries on the Logs page.

Topics in this section include:

Deleting SQL Workshop Logs

The SQL Workshop logs maintain a history of recent commands and scripts run in the SQL Commands

To delete log files entries:

  1. Log in to Oracle Application Express Administration Services. See "Logging in to Oracle Application Express Administration Services".

  2. Click Manage Service.

  3. Under Manage Service, click Logs.

    The Logs page appears.

  4. Click SQL Workshop logs.

  5. Click one of the following:

    • Script File executions log entries

    • SQL Command Processor history entries

  6. On the Clean up Logs page:

    • To delete entries by age, specify the age of the entries to be deleted and click Delete Entries.

    • To delete all entries, click Truncate Log.

See Also:

"Accessing a Command from Command History"in Oracle Application Express SQL Workshop and Utilities Guide

Deleting Page View Activity Log Entries

Page view activity logs track user activity for an application. Developers enable logging within their application using the Logging attribute on the Edit Definition page.

See Also:

"About the Edit Definition Page" in Oracle Application Express Application Builder User’s Guide

The Application Express 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 Application Express 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 Application Express engine removes all entries in the noncurrent log and designates it as current.

To truncate the activity logs manually:

  1. Log in to Oracle Application Express Administration Services. See "Logging in to Oracle Application Express Administration Services".

  2. Click Manage Service.

  3. Under Manage Service, click Logs.

    The Logs page appears.

  4. Click 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 Application Express Administration Services. See "Logging in to Oracle Application Express Administration Services".

  2. Click Manage Service.

  3. Under Manage Service, click Logs.

    The Logs page appears.

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

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

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

See Also:

"Viewing Application Changes by Developer" for information about the Developer Activity Log

Deleting Click Counting Log Entries

The External Clicks Log counts clicks from an Oracle Application Express application to an external site. You can implement this functionality using the APEX_UTIL.COUNT_CLICK procedure.

To delete click counting log entries:

  1. Log in to Oracle Application Express Administration Services. See "Logging in to Oracle Application Express Administration Services".

  2. Click Manage Service.

  3. Under Manage Service, click Logs.

    The Logs page appears.

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

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

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

See Also:

"COUNT_CLICK Procedure" in Oracle Application Express API Reference

Deleting Mail Log Entries

The Oracle Application Express Mail Log records the message header information and send date of successfully sent mail message.

To truncate the mail log:

  1. Log in to Oracle Application Express Administration Services. See "Logging in to Oracle Application Express Administration Services".

  2. Click Manage Service.

  3. Under Manage Service, click Logs.

    The Mail Logs page appears.

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

  5. Click Mail Log.

  6. On the Mail Log page, click Truncate.

See Also:

"Managing Mail"

Deleting the Login Access Log

This table records authentication events by developers and administrators accessing the Oracle Application Express environment and by end users of Oracle Application Express applications that use the built-in login APIs available to developers. Log entries are aged out of the log tables and purged periodically.

To truncate the Login Access log:

  1. Log in to Oracle Application Express Administration Services. See "Logging in to Oracle Application Express Administration Services".

  2. Click Manage Service.

  3. Under Manage Service, click Login Access Log.

    The Login Access Log page appears.

  4. Click Manage.

  5. On the Manage Login Access Log page, click Delete Entries.

Managing Session State

A session is a logical construct that is used to establish persistence (or stateful behavior) across page views. Each session is assigned a unique ID, which the Application Express engine uses to store and retrieve an application's working set of data (or session state) before and after each page view. An automatic process clears sessions older than 24 hours every eight hours. Oracle Application Express administrators can also purge them manually.

An Oracle Application Express administrator can view session state statistics and purge the session state on the Session State page.

Topics in this section include:

Purging Sessions by Age

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

To view specific session details:

  1. Log in to Oracle Application Express Administration Services. See "Logging in to Oracle Application Express Administration Services".

  2. Click Manage Service.

  3. Under Manage Service, click Session State.

  4. Click Purge Sessions, by age.

  5. On the Purge Sessions page, specify:

    • The maximum number of sessions to be purged

    • The age of sessions 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, Oracle Application Express 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 Application Express Administration Services. See "Logging in to Oracle Application Express Administration Services".

  2. Click Manage Service.

  3. Under Manage Service, click Session State.

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

  5. On the Recent Sessions page, you can:

    • Click a session number to view additional details.

    • Click Purge Sessions to delete the displayed sessions.

Viewing Session Statistics Before Purging

On the Session State Statistics page, Oracle Application Express administrators can view statistics about current sessions before purging.

To view session state statistics:

  1. Log in to Oracle Application Express Administration Services. See "Logging in to Oracle Application Express Administration Services".

  2. Click Manage Service.

  3. Under Manage Service, click Session State.

  4. Select Session State Statistics.

  5. Click Purge Sessions to delete the current sessions.

Managing Mail

Oracle Application Express administrators can manage email sent from applications by monitoring email messages in the mail queue and Mail Log.

Topics in this section include:

See Also:

"Sending Email from an Application" in Oracle Application Express Application Builder User’s Guide

Viewing the Mail Queue

Oracle Application Express administrators can use the Manage Mail Queue page to monitor email messages in the mail queue.

To monitor messages in the mail queue:

  1. Log in to Oracle Application Express Administration Services. See "Logging in to Oracle Application Express Administration Services".

  2. Click Manage Service.

  3. Under Manage Service, click Mail Queue.

    The Mail Queue page appears.

  4. To send email messages, click Send All Mail.

  5. To delete email messages, select the messages to be deleted and click Delete.

Viewing the Mail Log

The Oracle Application Express Mail Log records the message header information and send date of successfully sent mail message.

To view the mail log:

  1. Log in to Oracle Application Express Administration Services. See "Logging in to Oracle Application Express Administration Services".

  2. Click Manage Service.

  3. Under Manage Service, click Logs.

    The Logs page appears.

  4. Click Mail log.

    The Mail Log appears.

  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.

Viewing Installed Translations

Oracle Application Express administrators can view a page showing what translated languages have been installed within the current development instance.

To view the list of installed translations:

  1. Log in to Oracle Application Express Administration Services. See "Logging in to Oracle Application Express Administration Services".

  2. Click Manage Service.

  3. Under Manage Service, click Installed Translations.

    The Installed Translations page appears, displaying a list of languages and indicating if the translations have been loaded.

See Also:

"Managing Application Globalization" in Oracle Application Express Application Builder User’s Guide

Managing Themes for an Oracle Application Express Instance

Oracle Application Express administrators manage the theme repository for an entire Oracle Application Express instance. Oracle Application Express administrators can add a theme to the repository or delete a theme.

Topics in this section include:

See Also:

"Managing Workspace Themes" in Oracle Application Express Application Builder User’s Guide

Adding a Public Theme to the Theme Repository

To add a theme to the Theme repository:

  1. Log in to Oracle Application Express Administration Services. See "Logging in to Oracle Application Express Administration Services".

  2. Click Manage Service.

  3. Under Manage Shared Components, click Public Themes.

    The Public Themes page appears.

  4. Select Create.

  5. For Workspace, select a workspace and click Next.

  6. For Application, select an application and click Next.

  7. For Theme, select a theme and click Next.

  8. For Name, specify the following:

    1. Theme Number - Enter a number that uniquely identifies a theme within a workspace.

    2. Theme Name - Enter a name for the workspace theme.

    3. Description - Enter a description.

    4. Click Next.

  9. Click Create Public Theme.

Deleting a Public Theme

To delete a public theme:

  1. Log in to Oracle Application Express Administration Services. See "Logging in to Oracle Application Express Administration Services".

  2. Click Manage Service.

  3. Under Manage Shared Components, click Public Themes.

    The Public Themes page appears.

  4. Select the theme to be deleted.

  5. Click Delete.

Modifying a Public Theme

You cannot edit a public theme directly. To modify a public theme, you must create a new application using the theme, modify it, and then manually add it to the theme repository.

To modify a public theme:

  1. Create an application using the theme you want to modify. See "Creating an Application" in Oracle Application Express Application Builder User’s Guide.

  2. Modify the theme. See "Editing a Theme" in Oracle Application Express Application Builder User’s Guide.

  3. Delete the existing public theme. See "Deleting a Public Theme".

  4. Add the modified theme to the theme repository. See "Adding a Public Theme to the Theme Repository".

About Exporting a Public Theme

You export a theme in the same way you export any related application files. Exporting a public theme involves the following steps:

  1. Create an application using the theme. See "Creating an Application" in Oracle Application Express Application Builder User’s Guide.

  2. Export the application. See "Exporting an Application" in Oracle Application Express Application Builder User’s Guide.

  3. Import the exported file into the target Oracle Application Express instance. See "Importing an Application or Page" in Oracle Application Express Application Builder User’s Guide.

  4. Install the exported file from the Export Repository. See "Installing Export Files" in Oracle Application Express Application Builder User’s Guide.