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_at_gmail.com> 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

--
http://www.freelists.org/webpage/oracle-l