Forgot your password?    
+ Reply to Thread
Results 1 to 3 of 3

Thread: process to find out SID

  1. #1
    Oracle DBA
    Join Date
    Feb 2012
    Posts
    4

    process to find out SID

    How we will find out the SID from a OS PID(in top command) Plz tell tht which script

  2. #2
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Location
    New Delhi, India
    Posts
    427
    Here it is :

    set pages 1000
    set linesize 190
    col username for a10
    select b.status,a.inst_id,a.PID "Ora PID",b.SID "Server PID",
    a.LATCHWAIT,b.Program, b.Username,b.Osuser,b.machine,
    b.terminal,a.terminal,b.Process "Client Process"
    from gv$process a,gv$session b where a.addr=b.paddr and a.spid=&1
    /

  3. #3
    Oracle DBA
    Join Date
    Feb 2012
    Posts
    4
    Thanks Hemant Sir

+ Reply to Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

DBA Lounge (P) Ltd. deals in Oracle Technologies on Consulting, Resourcing, Corporate Training


Online and corporate training available on Oracle Database 11g, Oracle 11g Real Application Cluster (RAC), Oracle Applications 11i/R12, Oracle Fusion Middleware 11g, Oracle Identity Management-OIM, Oracle Internet Directory 11g-OID, Oracle Business Intelligence Enterprise Edition-OBIEE, Oracle Golden Gate, Oracle Access Management-OAM, Oracle Internet Directory-ODS, Oracle Identity Analytics Architecture-OIA Statistics