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.