could be... it's been so long since I had access to a functional OEM... :'( I'm actually starting to remember most of sqlplus' 'set' commands... which isn't entirely bad in itself... you know. Alan Bort Oracle Certified Professional On Tue, Mar 17, 2009 at 11:35 AM, Niall Litchfield <niall.litchfield@xxxxxxxxx> wrote: > You could play with scripting emcli which I haven't tried, you could use the > DBMS_SERVER_ALERT package which I have used. I imagine that quest might be > similarly scriptable. > > On Mon, Mar 16, 2009 at 6:34 PM, Howard Latham <howard.latham@xxxxxxxxx> > wrote: >> >> I have spotlight and use OEM however >> this doesn't allow me to dynamically set the thresholds for table size so >> I can say find that >> tablespace data now needs at least 10g of space not 5g due to a trend in >> data size. >> This would make my weekends quieter so I can play more Ratchet and Clank >> with the boy! >> Anyone got a good way of doing this? It would be great to feed those >> numbers directly >> into OEM but I cant see a way of doing this and I don't really want yet >> another tool to monitor. >> >> -- >> Howard A. Latham >> >> > > > > -- > Niall Litchfield > Oracle DBA > http://www.orawin.info > -- //www.freelists.org/webpage/oracle-l