Below is the script to find the respective sid of an server proccess id.

col sid format 999999 
col username format a20 
col osuser format a15 
select b.spid,a.sid, a.serial#,a.username, a.osuser 
from v$session a, v$process b 
where a.paddr= b.addr 
and b.spid='&spid' 
order by b.spid;

SEE ALSO - Get ospid from sid

ospidsid DATABASE SCRIPTS


Related Topics

Script to get cpu usage and wait event information in oracle database
Find sessions consuming lot of CPU
Find the active transactions in oracle database
Find pending distributed pending transactions in oracle
How to find execution history of an sql_id
Find user commits per minute in oracle database
How to find cpu and memory information of oracle database server
How to monitor parallel queries in oracle db
How to get tablespace quota details of an user in oracle
Get sid from ospid

You May Also Like

Important views in For Oracle DBA in daily usage
ORA-16855: transport lag has exceeded specified threshold
OUTBOUND_DBLINK_PROTOCOLS in oracle 12.2
SQLCL UTILITY IN ORACLE
How to Read CSV files in R studio
How to deinstall/cleanup standalone grid infrastructure
how to use DBMS_PRIVILEGE_CAPTURE to capture privs in oracle 12c
SAMPLE parameter in EXPDP to export subset of data
resumable_timeout parameter in oracle database
Shell script for monitoring Alert log

From This Website

how to send mail using utl_mail in oracle 11g
Unified audit trail in Oracle 12c
ESTIMATE REQUIRED DISK SPACE FOR EXPORT USING estimate_only
How to start MySQL on Linux and Windows
Exception in thread -main" java.lang.OutOfMemoryError: GC overhead limit exceeded with bsu.sh
How to add a tempfile in primary database in dataguard
Perform Flashback in pluggable database(PDB) in oracle 12.2
How to install oracle client in silent mode using response file
PDB Lockdown Profiles in Oracle 12.2
How to change the case (Lower to Upper and Vice Versa) in R