I wanted to extract some information from the server trace file that is generated after I send a connect statement to the database. I wanted to know the naming convention for the server trace file. I could figure out that the name is in the below format:
I wanted to know what is the 4_digit_id that is appended at the end of the trace. As per my research it seems to the process id of the oracle server. I queried the v$process for the pid column, however it seems to be returning multiple values and that too are not in 4 digit. It would be really appreciated if an expert can comment on this.
Is there a way to identify the spid of a failed login attempt? For instance I would like to know the spid for the process when I issue the below command:
BTW, the server trace is enabled through sqlnet.ora where trace_level_server=16 is set.