---
title: Oracleで特定のOSユーザーが実行中のSQLを出力するSQL
tags: []
categories: ["Middleware", "RDBMS", "Oracle"]
date: 2013-05-08T12:08:10Z
updated: 2013-05-08T12:08:10Z
---

メモ

    select username, osuser, machine, terminal, program, 
    sid, serial#, status, sql_address, sql_text
    from v$session ss, v$sqltext sq
    where type = 'USER'
    	and osuser = XXXXX'
    	and status = 'ACTIVE'
    	and ss.sql_address = sq.address
    order by ss.osuser, ss.sid, ss.serial#, sq.piece