Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To See Free Space of Each Tablespace
How To See Free Space of Each Tablespace? - Oracle DBA FAQ - Managing Oracle Tablespaces and Data Files
✍: FYIcenter.com
One of the important DBA tasks is to watch the storage usage of all the tablespaces to make sure there are enough free space in each tablespace for database applications to function properly. Free space information can be monitored through the USER_FREE_SPACE view. Each record in USER_FREE_SPACE represents an extent, a contiguous area of space, of free space in a data file of a tablespace.
Here is SQL script example on how to see free space of a tablespace:
SQL> connect HR/fyicenter Connected. SQL> SELECT TABLESPACE_NAME, FILE_ID, BYTES 2 FROM USER_FREE_SPACE 3 WHERE TABLESPAE_NAME IN ('USERS', 'MY_SPACE'); TABLESPACE_NAME FILE_ID BYTES ------------------------------ ---------- ---------- MY_SPACE 5 10354688 USERS 4 101974016 USERS 4 65536 USERS 4 65536 USERS 4 65536 USERS 4 65536 USERS 4 65536 USERS 4 65536 USERS 4 65536 USERS 4 65536 USERS 4 65536 USERS 4 65536 USERS 4 65536 USERS 4 65536
This tells us that:
2007-05-03, 4680👍, 0💬
Popular Posts:
How can I execute a PHP script using command line? Just run the PHP CLI (Command Line Interface) pro...
How do I force the Dispose method to be called automatically, as clients can forget to call Dispose ...
What does AddressOf operator do in background ? The AddressOf operator creates a delegate object to ...
Can you explain in brief how the ASP.NET authentication process works? ASP.NET does not run by itsel...
What does static variable mean? There are 3 main uses for static variables: If you declare within a ...