Oracle Audio Technologies 9i manual Contents of the ptgservicelog Table

Database Logging

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.

4-4Oracle9i Application Server Wireless Edition Configuration Guide