service_name is the service for which to change an event trace profile. This is a requirement value. Service names can be obtained using the ServiceList | sl command.
event_group is the type of event within the service to change. Valid values are:
{Service | srvc}
{Session | sess}
{Statement | stmt}
{Transaction | trans}
{Network | net}
{Error | err}
{Other | oth}
event_name is the name of the event within in the specified event group to change. You can use the ProfileEventTraceInfo command to list available event names.
event_id is the numeric identifier of the event within the specified event group to change. You can specify either event_name or event_id, not both. You can use the ProfileEventTraceInfo command to list available event identifiers.
custom_event_filter is an optional event filter that can be specified for all events being enabled. See Filtering Events for more information.
Example
Example A: The following example disables all events for the OpenAccessSDK810_C data access service, meaning that no events are written to the event trace file:
pete OpenAccessSDK810_C disable
Example B: The following example enables the event specified by the custom event filter:
pete OpenAccessSDK810_C Session enable ’${ClientInfo}="127.0.0.1"’
Example C: The following example enables all service events for the OpenAccessSDK810_C data access service:
pete OpenAccessSDK810_C service enable
Example D: The following example disables all error events for the OpenAccessSDK810_C data access service:
pete OpenAccessSDK810_C err disable
Example E: The following example changes the state of the transaction event named Transaction Rollback to off:
pete OpenAccessSDK810_C trans "Transaction Rollback" off
Example F: The following example changes the state of the session event identified by 2 to "on" if the event meets the custom event query filter:
pete OpenAccessSDK810_C sess 2 on ’${DbmsUser} = "scott"’
{Service | srvc}