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
- 8997 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
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?
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
What purpose does the model database server? : sql server DBA
Explain materialized views and how they are used.
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
what is asm?
What is dcl? : sql server DBA
How do you trace the traffic hitting a sql server? : sql server DBA
What the different components in replication and what is their use? : sql server DBA
what is the last version,the release date of that version and fix pack of ibm db2 udb?
what is the diffrence between core dba and apps dba?
how can you process messages in order asynchronously?
how can you connect from 10g user to 11g user??
