OraFAQ Forum: Enterprise Manager » Estimate size of SYSTEM, TEMP, USERS, UNDO tablespace, control file, redo log fi

Home » RDBMS Server » Enterprise Manager » Estimate size of SYSTEM, TEMP, USERS, UNDO tablespace, control file, redo log fi

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Estimate size of SYSTEM, TEMP, USERS, UNDO tablespace, control file, redo log fi [message #68856]

Thu, 02 December 2004 16:05

Ta Thi Thuy Ha
Messages: 5
Registered: October 2004

Junior Member

Dear all,

I want to estimate size of SYSTEM, TEMP, USERS, UNDO tablespace, control file, redo log file, how to do?

Please help me! Thanks.

Report message to a moderator

Re: Estimate size of SYSTEM, TEMP, USERS, UNDO tablespace, control file, redo lo [message #68925 is a reply to message #68856]

Mon, 07 February 2005 13:27

Terry
Messages: 13
Registered: September 2000

Junior Member

1. To estimate the schema sizes. Do this

SELECT a.ts#, a.name, b.bytes
FROM v$tablespace a, v$datafile b
WHERE a.ts# = b.ts#
AND upper(a.name) IN ('SYSTEM', 'TEMP', 'USERS', 'UNDO');

2. Controlfiles I don't know. You might need to check the os file size.

3. For log file size. Select * from v$log or select sum(bytes) from v$log;

Report message to a moderator

Previous Topic:	Self Check for Job Execution in OEM.
Next Topic:	Hi DBA's

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 23:17:23 CDT 2024