Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
set echo off
-- wr.sql (whats running)
-- Purpose: Display active running SQL commands.
-- -----------------------------------------------------------------------------
column executions format 9999
column username format a10
column sid format 999999
column serial# format 999999
column users_executing format 9999
column sql_text format a50
SELECT a.executions, b.username, b.sid, b.serial#,a.users_executing, a.sql_text
FROM v$sql a, v$session b
WHERE users_executing > 0
AND a.address = b.sql_address
AND a.hash_value = b.sql_hash_value
ORDER BY address, child_number
/
set echo on