Calculation of Avg.Row Length/Avg.Column Length of tables!

[amitstora]

Hi all!

Query:

1.If I need to calculate the Avg. Row length of a table say EMP under SCOTT schema,is the
process correct as below:

At first I had analyzed the table as:

ANALYZE TABLE SCOTT.EMP COMPUTE STATISTICS;

Then I query DBA_TABLES:


SQL> select avg_row_len,avg_space from dba_tables
2 where owner = 'SCOTT'
3 and table_name = 'EMP';

AVG_ROW_LEN AVG_SPACE
----------- ----------
41 3383

SQL> select count(*) from scott.emp;

COUNT(*)
----------
14

SQL>

The above query shows:

1.AVG_ROW_LEN = 41 bytes.
2.No.of Rows Count(*) = 14.

In order to fix the Oracle Block Size,do I have to multiply 41 * 14 being the
Avg_Row_Len * No.of rows which should give the figure in bytes!


In addition to the above,how should i calculate Avg.column length of the same table.


2.Does anybody know how and where to contact METALINK in order to become a registered member
of Oracle's metalink's site.

Each time I login to metalink.oracle.com site,it keeps on asking LOCAL SUPPORT IDENTIFIER
IN THE 1ST LOGIN SCREEN!

Now How and where should I get Local support identifier to become a registered oracle's
Metalink member!What is this Local support identifier all about!

Thanks&Regards,

Amit.

[Sureshy]

Read the link supplied by padman to understand more about your first question.

http://www.dbasupport.com/forums/sho...threadid=18765

You need to have a support contract with Oracle to access metalink. Your company will have to pay them. In return you will get a support identifier which will grant you access.

[pando]

dont MULTI-POSTING amitstora please

closing