Re: Size of a table using OEM
Date: Fri, 28 Mar 2008 12:46:06 -0400
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 *
*where* owner = 'RAM32'
*and* segment_type *in* ('TABLE')
and* segment_name = 'EQUIPMENT_REMARK'
GROUP* *BY* OWNER, SEGMENT_NAME
ORDER* *BY* OWNER, segment_name;
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?
-- Sincerely Ram Srinivasan -- http://www.freelists.org/webpage/oracle-lReceived on Fri Mar 28 2008 - 11:46:06 CDT