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

Answer Posted / shruthi

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

Is This Answer Correct ?    4 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.

1235


Can you redefine a table online?

669


internal architecture

1755


what do you understand by fine-grained auditing?

633


What is fill factor? : sql server DBA

644






Why does Oracle not permit the use of PCTUSED with indexes?

2328


What is the importance of a recovery model? : sql server DBA

552


how can you record information about current session?

495


how can you enable flashback feature?

536


You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

2391


I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution

1646


How can you control the amount of free space in your index pages? : sql server DBA

736


how can a session indicate its interest in receiving alerts?

565


what functionality does oracle provide to secure sensitive information?

554


How would you extract DDL of a table without using a GUI tool?

2049