Home » RDBMS Server » Enterprise Manager » Estimate size of SYSTEM, TEMP, USERS, UNDO tablespace, control file, redo log fi
Estimate size of SYSTEM, TEMP, USERS, UNDO tablespace, control file, redo log fi [message #68856] Thu, 02 December 2004 16:05 Go to next message
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.
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 Go to previous message
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;
Previous Topic: Self Check for Job Execution in OEM.
Next Topic: Hi DBA's
Goto Forum:
  


Current Time: Sun May 22 12:55:43 CDT 2022