SQL> SELECT username, status, logon_time, program FROM v$session where status = 'ACTIVE' and username ='SYSTEM' ;

USERNAME                       STATUS   LOGON_TIM PROGRAM
------------------------------ -------- --------- ------------------------------------------------
SYSTEM                         ACTIVE   13-JAN-17 sqlplus@udkfinp03 (TNS V1-V3)
SYSTEM                         ACTIVE   13-JAN-17 sqlplus@udkfinp03 (TNS V1-V3)
SYSTEM                         ACTIVE   13-JAN-17 sqlplus@udkfinp03 (TNS V1-V3)


ps -ef | grep sql
opfinbac 19342 23366   0 17:07:28 ?           0:00 sqlplus -s /nolog
opfinbac 27558 27422   0 18:04:47 pts/17      0:00 sqlplus -s /nolog
opfinbac  8566 23366   0 16:09:23 ?           0:00 sqlplus -s /nolog


select a.sid, a.serial#, b.sql_text from v$session a, v$sqlarea b  where a.sql_address=b.address
 and a.username='SYSTEM';




       SID    SERIAL# SQL_TEXT
---------- ---------- --------------------------------------------------------------------------------------------------------------------------------------------
       259      64904 SELECT RIDX.OWNER OWNER , RIDX.INDEX_NAME REVISED_INDEX , RIDX.TABLE_OWNER TABLE_OWNER , RIDX.TABLE_NAME TABLE_NAME , OIDX.INDEX_NAME ORIGIN
                      AL_INDEX , CON.CONSTRAINT_NAME CONSTRAINT_NAME FROM DBA_INDEXES RIDX , DBA_INDEXES OIDX , DBA_CONSTRAINTS CON WHERE RIDX.OWNER IN ( SELECT O
                      RACLE_USERNAME FROM SYSTEM.FND_ORACLE_USERID WHERE READ_ONLY_FLAG IN ('A', 'B', 'E', 'U') ) AND RIDX.TABLE_OWNER = :B2 AND RIDX.TABLE_NAME =
                       :B1 AND REGEXP_LIKE(RIDX.INDEX_NAME, AD_ZD_TABLE.REVISED_INDEX_REGEXP, 'c') AND OIDX.OWNER(+) = RIDX.OWNER AND OIDX.INDEX_NAME(+) = AD_ZD_T
                      ABLE.ORIGINAL_INDEX_NAME(RIDX.INDEX_NAME) AND CON.OWNER(+) = :B2 AND CON.TABLE_NAME(+) = :B1 AND CON.INDEX_OWNER(+) = OIDX.OWNER AND CON.IND
                      EX_NAME(+) = OIDX.INDEX_NAME UNION SELECT OIDX.OWNER OWNER , NULL REVISED_INDEX , OIDX.TABLE_OWNER TABLE_OWNER , OIDX.TABLE_NAME TABLE_NAME
                      , OIDX.INDEX_NAME ORIGINAL_INDEX , CON.CONSTRAINT_NAME CONSTRAINT_NAME FROM DBA_INDEXES OIDX , DBA_CONSTRAINTS CON WHERE OIDX.OWNER IN ( SEL
                      ECT ORACLE_USERNAME

       464      37252 SELECT RIDX.OWNER OWNER , RIDX.INDEX_NAME REVISED_INDEX , RIDX.TABLE_OWNER TABLE_OWNER , RIDX.TABLE_NAME TABLE_NAME , OIDX.INDEX_NAME ORIGIN
                      AL_INDEX , CON.CONSTRAINT_NAME CONSTRAINT_NAME FROM DBA_INDEXES RIDX , DBA_INDEXES OIDX , DBA_CONSTRAINTS CON WHERE RIDX.OWNER IN ( SELECT O
                      RACLE_USERNAME FROM SYSTEM.FND_ORACLE_USERID WHERE READ_ONLY_FLAG IN ('A', 'B', 'E', 'U') ) AND RIDX.TABLE_OWNER = :B2 AND RIDX.TABLE_NAME =
                       :B1 AND REGEXP_LIKE(RIDX.INDEX_NAME, AD_ZD_TABLE.REVISED_INDEX_REGEXP, 'c') AND OIDX.OWNER(+) = RIDX.OWNER AND OIDX.INDEX_NAME(+) = AD_ZD_T
                      ABLE.ORIGINAL_INDEX_NAME(RIDX.INDEX_NAME) AND CON.OWNER(+) = :B2 AND CON.TABLE_NAME(+) = :B1 AND CON.INDEX_OWNER(+) = OIDX.OWNER AND CON.IND
                      EX_NAME(+) = OIDX.INDEX_NAME UNION SELECT OIDX.OWNER OWNER , NULL REVISED_INDEX , OIDX.TABLE_OWNER TABLE_OWNER , OIDX.TABLE_NAME TABLE_NAME
                      , OIDX.INDEX_NAME ORIGINAL_INDEX , CON.CONSTRAINT_NAME CONSTRAINT_NAME FROM DBA_INDEXES OIDX , DBA_CONSTRAINTS CON WHERE OIDX.OWNER IN ( SEL
                      ECT ORACLE_USERNAME

       584      49228 SELECT RIDX.OWNER OWNER , RIDX.INDEX_NAME REVISED_INDEX , RIDX.TABLE_OWNER TABLE_OWNER , RIDX.TABLE_NAME TABLE_NAME , OIDX.INDEX_NAME ORIGIN
                      AL_INDEX , CON.CONSTRAINT_NAME CONSTRAINT_NAME FROM DBA_INDEXES RIDX , DBA_INDEXES OIDX , DBA_CONSTRAINTS CON WHERE RIDX.OWNER IN ( SELECT O
                      RACLE_USERNAME FROM SYSTEM.FND_ORACLE_USERID WHERE READ_ONLY_FLAG IN ('A', 'B', 'E', 'U') ) AND RIDX.TABLE_OWNER = :B2 AND RIDX.TABLE_NAME =
                       :B1 AND REGEXP_LIKE(RIDX.INDEX_NAME, AD_ZD_TABLE.REVISED_INDEX_REGEXP, 'c') AND OIDX.OWNER(+) = RIDX.OWNER AND OIDX.INDEX_NAME(+) = AD_ZD_T
                      ABLE.ORIGINAL_INDEX_NAME(RIDX.INDEX_NAME) AND CON.OWNER(+) = :B2 AND CON.TABLE_NAME(+) = :B1 AND CON.INDEX_OWNER(+) = OIDX.OWNER AND CON.IND
                      EX_NAME(+) = OIDX.INDEX_NAME UNION SELECT OIDX.OWNER OWNER , NULL REVISED_INDEX , OIDX.TABLE_OWNER TABLE_OWNER , OIDX.TABLE_NAME TABLE_NAME
                      , OIDX.INDEX_NAME ORIGINAL_INDEX , CON.CONSTRAINT_NAME CONSTRAINT_NAME FROM DBA_INDEXES OIDX , DBA_CONSTRAINTS CON WHERE OIDX.OWNER IN ( SEL
                      ECT ORACLE_USERNAME