RE: Back to basics

From: Chitale, Hemant K <Hemant-K.Chitale_at_sc.com>
Date: Tue, 30 Aug 2016 03:08:22 +0000
Message-ID: <2FE2AA1C5F8DEC478F58DF8DD32BA6370CEF67F8_at_HKWPIPXMB03C.zone1.scb.net>

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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Cee Pee Sent: Tuesday, August 30, 2016 7:41 AM
To: oracle-l_at_freelists.org
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_at_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_at_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_at_DEV >
18:32:48 SYS_at_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_at_DEV >
18:32:52 SYS_at_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_at_DEV >
18:32:54 SYS_at_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

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Aug 30 2016 - 05:08:22 CEST