A server process can have two database sessions (both initiated by the same
user). One way is to have the user issue a SET AUTOTRACE ON.
Hemant K Chitale
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On ;
Behalf Of Cee Pee
Sent: Tuesday, August 30, 2016 7:41 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Back to basics
List,
I see that for the same OS process 48300526, different SQLs execute for
different times. I do not understand the 2 sessions for the same OS process.
Can someone please explain. v12c.
=========================================================================================
18:32:46 SYS@DEV >l
1 select s.sid, s.serial#, s.CLIENT_INFO, p.spid, s.username, s.status,
s.last_call_et, -- SQL_EXEC_START,
2 s.sql_id, s.sql_child_number SQLChd#
3 from v$session s, V$process p
4 where s.paddr= p.addr
5* And p.spid in ( 48300526 )
18:32:47 SYS@DEV >/
SID SERIAL# SPID USERNAME STATUS
LAST_CALL_ET SQL_ID SQLCHD#
----- ---------- ---------------------------------- --------- --------
------------ ------------- ----------
166 59371 48300526 SYSADM ACTIVE
0 gbdfb29ra4ruq 0
168 18449 48300526 SYSADM INACTIVE
16
18:32:48 SYS@DEV >
18:32:48 SYS@DEV >/
SID SERIAL# SPID USERNAME STATUS
LAST_CALL_ET SQL_ID SQLCHD#
----- ---------- ---------------------------------- --------- --------
------------ ------------- ----------
166 59371 48300526 SYSADM ACTIVE
1 fmzy8k2qgnyg1 0
168 18449 48300526 SYSADM INACTIVE
21
18:32:52 SYS@DEV >
18:32:52 SYS@DEV >/
SID SERIAL# SPID USERNAME STATUS
LAST_CALL_ET SQL_ID SQLCHD#
----- ---------- ---------------------------------- --------- --------
------------ ------------- ----------
166 59371 48300526 SYSADM ACTIVE
1 5x9ntrdq9rw9q 0
168 18449 48300526 SYSADM INACTIVE
23
18:32:54 SYS@DEV >
18:32:54 SYS@DEV >/
SID SERIAL# SPID USERNAME STATUS
LAST_CALL_ET SQL_ID SQLCHD#
----- ---------- ---------------------------------- --------- --------
------------ ------------- ----------
166 59371 48300526 SYSADM ACTIVE
1 22mnpwabazugk 0
168 18449 48300526 SYSADM INACTIVE
1
=====================================================================================
CP.
This email and any attachments are confidential and may also be privileged. If
you are not the intended recipient, please delete all copies and notify the
sender immediately. You may wish to refer to the incorporation details of
Standard Chartered PLC, Standard Chartered Bank and their subsidiaries at
https://www.sc.com/en/incorporation-details.html