Home » RDBMS Server » Server Administration » Oracle table size (oracle 10g)
Oracle table size [message #283293] Mon, 26 November 2007 10:49 Go to next message
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 #283298 is a reply to message #283293] Mon, 26 November 2007 10:57 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
user_segments check the column bytes.
Re: Oracle table size [message #283303 is a reply to message #283293] Mon, 26 November 2007 11:03 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
DBMS_SPACE.SPACE_USAGE
DBMS_SPACE.UNUSED_SPACE

Regards
Michel
Re: Oracle table size [message #283509 is a reply to message #283293] Tue, 27 November 2007 06:29 Go to previous messageGo to next message
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 #283512 is a reply to message #283509] Tue, 27 November 2007 06:36 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Why do you have a new id?
Why do you want to know this in details?
Did you read Database Concepts and SQL Reference?
All the answers are there.

Regards
Michel
Re: Oracle table size [message #283514 is a reply to message #283512] Tue, 27 November 2007 06:44 Go to previous message
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
Previous Topic: dbms_mview
Next Topic: script
Goto Forum:
  


Current Time: Mon Dec 05 12:50:57 CST 2016

Total time taken to generate the page: 0.10801 seconds