|
Oracle® HTML DB
Release 2.0 |
|
 Previous |
 Next |
Workspace administrators use the Managing Services page to view reports about the current workspace and associated schemas, manage session state, purge log files, terminate a workspace service, or request a new schema or additional storage.
Topics:
Workspace administrators can view a summary report about the current workspace by selecting Workspace Overview on the Manage Services page.
To view a summary report about the current workspace:
Navigate to the Workspace home page.
Click the Administration icon.
Click Manage Services and Workspace Overview.
Follow the on-screen instructions.
A session is a logical construct that establishes persistence (or stateful behavior) across page views. Each session is assigned a unique ID which the HTML DB engine uses to store and retrieve an application's working set of data (or session state) before and after each page view. Sessions persist in the database until purged by an administrator.
Workspace administrators can purge session state or user preferences within their workspace on the Session State Management page.
Topics:
Workspace administrators can use the Session State Management page to manage session state and user preferences for the current session.
To manage session state and user preferences for the current session:
Navigate to the Workspace home page.
Click the Administration icon.
Click Manage Services.
Click Session State.
When the Session State Management page appears, click Report your current session, with an option to purge.
Under Session State you can:
Reset the session state for the current session by clicking Purge Session State.
View information about the current session by clicking View Session State.
Under User Preferences, you can:
View preferences for the current user, by clicking View Preferences.
Reset user preferences for the current user by clicking Reset Preferences.
Sessions are used to maintain user state. Workspace administrators can purge existing sessions by age.
To purge existing session by age:
Navigate to the Workspace home page.
Click the Administration icon.
Click Manage Services.
Click Session State.
Select Purge existing sessions by age.
Make a selection from Sessions older than.
Click one of the following buttons:
Report Session generates a report detailing the total number of sessions for the workspace, the number of users, and the number of old sessions.
Purge Sessions purges existing sessions by age.
Workspace administrators can determine whether to remove existing sessions by first reviewing session details on the Session State page.
To view session details prior to removing session state:
Navigate to the Workspace home page.
Click the Administration icon.
Click Manage Service.
Click Session State.
Select Report recent sessions with drilldown to session details.
To narrow the results, select a time increment, specify a user, and click Go.
Workspace administrators view preferences for a specific user on the Purge Preferences report.
To view the Purge Preferences report:
Navigate to the Workspace home page.
Click the Administration icon.
Click Manage Services.
Click Session State.
On the Session State Management page, select Report preferences for users.
The Preferences Report page appears.
Specify a user and click Go.
Workspace administrators purge preferences for a specific user on the Purge Preferences page.
To purge preferences for a specific user:
Navigate to the Workspace home page.
Click the Administration icon.
Click Manage Service.
Click Session State.
On the Session State Management page, select Purge preferences for a selected user.
The Purge Preferences page appears.
Select a specific user and click Report.
A report appears at the bottom of the page.
To purge the displayed user preferences, click Purge User Preferences.
Oracle HTML DB automatically deletes log entries older then one month. Workspace administrators can manually purge developer logs and the External Count Clicks log on the Log files page.
The Developer Activity Log track changes to applications within the current workspace.
To purge the Developer Activity Log:
Navigate to the Workspace home page.
Click the Administration icon.
Click Manage Services.
Click Logs.
Click Purge Developer Log.
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 purge the External Clicks Log:
Navigate to the Workspace home page.
Click the Administration icon.
Click Manage Services.
Click Logs.
Click Purge Click Log.
To submit a request to the Oracle HTML DB administrator to terminate workspace service:
Navigate to the Workspace home page.
Click the Administration icon.
Click Manage Services.
Click Terminate Service.
Follow the on-screen instructions and click Request Termination.
To submit a request to the Oracle HTML DB administrator for a new database schema:
Navigate to the Workspace home page.
Click the Administration icon.
Click Manage Services.
Click Request Schema.
Enter a new schema name and click Request Database Schema.
To submit a request to the Oracle HTML DB administrator for additional storage space for your workspace:
Navigate to the Workspace home page.
Click the Administration icon.
Click Manage Services.
Click Request Storage.
Specify the amount of storage to add and click Request Storage.
Schema Reports offer summaries of database privileges by schema as well as a list of all database schemas available in the current workspace.
To view Schema Reports:
Navigate to the Workspace home page.
Click the Administration icon.
Click Manage Services.
Click Schema Reports.
Available Schema Reports include:
Database Privileges by Schema
Database Schemas Available for the Current Workspace
By default, developers can change and compile PL/SQL source code when browsing database procedures, packages, and functions in Object Browser. You can disable PL/SQL program unit editing by selecting Do not allow PL/SQL program unit editing on the Workspace Preferences page.
To disable PL/SQL program unit editing:
Navigate to the Workspace home page.
Click the Administration icon.
Click Manage Services.
Click Workspace Preferences.
The Workspace Preferences page appears.
From PL/SQL Editing select one of the following:
Allow PL/SQL program unit editing
Do not allow PL/SQL program unit editing
If you select Do not allow PL/SQL program unit editing, developers can still create and replace PL/SQL program units using scripts or the SQL Command Processor.
Running the Create Application Wizard creates an application model. This model contains basic application property values, such as the application pages and page definitions, DML processes, and multi-row operation processes. When you create a new application, you can base it on an existing application model, making the creation process more productive.
You can remove unwanted application models on the Application Models page.
To delete an application model:
Navigate to the Workspace home page.
Click the Administration icon.
Click Manage Services.
Click Application Models.
The Application Models page appears.
To search for a model, enter a case insensitive query in the Model field and click Go.
Select the models you want to delete and click Delete Checked.