Interested to Buy Any Domain ? << Click Here >> for more details...
What view would you use to look at the size of a data file?
- 3 Answers
- 8887 Views
- I also Faced
- E-Mail Answers
Answer Posted / guest
We can see the size of a datafile by querying given 2 views
dba_data_files and v$datafile
Regards
Abhinav Phadnis
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What are the different types of database compression introduced in sql server 2008? : sql server DBA
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?
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
What the different types of replication and why are they used? : sql server DBA
Why would you use sql agent? : sql server DBA
What are the different ways you can create databases in sql server? : sql server DBA
how can a session indicate its interest in receiving alerts?
What are the operating modes in which database mirroring runs? : sql server DBA
what is the use of ocr?
What is dcl? : sql server DBA
How can you control the amount of free space in your index pages? : sql server DBA
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
how can you process messages in order asynchronously?
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
what functionality does oracle provide to secure sensitive information?
