How [Oracle] obtains the client's detailed connection information when a failure occurs

How [Oracle] obtains the client's detailed connection information when a failure occurs

The customer insists that the following statement is only run at 5 o'clock in the morning every day:

Select/* + Full (tab001_tt01) */' tab001_tt01 ', COUNT (*) from u01. TAB001_TT01 GROUP BY ' tab001_tt01 '

But according to the Incident file, the time is 10:44:50.166 in 2017-09-26, and the customer suspects that Oracle's database has other problems.

So the investigation ran off the direction.

(change of sensitive information due to general known reasons)

From the following sentence "MODULE NAME", the connection through the sqlplus, so it must be the customer through a client operation.
、
MODULE NAME: ([email protected] (TNS v1-v3)) 2017-09-26 10:44:50.166


----------------------------------------------------------------------------------------------------------
2017-09-26 10:44:50.166
SESSION ID: (807.42181) 2017-09-26 10:44:50.166
CLIENT ID:() 2017-09-26 10:44:50.166
SERVICE NAME: (SYS $ USERS) 2017-09-26 10:44:50.166
MODULE NAME: ([email protected] (TNS v1-v3)) 2017-09-26 10:44:50.166
CLIENT DRIVER: (SQL * PLUS) 2017-09-26 10:44:50.166
ACTION NAME:() 2017-09-26 10:44:50.166
tab001_tt01
[TOC 00000]
Jump to Table of contents
Dump continued from file:/u01/app/oracle/diag/rdbms/obi/obi1/trace/obi1_ora_275091.trc
[TOC00001]
Ora-00600:internal error code, arguments: [15712], [2], [], [], [], [], [], [], [], [], [], []

[TOC 0001-end]
[TOC00002]
========= Dump for Incident 117130 (ORA 600 [15712]) ========

2017-09-26 10:44:50.166
Dbkeddefdump (): Starting incident Default dumps (flags = 0x2, level = 3, mask = 0x0)
[TOC00003]
-----current SQL Statement to this session (sql_id = b928a7sazgnzv)-----
Select/* + Full (tab001_tt01) */' tab001_tt01 ', COUNT (*) from u01. TAB001_TT01 GROUP BY ' tab001_tt01 '
[TOC 0003-end]
----------------------------------------------------------------------------------------------------------

Then, most importantly, in the incident file, look for the "client Details" keyword to get more detailed information.

This allows the customer to look at the connection information and see who is doing it at that point in time, remembering what happened before the event.

The information is as follows:

----------------------------------------------------------------------------------------------------------
Client Details:
O/S info:user:oracle, Term:, ospid:270035
Machine:test01.m0.facjian001.com program: [Email protected] (TNS v1-v3)
Application name: [email protected] (TNS v1-v3), hash value = 3897236877

----------------------------------------------------------------------------------------------------------

How [Oracle] obtains the client's detailed connection information when a failure occurs