Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> analyze

analyze

From: Sudheer Tummala <sut_at_ordinal.micro.lucent.com>
Date: 1997/09/25
Message-ID: <342A8134.7ACF@ordinal.micro.lucent.com>#1/1

I am using ANALYZE TABLE <table_name> COMPUTE STATISTICS; and then selecting table_name, avg_row_len from dba_statistics to get the average lrow length in each table.

What I want to know is, does the avg_row_len column in dba_tables inlude Header space per row also?

sut_at_orsunsut.micro.lucent.com

-- 

***********************************
Sudheer Tummala
***********************************
Received on Thu Sep 25 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US