Oracle Database XE 10g Installation Guide Step by Step on Linux RHEL4 [PDF]

This (quick-) installation guide is just an abstract of the Oracle Database Express Edition Installation Guide 10g Release 2 (10.2) for Linux.

you can download oracle database XE 10g installation guide step by step on linux_RHEL4 from the following link:

oracle_database_xe_10g_installation_guide_step_by_step_on_linux_rhel4.pdf

Reference:  ORATECH_blog

 

Advertisements

SQL Statement to Get Session Information Which Used any Database Object

To get the session information which used any database objects you can use the following sql statement:

SELECT S.SID,
       S.SERIAL#,
       S.USERNAME,
       TO_CHAR(S.LOGON_TIME,'MMDDYYYY:HH24:MI') LOGON_TIME,
       TYPE,
       STATUS,
       PROCESS,
       SQL_ADDRESS,
       SQL_HASH_VALUE,
       P.OPTIMIZER_MODE,
       P.HASH_VALUE,
       P.ADDRESS,
       P.CPU_TIME,
       P.ELAPSED_TIME,
       P.SQL_TEXT
  FROM V$SQLAREA P,
       V$SESSION S
 WHERE S.SQL_HASH_VALUE = P.HASH_VALUE
   AND S.SQL_ADDRESS    = P.ADDRESS
   AND S.USERNAME       IS NOT NULL
   AND UPPER(P.SQL_TEXT) like '%'||UPPER(:P_OBJ_NAME)||'%'

Oracle E-Business Suite Show Active Database Sessions Details (Machine, Program, Module, Username, Action,…… )

You can use the following SQL statement to get the full session information (SID, Serial#, Machine, Program, Module, Username, Responsibility,……….).

SELECT S.AUDSID        "AUDSID"  ,
       S.SID           "SID"     ,
       S.SERIAL#       "SERIAL#" ,
       I.INSTANCE_NAME "Instance",
       S.MACHINE       "Machine" ,
       S.TERMINAL      "Terminal",
       S.PROGRAM       "Program" ,
       S.MODULE        "Module"  ,
       S.USERNAME      "Username",
       S.ACTION        "Action"  ,
       S.OSUSER        "OS User" ,       
       S.PROCESS       "Process" ,
       S.STATUS        "Status",
       S.LOGON_TIME    "Logon Time"
  FROM GV$SESSION  S,
       GV$INSTANCE I
 WHERE S.AUDSID > 0
   AND S.INST_ID = I.INST_ID;