new.sql

oracle数据库通用sql工具：检查表空间、监控运行的SQL

检查表空间:
SELECT upper(f.tablespace_name) "TBS Name",

               d.Tot_grootte_Mb " SIZE(M)",

               d.Tot_grootte_Mb - f.total_bytes " USED(M)",

               to_char(round((d.Tot_grootte_Mb - f.total_bytes)

               / d.Tot_grootte_Mb * 100,2),'990.99') "USED%",

               f.total_bytes "FREE(M)",

               f.max_bytes "MAX BLOCK(M)"

         FROM

            (SELECT tablespace_name,

                    round(SUM(bytes)/(1024*1024),2) total_bytes,

                    round(MAX(bytes)/(1024*1024),2) max_bytes

              FROM sys.dba_free_space

             GROUP BY tablespace_name) f,

            (SELECT dd.tablespace_name, round(SUM(dd.bytes)/(1024*1024),2) Tot_grootte_Mb

              FROM   sys.dba_data_files dd

              GROUP BY dd.tablespace_name) d

        WHERE d.tablespace_name = f.tablespace_name

        ORDER BY 4 DESC

监控运行的SQL:
SELECT osuser, username, A.SID,A.SERIAL#, sql_text from v$session a, v$sqltext b

where a.sql_address =b.address

AND a.STATUS='ACTIVE';