-
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.
-
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.
-
dont MULTI-POSTING amitstora please
closing
