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
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.
Can you redefine a table online?
internal architecture
what do you understand by fine-grained auditing?
What is fill factor? : sql server DBA
Why does Oracle not permit the use of PCTUSED with indexes?
What is the importance of a recovery model? : sql server DBA
how can you record information about current session?
how can you enable flashback feature?
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?
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
How can you control the amount of free space in your index pages? : sql server DBA
how can a session indicate its interest in receiving alerts?
what functionality does oracle provide to secure sensitive information?
How would you extract DDL of a table without using a GUI tool?