| Oracle9iAS Portal PL/SQL API Reference | |||||||
| FRAMES NO FRAMES | ||||||||
Each event log record may contain the following fields:
Log record field names and definitions |
|
|
id |
A unique identifier for each logged event. Notes:
|
|
domain |
The domain name. Notes:
|
|
sub_domain |
The subdomain name. Notes:
|
|
name |
The object name.
|
|
userid |
The user ID for the user that was logged into the system when the logging event was started. Note: The user ID is applied to logging events by the API implementation. |
|
session_id |
The ID of the session that the user was in at the time the logging event was started. Note: The session ID is applied to logging events by the API implementation. |
|
action |
The name of the action being performed upon the object. Notes:
|
|
url |
The URL for the logged object. Note: This is an optional URL string that can be used to get back to the object that was logged. |
|
information |
A string provided by the caller of the API. Note: Information can be any string value that the caller wants to capture and include in the logging event. |
|
start_time |
The time that the logging event was started. Notes:
|
|
dbms_start_time |
The value returned by DBMS_UTILITY.GET_TIME when the logging event was started. Notes:
|
|
elapsed_time |
The time taken to process the event, recorded in seconds. Note: In some cases, the caller of the API supplies this information, in others the API automatically determines the correct value. |
|
row_count |
Specifies the number of rows that were operated upon for the logged action. Notes:
|
|
http_user_agent |
The name of the Web browser being used, if known. Notes:
|
|
http_remote_ |
The remote address (host name/IP address) of the Web browser being used, if known. Notes:
|
|
language |
The browser abbreviation of the NLS setting in effect at the time of the log request. |
|
key_1 |
A column intended to hold data that correlates this log record to any specified data related to the logged event. Use of this column is optional. |
|
key_2 |
A column intended to hold data that correlates this log record to any specified data related to the logged event. Use of this column is optional. |
|
key_3 |
A column intended to hold data that correlates this log record to any specified data related to the logged event. Use of this column is optional. |
|
key_4 |
A column intended to hold data that correlates this log record to any specified data related to the logged event. Use of this column is optional. |
|
key_5 |
A column intended to hold data that correlates this log record to any specified data related to the logged event. Use of this column is optional. |
| Oracle9iAS Portal PL/SQL API Reference | |||||||
| FRAMES NO FRAMES | ||||||||