Re: DYNAMIC SQL QUANDRY

From: Christopher M. Day <christopher.day_at_rdbms.freeserve.co.uk>
Date: Mon, 12 Apr 1999 22:29:36 +0100
Message-ID: <371265C0.9C390AD4@rdbms.freeserve.co.uk>

Kal121,

If it's statistics on a table that your after why don't you issue 'ANALYZE TABLE nnn COMPUTE STATISTICS', and then query USER_TABLES for AVG_ROW_LEN. There are other interesting stats there too !

Chris.

kal121_at_yahoo.com wrote:
>
> Hello,
>
> Maybe someone out there can help me out here. Basically, I have 2 procedures
> - whose jobs are to automatically calculate the average row length of any
> given table, .....
> END;
> /
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Mon Apr 12 1999 - 16:29:36 CDT