It seems that the column format of col. VALUE is less.
Before giving the first command give the following command
column value
It will display the current column format of column "VALUE"
Now second SELECT doesn't gives any problem 'coz col format is assigned on
col. VALUE not on VALUE + 0.
Just run the following SELECT
select name,value + 0 VALUE from v$sga;
It will also give the same prob.
So bottom line is prblm with column format.
Hope it helps.
Thanks
Harsh
-----Original Message-----
Sent: Thursday, August 23, 2001 2:21 PM
To: Multiple recipients of list ORACLE-L
Hi all,
When I do
Select * from v_$sga;
NAME VALUE
--------------------------- -----------
Fixed Size ###########
Variable Size ###########
Database Buffers ###########
Redo Buffers ###########
Select name, value + 0 from v_$sga;
NAME VALUE
--------------------------- -----------
Fixed Size 69616
Variable Size 16089088
Database Buffers 38010880
Redo Buffers 180224
Do you know what happen with the ####
Thank You
Sinardy
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sinardy
INET: [EMAIL PROTECTED]
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: [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.com
--
Author: Harsh Agrawal
INET: [EMAIL PROTECTED]
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: [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).