Re: tables

From: <daud11_at_hotmail.com>
Date: Wed, 28 Oct 1998 07:48:38 GMT
Message-ID: <716i8m$akc$1@nnrp1.dejanews.com>

Thanks for your reply Horace,

I have actually written a script to produce a report of the list of tables in OED tablespace and the size of each table (getting it from dba_segments). However, I will have to execute the script daily over a number of days before I can find out which tables have been growing very fast. I was hoping for a better and easier solution.

regards
Daud

> Daud,
>
> If you perform full export in daily basis, then you can compare the
> export log. You can try to find out the segment size of all tables in
> your tablespace by querying dba_segments. Hope that it can help you.
>
> Horace

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Oct 28 1998 - 01:48:38 CST