Hi everybody
I'm looking for a way to help with space estimations.
Basic idea:
- Run DDLs to create schema.
- Read dba_tab_columns to get the tables, columns (with data types and
sizes) for the schema
- Add the maximum possible length for each column for each table
Problem:
With max(vsize(myColumn)), I'll only get values for current data that's
already been filled into the table.
Is there anything like limits.h in C, that I can check to get the max values
for FLOAT, INTEGER, NUMBER etc., without having to do something like "select
vsize(max_number_value_for_certain_precision) from dual" ?
Or would it be more reasonable to do something like that: e.g. found a
column like "blah NUMBER(4,2)" in the dictionary, then build a statement
like "select vsize(to_number('99.99') from dual" to be run via dynamic sql ?
Any input ?
Regards,
Stefan Jahnke
Consultant
BOV Aktiengesellschaft
Voice: +49 201 - 4513-298
Fax: +49 201 - 4513-149
mailto: [EMAIL PROTECTED]
Please remove nospam to contact me via email.
visit our website: http://www.bov.de
subscribe to our newsletter: http://www.bov.de/presse/newsletter.asp
Sicherheitsluecken mit IT-Security-Konzepten von BOV effizient schliessen!
Weitere Informationen unter +49 201/45 13-240 oder E-Mail an
mailto:[EMAIL PROTECTED]
Wie Sie wissen, koennen ueber das Internet versandte E-Mails leicht unter
fremden Namen erstellt oder manipuliert werden. Aus diesem Grunde bitten
wir um Verstaendnis dafuer, dass wir zu Ihrem und unserem Schutz die
rechtliche Verbindlichkeit der vorstehenden Erklaerungen und Aeusserungen
ausschliessen.
As you are probably aware, e-mails sent via the Internet can easily be
copied or manipulated by third parties. For this reason we would ask for
your understanding that, for your own protection and ours, we must decline
all legal responsibility for the validity of the statements and comments
given above.
-----Ursprüngliche Nachricht-----
Von: Jonathan Lewis [mailto:[EMAIL PROTECTED]
Gesendet: Donnerstag, 20. März 2003 09:14
An: Multiple recipients of list ORACLE-L
Betreff: Re: Number of bytes used by number data type
See notes on
http://www.jlcomp.demon.co.uk/faq/num_size.html
There's also a note on the site (though not in the FAQ)
about reading internal formats and working out what
number it represents.
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Now available One-day tutorials:
Cost Based Optimisation
Trouble-shooting and Tuning
Indexing Strategies
(see http://www.jlcomp.demon.co.uk/tutorial.html )
____UK_______April 8th
____UK_______April 22nd
____Denmark May 21-23rd
____USA_(FL)_May 2nd
Next dates for the 3-day seminar:
(see http://www.jlcomp.demon.co.uk/seminar.html )
____UK_(Manchester)_May
____USA_(CA, TX)_August
The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: 19 March 2003 22:18
> Guru's
>
> I want to find out the exact space occupied by a number field. E.g I
want to
> find out the space occupied by a field
> NUMBER(7,2). I know oracle has an alogorithm to figure that out .
>
> A quick response would be highly appreciated
>
>
> RJ
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jonathan Lewis
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stefan Jahnke
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
