Calculation of Avg.Row Length/Avg.Column Length of tables!
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

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

  1. #1
    Join Date
    Feb 2001
    Posts
    286
    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.


    Share on Google+

  2. #2
    Join Date
    Apr 2001
    Location
    London
    Posts
    725
    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.


    Once you have eliminated all of the impossible,
    whatever remains however improbable,
    must be true.
    Share on Google+

  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    dont MULTI-POSTING amitstora please

    closing
    Share on Google+

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width