Re: How do You know when LL is free
This will give percentage full stats like onstat -l used to.
I wish I could take credit for this one, but someone gave this to me and I forgot their name.
select uniqid,(used / size * 100) from syslogs
where uniqid >= (select min(tx_loguniq) from systrans
where tx_loguniq > 0)
UNION
select uniqid,0.00 from syslogs
where uniqid < (select min(tx_loguniq) from systrans
where tx_loguniq > 0)
Hope this helps.
Ciao!
.///.
(0 o)
-------------0000--(_)--0000---------------
sstuber@intrlnk.com
oooO Oooo
-------------( )-------( )---------------
\\ ( ) /
\\_) (_/