[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Average Row Length

Posted on 2005-04-05
2
Medium Priority
?
484 Views
Last Modified: 2008-03-06
Hi Experts ,
 Could any one tell me whats is the Average Row length of my table how can we caluculate it . I have the following table.
 
  SQL> DESC MYTABLE ;
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
A            NOT NULL NUMBER
B            NOT NULL NUMBER
C            NOT NULL NUMBER
D            NOT NULL NUMBER
E            VARCHAR2(20)
F            NOT NULL VARCHAR2(20)
G            NOT NULL VARCHAR2(15)
H            NOT NULL VARCHAR2(20)
I            NUMBER
J            CHAR(1)
K            CHAR(1)
L            DATE

Regards
0
Comment
Question by:ratnaprasad123
2 Comments
 
LVL 25

Accepted Solution

by:
jrb1 earned 2000 total points
ID: 13712637
You can't tell just from this.  The answer is based on the data in the table.  So, if column F is always length 1, the average row length will be different than if it is always 20.  Luckily, Oracle will tell us the answer.

First do:

analyze table mytable compute statistics;

Then

select avg_row_len from user_tables where table_name = 'MYTABLE';
0
 

Author Comment

by:ratnaprasad123
ID: 13712691
Thank you expert .

0

Featured Post

Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
Creating a Cordova application which allow user to save to/load from his Dropbox account the application database.
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Suggested Courses

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question