| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: v$sgastat
Number datatype does not waste space if the column data type is larger than the stored number.
Take a look at
http://www.vampired.net/forums/viewtopic.php?topic=24&forum=15&0 to see how
number data types are stored.
"Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes."
Christopher R. Spence
Oracle DBA
Phone: (978) 322-5744
Fax: (707) 885-2275
Fuelspot
73 Princeton Street
North, Chelmsford 01863
-----Original Message-----
[mailto:Shrinivas.Tatireddy_at_med.ge.com]
Sent: Saturday, August 25, 2001 7:20 AM
To: Multiple recipients of list ORACLE-L
Hi lists
what is the precision of the number datatype, if not in a table.
is it 1 or 32.
(in v$sgastat the column bytes doesn't have precision,scale mentioned. this column values should be stored in our routine tables.)
If I take the maximum ,I may be wasting the space.
can anybody advise how much precision do I take?
and is there any way to find from what x$ tables this is (v$sgastat) built . I didnt find it is dependencies table.
thnx in advance
srinivas.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tatireddy, Shrinivas (MED, Keane)
INET: Shrinivas.Tatireddy_at_med.ge.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (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).
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (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). Received on Mon Aug 27 2001 - 08:50:12 CDT
 |
 |