Home » RDBMS Server » Server Administration » need to calculate average_row length for table
need to calculate average_row length for table [message #62404] Tue, 20 July 2004 12:42 Go to next message
Joan
Messages: 36
Registered: February 2002
Member
I need to calculate average row length for my database and was kind of curious to what is best way.

Eg. table aaaaa

   ID                                        NOT NULL NUMBER(19)
 NAME                                      NOT NULL VARCHAR2(64)
 INTERVAL                                           NUMBER(38)
 LASTMODIFIED                                       DATE

according to dba_tab_columns the data lengths for all data and number datatype is date -7 and number 22 regardless of what is define on the table.

Which number should I use to calculate the average row length?  the one on desc table or from dba_tab_columns.

Also what is best way to calculate the average row length.  I have used different formula with different resul

 

 

Report message to a moderator

Re: need to calculate average_row length for table [message #62421 is a reply to message #62404] Wed, 21 July 2004 03:58 Go to previous message
Anu
Messages: 82
Registered: May 2000
Member
HI!
do the following steps:
1. analyze table aaaa compute statistics;

2. select avg_row_len from user_tables where table_name='AAAA';

hope it would help u
regards

Report message to a moderator

Previous Topic: Trouble creating Users Via Web Front End
Next Topic: want to monitoring a pl/sql block
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Jan 09 03:51:01 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.