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[...]
Oracle is the worlds most flexible database and we have many methods for renaming tablespaces and the underlying data files. Tablespace data file rename We can use the alter tablespace rename datafile command, but t[...]
Here are some scripts related to Tablespace Information . Information TABLESPACE INFORMATION NOTES: Tablespace Name – Name of the tablespace Initial Extent – Default initial extent size Next Extent – D[...]
This page is an introduction to my blog, which is dedicated to Oracle data base performance management.
I found over the years sharing knowledge to be an invaluable tool in assisting me in my various consulting assignments. Spending most of my time in capacity planning, tuning, application sizing and performance management, I thought it might be [...]
dba Ask TEM Dba
(0.00 out of 5) (0.00 out of 5) (0.00 out of 5) (0.00 out of 5) (0.00 out of 5) (0.00 out of 5) (0.00 out of 5) (0.00 out of 5) (0.00 out of 5) (0.00 out of 5)