What view would you use to determine free space in a tablespace?

Question Posted / guest

Answers were Sorted based on User's Feedback

What view would you use to determine free space in a tablespace?..

Answer / guest

It is dba_free_space which gives u the info about free
space in any tablespace

Regards
Abhinav

Is This Answer Correct ?

9 Yes

2 No

What view would you use to determine free space in a tablespace?..

Answer / shruthi

It is sm$ts_free.......

Is This Answer Correct ?

4 Yes

2 No

What view would you use to determine free space in a tablespace?..

Answer / 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

More DB Administration Interview Questions

how does an oracle clusterware manage crs resources?

What type of index should you use on a fact table?

what is the use of home directory???

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

What is a deadlock and what is a live lock? How will you go about resolving deadlocks?

In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

Explain CREATE DATABASE syntax?

What is transparent data encryption? : sql server DBA

who owns the operating system files created by the utl_file package?

How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.

What is RAID and what are different types of RAID configurations?

What are the commands you'd issue to show the explain plan for "select * from dual"?

For more DB Administration Interview Questions Click Here