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)
Estimator tool that converts oracle data types to disk storage required [message #646922] Thu, 14 January 2016 15:35 Go to next message
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 Go to previous messageGo to next message
BlackSwan
Messages: 26322
Registered: January 2009
Location: SoCal
Senior Member
query user_tables
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
BlackSwan
Messages: 26322
Registered: January 2009
Location: SoCal
Senior Member
AVG_ROW_LEN * NUM_ROWS = approx table size
It is not rocket size; just simple multiplication.
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 Go to previous messageGo to next message
Michel Cadot
Messages: 66048
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?

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 Go to previous message
EdStevens
Messages: 1020
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.
Previous Topic: Invalid registry$sys_inv_objs; PRODUCT_USER_PROFILE
Next Topic: Is it advisable to prepare catupgrd script for upgrading database
Goto Forum:
  


Current Time: Tue Dec 11 18:50:19 CST 2018