TBfree

Discussion in 'Pro/Engineer & Creo Elements/Pro' started by ffe, Sep 4, 2006.

  1. ffe

    ffe Guest

    Ich würde gern das ergebnis diese skript in eine Email od SMS an mich
    senden lassen. HAt jemand eine Idee?

    SELECT s.tablespace_name tsname
    , TO_CHAR(s.tsfree/1024, '999,999,990') tsfree
    , TO_CHAR(f.tssize/1024, '999,999,990') tssize
    , TO_CHAR(100-((s.tsfree / f.tssize)*100), '990')||'%' pctused
    FROM (SELECT tablespace_name
    , SUM (bytes) tsfree
    FROM dba_free_space
    GROUP BY tablespace_name
    ) s
    , (SELECT tablespace_name
    , sum (bytes) tssize
    FROM dba_data_files
    GROUP BY tablespace_name
    ) f
    WHERE s.tablespace_name = f.tablespace_name
    UNION
    SELECT '__Overall sum__'
    , TO_CHAR(SUM(s.tsfree)/1024, '999,999,990') tsfree
    , TO_CHAR(SUM(f.tssize)/1024, '999,999,990') tssize
    , TO_CHAR(100-((SUM(s.tsfree) / SUM(f.tssize))*100), '990')||'%'
    pctused
    FROM (SELECT tablespace_name
    , SUM (bytes) tsfree
    FROM dba_free_space
    GROUP BY tablespace_name
    ) s
    , (SELECT tablespace_name
    , sum (bytes) tssize
    FROM dba_data_files
    GROUP BY tablespace_name
    ) f
    WHERE s.tablespace_name = f.tablespace_name
    /
     
    ffe, Sep 4, 2006
    #1
Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
There are no similar threads yet.
Loading...