| Oracle table size [message #283293] |
Mon, 26 November 2007 10:49  |
shajoe
Messages: 1
Registered: November 2007
|
Junior Member |
|
|
Hi,
I have a table with 2 columns C1 varchar(40) and C2 number(22,0).
I had inserted 10000 rows in that table where the varchar's actual size is 3 and the number's actual precision is 10.
I want to calculate the exact size (in bytes) occupied by this table (not the allocated size or just the total row size).
How can I calculate that. This size should include the total row size and all the overheads for that table.
Thanks in advance
sha
|
|
|
|
|
|
|
|
| Re: Oracle table size [message #283509 is a reply to message #283293] |
Tue, 27 November 2007 06:29  |
sharjoe
Messages: 4
Registered: November 2007
|
Junior Member |
|
|
Hi,
Thanks for your reply.
I have another question.
1.What are the various overheads that oracle has in storing the data.ie., For the same example given before what are the other overheads (like row overhead, header overhead etc) that a table has?
2.How many bytes does a varchar2 and number datatypes occupy in oracle 10g?
3.How does oracle manage null values in the table?
Thanks
sha
|
|
|
|
|
|
| Re: Oracle table size [message #283514 is a reply to message #283512] |
Tue, 27 November 2007 06:44 |
sharjoe
Messages: 4
Registered: November 2007
|
Junior Member |
|
|
Hi
Thanks. Ill check those links.
I created a new id becoz it was invalidating my password and was not accepting the new reset password.
Thanks
again
sha
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
