Re: tables

On Wed, 28 Oct 1998 07:48:38 GMT, daud11_at_hotmail.com wrote:

If you are not bothered about heuristics, you could also ANALYZE ESTIMATE each table and compare NUM_ROWS.

Regards,
Jason.

>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 Thu Oct 29 1998 - 06:31:50 CST