rem ********************************************************************
rem * Filename          : %M% - Version %I%
rem * Author            : Dave Cook
rem * Original          : 28-FEB-95
rem * Last Update       : %H% - %T%
rem * Description       : Shows the stats for a given session
rem *                     capacity planning purposes.
rem * Usage             : start sess.sql <date>  e.g. 03-MAR-95
rem *                                        <Program Name>
rem *                                        <Max run time (min.)>
rem *
rem ********************************************************************

accept tty prompt "Enter your tty (e.g. pts/68):"
select sid     "Session id",
       osuser  "OS user",
       spid    "OS pid",
       process "Ora pid"
from v$process p,
     v$session s
where p.addr=s.addr
  and  s.terminal='&tty';

