SQL Script To Lookup Database Details for a given spid

REM +======================================================================+
REM                    
REM File Name: oraspidinfo.sql
REM 
REM Description:
REM   SQL Script To Lookup Database Details for a given spid
REM   
REM Notes:
REM   Usage: sqlplus "/ as sysdba" @oraspidinfo.sql spid
REM
REM   This Query Requires Oracle SPID as an Input
REM   
REM +======================================================================+

Since this is a large script please click on below link to download and view the SQL Script:

Download(oraspidinfo.sql)