---
title: "根据PID查询正在执行的SQL"
author: "hotjava"
date: "2008-05-30T10:24:51Z"
tags: []
slug: "pid-sql"
draft: false
lastmod: "2008-05-30T10:24:51Z"
id: 198559
url: "https://hotjava.iteye.com/blog/198559"
---

select sql\_text  
  from v$sqlarea  
 where address in  
       (select sql\_address  
          from v$session  
         where paddr in (select addr from v$process where spid = 3960912));