What view would you use to look at the size of a data file?
Answer Posted / suman
we can see the size of datafile that is we have two views
1. dba_data_files
2. v$datafile
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What would you do with an "in-doubt" distributed transaction?
What is transparent data encryption? : sql server DBA
how can you process messages in order asynchronously?
what are the performance views in an oracle rac environment?
suppose you want to audit specific activities on sensitive data. How can you achieve that?
What is the difference between dropping a database and taking a database offline? : sql server DBA
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
Why would you use sql agent? : sql server DBA
how can you implement fine-grained auditing?
how can you generate profile of pl/sql applications to identify performance bottlenecks?
What are the steps you will take to improve performance of a poor performing query?
What purpose does the model database server? : sql server DBA
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
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?
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA