23rd December 2009
in
Tutorials
Step-by-step instructions on how to create a Physical Standby Database on Windows and UNIX servers, and maintenance tips on the databases in a Data Guard Environment.
Oracle 10g Data Guard is a great tool to ensure high [...]
Tags: B14239-04, Create a Physical Standby Database, database, Oracle 10g, Oracle 10g Data Guard, Oracle Data Guard Concepts and Administration 10g Release 2, orafaq, Windows and UNIX servers
1 Comment
2nd December 2009
in
Tablespace
Unlike normal tablespaces, true temporary tablespace information is not listed in DBA_FREE_SPACE. Instead use the V$TEMP_SPACE_HEADER view:
SELECT tablespace_name, SUM(bytes_used), SUM(bytes_free)
FROM V$temp_space_hea[...]
Tags: find free space in a TEMPORARY tablespace, free size temp tablespace, TEMPORARY tablespace, uf
No Comments