ROW SIZE SCRIPT

[oracle8]

hi!

Pls. send me a script on how to find the average row size of a particular table. I'm using oracle 8.05

thanks

 

[SantaMufasa]

Oracle8,

Here is, by far, the best method for finding average row length:

analyze table <table_name> compute statistics;
select avg_row_len from user_tables where table_name = '<table_name>';

If you do not wish to retain the table's statistics, you can remove them with this command:

analyze table SDPC_ZIP_CODE delete statistics;

Let us know if this resolves your need.

Mufasa
(aka Dave of Sandy, Utah, USA @ 06:17 (21Jul04) UTC (aka "GMT" and "Zulu"), 23:17 (20Jul04) Mountain Time)

 

[oracle8]

Thanks dave... you're such a great help in this forum keep up the good work.

Rommel