Re: error in the output


"BS" <minimyme@xxxxxxxxx> wrote in message
news:1146238188.396992.152890@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi,

I'm new to the oracle world and trying to find out the size of my
oracle database. I ran the query as below and not getting the correct
result back. Any pointer please??

SVRMGR> select sum(BYTES) from DBA_DATA_FILES;
SUM(BYTES)
----------
4.2001E+10
1 row selected.


Perfectly correct answer - in scientific notation. 4.2001E+10 = 42001000000.
What's your Oracle version? svrmgrl was deprecated and obsoleted long ago.


--
Vladimir M Zakharychev
N-Networks, makers of Dynamic PSP(tm)
http://www.dynamicpsp.com


.

Relevant Pages

  • Re: Views - performance
    ... when u use stored object views oracle has to read the data dictionary ... this includes lots of steps for execution ... semantics of the query and fires it ... you'll possibly have any idea is to use explain plan to provide a base ...
    (comp.databases.oracle.server)
  • RE: DBI-1.48 bind_param_inout produces ORA-01461 colliding with a CLOB
    ... can pass strings as varchar's and have them inserted ... In theory I could write something to query the ... CLOB w/in Oracle is probably what is killing me... ...
    (perl.dbi.users)
  • Re: Equilevant of Oracle for optional records
    ... and a normalized t2 could be more useful, to build the query, and once this ... the Iqaluit Trauma: ... Oracle handles this data structure perfectly but I suspect it might be ...
    (microsoft.public.access.queries)
  • Re: Equilevant of Oracle for optional records
    ... this query is done, then flatten the result? ... example, the Iqaluit Trauma: ... Oracle handles this data structure perfectly but I suspect it might be ...
    (microsoft.public.access.queries)
  • Re: Help!
    ... I have an Oracle database with a simple table in it ... > and a query that returns maybe 25k records. ... > profile - 6 seconds sqlplus, mintes with DBI, talking to Oracle. ...
    (perl.dbi.users)