Re: space alert report

From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Wed, 1 Jun 2016 22:06:26 -0400
Message-ID: <574F94A2.2010700_at_gmail.com>

On 06/01/2016 09:04 AM, Zelli, Brian wrote:
> Wrote a quick little space report to email myself. Looks like this on the unix box:
>
> TABLESPACE_NAME CurMb MaxMb TotalUsed PotentialFree UPercent
> ------------------------- ---------- ---------- ------------ ----------------- ----------
> IDX 52767.9844 52767.9844 48800.9844 3967 92
> TEMP 3000 3000 2990 10 100
>
>
> Comes out like this in the email body:
>
>
> TABLESPACE_NAME CurMb MaxMb TotalUsed PotentialFree UPercent
> --------------- ---------- ---------- ---------- ------------- ----------
> IDX 52767.9844 52767.9844 48800.9844 3967 92
> TEMP 3000 3000 2990 10 100
>
> How can I format it better?
>
> Brian
>

Have you tried with HTML? SQL*Plus can format output in HTML using "set markup html on" and most of the popular email reading programs like Thunderbird, Outlook or Opera Mail have the ability to interpret HTML correctly. Also, you can try with the "round" function to get rid of surplus decimal places. You can also format the number in hex, which looks smart.

-- 
Mladen Gogala
Oracle DBA
http://mgogala.freehostia.com

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Jun 02 2016 - 04:06:26 CEST