Tag: 10046

Example of using tracefile_identifier

Using "tracefile_identifier" Oracle will add that to the name of the user's trace filename so the file can easily be identified. For example if one needs to trace multiple users session who have different schema or OS user then using "tracefile_identifier" one can identify the trace file specific to a user. Example: The following trigger … Continue reading Example of using tracefile_identifier

Using oradebug to set event

The following example shows how to set event on a oracle session To turn on event, needs to be run as sysdba SQL> connect /as sysdba – attach to session by OS process id SQL> oradebug setospid 5243378; Oracle pid: 68, Unix process pid: 5243378, image: oracle@hostname (TNS V1-V3) – sets maximum dump file size … Continue reading Using oradebug to set event