Shulou(Shulou.com)05/31 Report--

This article mainly introduces how to view the content of the SQL statement corresponding to oracle according to the process number of the operating system, which has a certain reference value, and interested friends can refer to it. I hope you will gain a lot after reading this article.

1. Use ps-aux to query first, and find a process that takes up a lot of CPU and record the PID.

2. Check which session is executing what SQL statement, and what is the process number:

2.1 View the corresponding sql for all sessions

SELECT c.spid,b.sql_text, a.sid, a.serial#, osuser, machine

FROM v$session a, v$sqlarea b, v$process c

WHERE a.sql_address = b.address and a.paddr=c.addr

2.2 View the sql content corresponding to a session

SELECT c.spid,b.sql_text, a.sid, a.serial#, osuser, machine

FROM v$session a, v$sqlarea b, v$process c

WHERE a.sql_address = b.address and a.paddr=c.addr and spid=&pid

3. You can find out what the wait event is with the statement select * from v$session_wait where sid=.

4. Top-d pid can observe the real-time status of a process

Thank you for reading this article carefully. I hope the article "how to check the content of SQL sentences corresponding to oracle according to the process number of the operating system" shared by the editor will be helpful to everyone. At the same time, I also hope that you will support and follow the industry information channel. More related knowledge is waiting for you to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.