--查询操作系统进程正在执行的SQL（适用于Oracle，linux）

最新推荐文章于 2021-10-19 17:27:00 发布

原创

最新推荐文章于 2021-10-19 17:27:00 发布 · 1.3k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#sql #oracle #linux #behavior #session #url

本文介绍如何在Linux环境下，通过SQL查询获取Oracle数据库进程中正在执行的SQL语句。具体步骤包括从v$process、v$session和v$sqlarea视图中联接数据，通过spid匹配操作系统进程ID，从而查看对应SQL。

<!-- /* Font Definitions */ @font-face {font-family:Courier; panose-1:2 7 4 9 2 2 5 2 4 4; mso-font-charset:0; mso-generic-font-family:modern; mso-font-format:other; mso-font-pitch:fixed; mso-font-signature:3 0 0 0 1 0;} @font-face {font-family:宋体; panose-1:2 1 6 0 3 1 1 1 1 1; mso-font-alt:SimSun; mso-font-charset:134; mso-generic-font-family:auto; mso-font-pitch:variable; mso-font-signature:3 135135232 16 0 262145 0;} @font-face {font-family:黑体; panose-1:2 1 6 0 3 1 1 1 1 1; mso-font-alt:SimHei; mso-font-charset:134; mso-generic-font-family:auto; mso-font-pitch:variable; mso-font-signature:1 135135232 16 0 262144 0;} @font-face {font-family:"/@宋体"; panose-1:2 1 6 0 3 1 1 1 1 1; mso-font-charset:134; mso-generic-font-family:auto; mso-font-pitch:variable; mso-font-signature:3 135135232 16 0 262145 0;} @font-face {font-family:"/@黑体"; panose-1:2 1 6 0 3 1 1 1 1 1; mso-font-charset:134; mso-generic-font-family:auto; mso-font-pitch:variable; mso-font-signature:1 135135232 16 0 262144 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-parent:""; margin:0cm; margin-bottom:.0001pt; text-align:justify; text-justify:inter-ideograph; mso-pagination:none; font-size:10.5pt; mso-bidi-font-size:12.0pt; font-family:"Times New Roman"; mso-fareast-font-family:宋体; mso-font-kerning:1.0pt;} p.Char, li.Char, div.Char {mso-style-name:" Char"; mso-style-parent:""; mso-style-link:默认段落字体; mso-style-next:正文; margin-top:12.0pt; margin-right:0cm; margin-bottom:12.0pt; margin-left:0cm; text-indent:-31.2pt; mso-pagination:widow-orphan lines-together; page-break-after:avoid; mso-outline-level:8; font-size:10.5pt; font-family:Arial; mso-fareast-font-family:黑体; layout-grid-mode:line;} /* Page Definitions */ @page {mso-page-border-surround-header:no; mso-page-border-surround-footer:no;} @page Section1 {size:595.3pt 841.9pt; margin:72.