When I run this scripts why is slow?
It seems when I reboot it runs fine. But after few days later it gradually slows down.
Any input would greatly appreciate.
Many thanks.
SELECT OSUSER,
SQL_TEXT
FROM V$SESSION, V$SQL
WHERE V$SESSION.SQL_ADDRESS = V$SQL.ADDRESS
AND V$SESSION.STATUS = 'ACTIVE';