---
title: " 根据sid查询SQL"
author: "hotjava"
date: "2008-05-22T11:56:39Z"
tags: []
slug: "sid-sql"
draft: false
lastmod: "2008-05-22T11:56:39Z"
id: 195582
url: "https://hotjava.iteye.com/blog/195582"
---

select t2.sid, t2.serial#, t3.sql\_text  
  from v$session t2, v$sqltext t3  
 where t2.sid in (1480)  
   and t2.sql\_address = t3.address