Re: Size of a table using OEM

On the OEM page, click on Administration tab.  This will take you to the
admin page.  Under Schemas, select tables.  Then enetr the schema name and
table name and click on Go.  This will bring the table underneath.  Click on
the table, and this will give all the info about the table average size of
the row, and the # of rows,  as below:
  Last Analyzed  Mar 10, 2008 9:10:52 AM   Empty Blocks  0   Average Space
(Bytes)  0   Number of Rows  90000   Sample Size  90000   Average Row Length
(Bytes)  123   Continued Row Count  0   Average Space Freelist Blocks
0   Number
of Freelist Blocks  0

  However, this doesn't give exactly what you asked for.  May be this query
will help:


*

select* OWNER, segment_name *as* table_name, *sum*(bytes)/1048576 Size_MB
*

from* dba_segments

*where* owner = 'RAM32'

*and* segment_type *in* ('TABLE')
*

and* segment_name = 'EQUIPMENT_REMARK'
*

GROUP* *BY* OWNER, SEGMENT_NAME
*

ORDER* *BY* OWNER, segment_name;
  Thanks.

Ram Srinivasan
==============

On Wed, Mar 26, 2008 at 4:02 PM, Shastry(DBA) <shastry17@xxxxxxxxx> wrote:

> Hi all,
>
> Could anyone please let me know the Navigation to find the size of a table
> in OEM?
>
> Thanks,
> Ann
>



-- 
Sincerely
Ram Srinivasan

Other related posts: