command Window truncates numeric collumns

O

orca777

Member³
Hi, i am usually still on 5.1.x
but on 6.x Beta it was the same.

Selected size if temporay tablespace which was set to 16 G!

Code: 
SQL> select * from dba_temp_files;

FILE_NAME                                                                           FILE_ID TABLESPACE_NAME                     BYTES     BLOCKS STATUS    RELATIVE_FNO AUTOEXTENSIBLE   MAXBYTES  MAXBLOCKS INCREMENT_BY USER_BYTES USER_BLOCKS
-------------------------------------------------------------------------------- ---------- ------------------------------ ---------- ---------- --------- ------------ -------------- ---------- ---------- ------------ ---------- -----------
/data/rpmsdbp1/RPMS_P01/data01/temp/RPMS_P01_temp01.dbf                                   1 TEMP                           1717986918    2097152 AVAILABLE            1 NO                      0          0            0 1717882060     2097024

SQL>
but 1717882060 is only 1.6G!!!!

with SQL*PLUS it shows this

Code: 
SQL>
SQL>
SQL>
SQL> select * from dba_temp_files;

FILE_NAME
--------------------------------------------------------------------------------
   FILE_ID TABLESPACE_NAME                     BYTES     BLOCKS STATUS
---------- ------------------------------ ---------- ---------- ---------
RELATIVE_FNO AUT   MAXBYTES  MAXBLOCKS INCREMENT_BY USER_BYTES USER_BLOCKS
------------ --- ---------- ---------- ------------ ---------- -----------
/data/rpmsdbp1/RPMS_P01/data01/temp/RPMS_P01_temp01.dbf
         1 TEMP                           1.7180E+10    2097152 AVAILABLE
           1 NO           0          0            0 1.7179E+10     2097024

SQL>

this is really 16G!!
SQLWindow is correct :

Code: 
FILE_NAME	FILE_ID	TABLESPACE_NAME	BYTES	BLOCKS	STATUS	RELATIVE_FNO	AUTOEXTENSIBLE	MAXBYTES	MAXBLOCKS	INCREMENT_BY	USER_BYTES	USER_BLOCKS
/data/rpmsdbp1/RPMS_P01/data01/temp/RPMS_P01_temp01.dbf	1	TEMP	17179869184	2097152	AVAILABLE	1	NO	0	0	0	17178820608	2097024
This mus be fixed,
thanks in advance

Carl r.
 
The Command Window will display numbers with more that 9 digits precision in a scientific notation. Currently the only work around for this is to use the to_char() function in your query.
 
Hi Marco,
it does not switch to scientifc format, it simple truncates :


Code: 
BYTES
----------
1717986918
the (correct) output should be : 17179869184 or 1.7179E+10

regards
Carl
 
Okay, this may require that you use the "SET NUMWIDTH" command to increase the maximum number width for numbers without precision. You can set an appropriate default value in the login.sql file.
 
You must log in or register to reply here.
Back
Top