Oracle Audio Technologies Application 9i - Manual (Page 56)

Database Logging
4-4 Oracle9i Application Server Wireless Edition Configuration Guide
Table 4–2 Contents of the ptg_service_log Table
Column Name Description
service_id Object Identifier (OID) for the invoked service.
service_name Name of the invoked service.
ptg_instance_id Unique identifier, for the database instance.
final_service_id OID of the final service, for example the master service or folder.
final_service_name Name of the final service.
session_id Session identifier for which the service was invoked.
service_arguments Arguments of the service, in XML format.
bookmark External link, if the invoked service is a bookmark.
service_type Type of service.
invocation_hour Hour when the service was invoked.
invocation_time Date when the service was invoked.
response_time Response time for the service.
request_status Status of the request, a non-zero value indicates an error
number.
error_description Error message, if one occurred while invoking the service.
user_id OID for the user.
user_name Name of the user.
remote_address Host IP address and name.
logical_device Logical device which invoked the service.
external_user_id External user ID.
external_user_name External user name.
adapter_type Type of adapter.
adapter_home Time taken by the adapter.
transformation_time Time taken by the transformer.
timestamp Time when the data is logged.