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

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

You May Also Like

Steps for upgrading weblogic 12.1.2 to 12.1.3
How to install oracle client in silent mode using response file
SGA TARGET ADVISORY IN ORACLE
How to multiplex control file in standalone database
Oracle database Security Assessment Tool
how to change archivelog destination in oracle
How to install OPatch in ORACLE RAC
ESTIMATE REQUIRED DISK SPACE FOR EXPORT USING estimate_only
how to use DBMS_PRIVILEGE_CAPTURE to capture privs in oracle 12c
How to keep or delete columns/Variable of a data frame in R

From This Website

Steps for changing public hostname for a standalone grid infrastructure
ORA-32773: operation not supported for smallfile tablespace
CONTENT parameter in datapump
Useful TFACTL commands
Apply database proactive bundle patch in RAC using manual process
WHAT IS SQL PROFILE IN ORACLE
Rollback database patch in oracle 12c
How to use oratop tool for oracle database monitoring
Oracle database Security Assessment Tool
ORA-16855: transport lag has exceeded specified threshold