-
How to know the actual size of a row
Hi All,
I want to know
1. The size of a table in bytes.
2. Size of the actual data in the table ( in bytes).
3. If I enter 5 rows in it , how much does it increase (in bytes).
Will anybody help me out .
Thanks in advance.
-
Re: How to know the actual size of a row
Originally posted by ayushsingh
1. The size of a table in bytes.
2. Size of the actual data in the table ( in bytes).
3. If I enter 5 rows in it , how much does it increase (in bytes).
DBMS_STATS.GATHER_TAB_STATS
Oracle Certified Master - September, 2003, the Second OCM in China
*** LOOKING for PART TIME JOB***
Data Warehouse & Business Intelligence Expert
MCSE, CCNA, SCJP, SCSA from 1998
-
hi Calvin,
Thanks for a quick reply.
Isn't it possible to get these figures via some data dictionary views (like dba_segments.bytes)
-
Dictionary View can answer your first question.
Oracle Certified Master - September, 2003, the Second OCM in China
*** LOOKING for PART TIME JOB***
Data Warehouse & Business Intelligence Expert
MCSE, CCNA, SCJP, SCSA from 1998
-
After Analyze your tables computing statistics.. you can check DBA_TABLES.
Fields relevant for you analysis will be:
BLOCKS
EMPTY_CLOCKS
NUM_ROWS
AVG_ROW_LEN
and your
DB_BLOCK_SIZE
Only do the math for your requirements...
-
Hi,
to find the actual size of data in table,
1) analyze the table to compute statistics
2) retrieve these column data among others: num_rows, avg_row_len, empty_blocks
3) > select num_rows*avg_row_len from user_tables where table_name='your table';
Hope this will help you,
Kiran
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|