Shulou(Shulou.com)06/02 Report--

/ * the SQL instruction is being executed through the operating system pid query * / SELECT * FROM v$sql SQLINFO where SQLINFO.SQL_ID = (SELECT SEN.SQL_ID FROM v$session SEN WHERE SEN.PADDR = (SELECT PRO.ADDR FROM v$process PRO WHERE PRO.SPID = 25832))

/ * find SQL*/SELECT * FROM v$sql SQLINFO WHERE SQLINFO.SQL_ID = (SELECT LONGWAIT.SQL_ID FROM v$session_longops LONGWAIT WHERE LONGWAIT.TIME_REMAINING > 0) with a large waiting queue

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.