1024 shows in hexadecimal in aix

Asked Mar 02 '15 at 02:52

Active Mar 02 '15 at 02:52

Viewed 5,982 times

When I query the dba datafiles for size of db the value is returned in hexadecimal. Is there a db level parameter to be reset or anything else to get the value in number? It is an Aix box

 select sum(bytes)/1024/1024/1024 "gb" from dba_data_files;
         gb
 ----------
 97A1451111

asked Mar 02 '15 at 02:52

anudeepks

1,080
1
12
23

What's the column data type of `bytes`? – ntalbs Mar 02 '15 at 03:15
the datatype is number – anudeepks Mar 02 '15 at 03:28
Which client are you running the query in? – Alex Poole Mar 02 '15 at 08:09
using 11gR2 database – anudeepks Mar 02 '15 at 16:32
we actually have 2 machines, both aix, in both we have same setup, but this problem is observerd in only one machine – anudeepks Mar 02 '15 at 16:33

Sum(bytes)/1024/1024/1024 shows in hexadecimal in aix

0 Answers0