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
>
>
>

Oracle LazyDBA home page