| Size of one row in table [message #21393] |
Thu, 01 August 2002 01:41  |
rajesh
Messages: 173
Registered: November 1998
|
Senior Member |
|
|
My emp table has the follwing column details
empno number(4)
ename varchar2(10)
job varchar2(9)
mgr number(4)
hiredate date
sal number(7,2)
comm number(7,2)
deptno number(2)
What will be the size of one row of data? How do i do the calculation?
|
|
|
|
| Re: Size of one row in table [message #21406 is a reply to message #21393] |
Thu, 01 August 2002 09:28  |
andrew again
Messages: 2577
Registered: March 2000
|
Senior Member |
|
|
It is good to have a reasonable idea of how much space will be used by your tables, and indexes, but trying to work it out exactly is rarely worth the effort (especially with Compression available in 9i). By far the easiest way in your case would be to insert a few rows into emp and then analyze the table.
analyze table EMP compute statistics;
select table_name, num_rows, avg_row_len from user_tables where table_name = 'EMP';
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
