What view would you use to look at the size of a data file?
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
Which autogrowth database setting is good? : sql server DBA
How to start SQL Server in minimal configuration mode?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
when does an alert gets signaled?
What is the default port no on which sql server listens? : sql server DBA
Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com
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.
You create a private database link and upon
connection, fails with: ORA-2085: connects to
What are the different types of indexes available in sql server? : sql server DBA
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
What are the steps you will take to improve performance of a poor performing query?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
how can you record information about current session?
suppose you want to audit specific activities on sensitive data. How can you achieve that?
what is ora 24313?what is the procedure to exclude that error?