OraFAQ Forum: Server Administration » Estimator tool that converts oracle data types to disk storage required

Home » RDBMS Server » Server Administration » Estimator tool that converts oracle data types to disk storage required ( Oracle DB Enterprise Edition11.2.0.4. Red Hat Linux 5)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Estimator tool that converts oracle data types to disk storage required [message #646922]

Thu, 14 January 2016 15:35

PBG789
Messages: 7
Registered: December 2015

Junior Member

Is there a tool/estimator that can be used to calculate row length of a table?

[Updated on: Thu, 14 January 2016 15:35]

Report message to a moderator

Re: Estimator tool that converts oracle data types to disk storage required [message #646924 is a reply to message #646922]

Thu, 14 January 2016 15:51

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

query user_tables

Report message to a moderator

Re: Estimator tool that converts oracle data types to disk storage required [message #646933 is a reply to message #646924]

Thu, 14 January 2016 22:51

PBG789
Messages: 7
Registered: December 2015

Junior Member

Thankyou BlackSwan.

I meant something like the nbd_size.pl utility in MySQL which helps to estimate storage requirements.

Looking for something similar in oracle which helps to calculate/estimate storage requirement for a table column structure/data types.

I was looking at the following link but could find anything similar for Oracle.

https://docs.oracle.com/cd/E17952_01/refman-5.5-en/storage-requirements.html

[Updated on: Thu, 14 January 2016 22:54]

Report message to a moderator

Re: Estimator tool that converts oracle data types to disk storage required [message #646935 is a reply to message #646933]

Thu, 14 January 2016 22:57

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

AVG_ROW_LEN * NUM_ROWS = approx table size
It is not rocket size; just simple multiplication.

Report message to a moderator

Re: Estimator tool that converts oracle data types to disk storage required [message #646938 is a reply to message #646933]

Fri, 15 January 2016 01:38

Michel Cadot
Messages: 68348
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

PBG789 wrote on Fri, 15 January 2016 05:51

I meant something like the nbd_size.pl utility in MySQL which helps to estimate storage requirements.

What does exactly do nbd_size.pl? Input? Output?

Report message to a moderator

Re: Estimator tool that converts oracle data types to disk storage required [message #646959 is a reply to message #646933]

Fri, 15 January 2016 06:40

EdStevens
Messages: 1375
Registered: September 2013

Senior Member

PBG789 wrote on Thu, 14 January 2016 22:51

Thankyou BlackSwan.

I meant something like the nbd_size.pl

If you have a solution for another rdbms, and and you have the source for that solution (as suggested by the .pl extension indicating it is written in Pearl) I'd think it not too difficult to modify that for Oracle.

Report message to a moderator

Previous Topic:	Invalid registry$sys_inv_objs; PRODUCT_USER_PROFILE
Next Topic:	Is it advisable to prepare catupgrd script for upgrading database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 06 09:21:43 CST 2023