#!/bin/bash

ps -e -o pcpu -o pid -o user -o 
args | grep oraclemktdb | sort -k 1| tail -5r
spid=`ps -e -o pcpu -o pid -o user -o 
args | grep oraclemktdb | sort -k 1| tail -5r | awk '{print $2}'`
for i in $spid
do
sqlplus -s /nolog << eof
conn / as sysdba
set feedback off
set linesize 200
set pagesize 70
column spid format 99999
column sid format 99999
column module format a20
column username format a8
column sql_text format a60
select distinct c.spid,b.sid,b.username,
a.module,a.hash_value,sql_text
from v$sql a,v$session b,v$process c
where a.hash_value=b.sql_hash_value and 
a.address=b.sql_address and b.paddr=c.addr and c.spid =$i;
exit
eof
done


－－－－

select a.username, a.sid, a.serial# ,b.sql_text,c.spid
from v$session a, v$sqlarea b,v$process c
where a.username 'hyj'
and a.username is not null
and (a.sql_address = b.address or a.prev_sql_addr = b.address)
and a.paddr=c.addr
and c.spid='860464'