Collections:
Show Free Space in a Tablespace in Oracle
How To See Free Space of Each Tablespace in Oracle?
✍: 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:
⇒ Bring a Tablespace Offline in Oracle
⇐ Create a Table in a Given Tablespace in Oracle
2019-01-01, 2169🔥, 0💬
Popular Posts:
How To Start MySQL Server in MySQL? If you want to start the MySQL server, you can run the "mysqld" ...
What Happens to Your Transactions When ERROR 1213 Occurred in MySQL? If your transaction receives th...
How To Create a Table Index in Oracle? If you have a table with a lots of rows, and you know that on...
How To Use SQL*Plus Built-in Timers in Oracle? If you don't have a stopwatch/timer and want to measu...
How To Connect to a MySQL Server with a Port Number in MySQL? If you want to connect a MySQL server ...