THIS ALSO HELP
select sum(bytes/1024/1024) from dba_segments where segment_name='LOG';

To get size in mags


Regards,
Mzwandile Zwane

-----Original Message-----
From: Daniel
[mailto:oracledba-ezmlmshield-x57856245.[Email address protected]
Sent: 07 May 2007 02:55 PM
To: LazyDBA Discussion
Subject: RE: Actual size of data in a table

Hi,

Try so:


select sum(bytes) from dba_segments where segment_name='LOG';



Dani

>-----Original Message-----
>From: ext Leinen Christian (EXT)
>[mailto:oracledba-ezmlmshield-x66150958.[Email address protected]
>Sent: 07 May, 2007 15:52
>To: LazyDBA Discussion
>Subject: Actual size of data in a table
>
>Hi all,
>
>how can i query the actual size of data in a table? Querying
>sum(bytes) from user_segments will return the size of the extents that
>have been allocated, right?
>
>
>Chris
>
>
>---------------------------------------------------------------------
>TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post
>a dba job: http://jobs.lazydba.com To Subscribe :
>http://www.LazyDBA.com To unsubscribe:
>http://www.lazydba.com/unsubscribe.html
>
>
>


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



___________________________________________________________

Important Notice:
Authorised Financial Services Provider

Important restrictions, qualifications and disclaimers
("the Disclaimer") apply to this email. To read this click on the
following address or copy into your Internet browser:

http://www.absa.co.za/disclaimer

The Disclaimer forms part of the content of this email in terms of
section 11 of the Electronic Communications and Transactions
Act, 25 of 2002.

If you are unable to access the Disclaimer, send a blank e-mail
to [Email address protected] and we will send you a copy of the
Disclaimer.

Oracle LazyDBA home page