What view would you use to determine free space in a tablespace?
Answer Posted / rajesh naidu
SELECT TABLESPACE_NAME,SUM(BYTES/1024/1024) FROM
DBA_FREE_SPACE GROUP BY TABLESPACE_NAME;
AND THE VIEW IS DESC DBA_FREE_SPACE;
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
what are the performance views in an oracle rac environment?
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
what do you understand by flashback feature of oracle?
how can you create a user-defined lock?
how does an oracle clusterware manage crs resources?
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
What the different components in replication and what is their use? : sql server DBA
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
what is the use of recording information about current session?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?