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

Database Logging
Logging 4-3
select access to the V$ tables.
# Usage example: log in as system and say "grant select any table to %PANAMA_
USERNAME%"
#SystemLog.db.connect.string=%PANAMA_USERNAME%/%PANAMA_USER_PW%@%PANAMA_
HOST%:%PANAMA_PORT%:%PANAMA_SID%
If the SystemLog.db.connect.string parameter is set, logged information is stored in
a separate database. This parameter should not be set if the logged information is to
be stored in the same repository.
4.2.2 Database Table Contents
Data logged to the database is stored in two tables, ptg_service_log and ptg_
session_log.
Table 4–1 Contents of the ptg_session_log Table
Note: The database user name used here (the one replacing
%PANAMA_USERNAME%) must have select access to all tables.
In this example "PANAMA" is Wireless Edition.
Column Name Description
session_id The identifier of the session.
user_id The Object Identifier (OID) of the user of the session.
user_name The user name.
ptg_instance_id A unique identifier, for the database instance.
logical_device The logical device which invoked the service.
login_time The timestamp when the session was created.
login_hour The hour when the session was created.
expiry_time The timestamp when the session expired.
timestamp The time when the data is logged.