---
title: "根据进程号查询正在执行SQL语句"
author: "hotjava"
date: "2008-04-26T11:48:45Z"
tags: []
slug: "sql"
draft: false
lastmod: "2008-04-26T11:48:45Z"
id: 187029
url: "https://hotjava.iteye.com/blog/187029"
---

当某oracle进程占用CPU较高的时候，可以根据如下语句来查询究竟是哪一条语句正在执行。

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 = 831734));