What view would you use to look at the size of a data file?

Question Posted / guest

3 Answers
8996 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What view would you use to look at the size of a data file?..

Answer / 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

What view would you use to look at the size of a data file?..

Answer / ramesh

v$datafile and v$tablespace Views

select v.FILE#,t.NAME,v.TS#,v.BLOCKS,v.BLOCK_SIZE from
v$datafile d,v$tablespace t where v.v.TS# =t.TS#

Cheers,
Ramesh

Is This Answer Correct ?

4 Yes

0 No

What view would you use to look at the size of a data file?..

Answer / 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

More DB Administration Interview Questions

how will you see when the database was started using sql prompt?

2 Answers IBM,

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

0 Answers

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?

0 Answers EDS,

how can you initialize log miner?

0 Answers Oracle,

What is a deadlock and what is a live lock? How will you go about resolving deadlocks?

1 Answers

i need a brief information about db2 dba course and realtime experts if any plz inform me nareshbhupathi93@gmail.com plzzz urgent

1 Answers TCS,

What view would you use to determine free space in a tablespace?

3 Answers

why Datapump is faster than traditional export and import

4 Answers Mphasis,

What command would you use to encrypt a PL/SQL application?

1 Answers

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

0 Answers

What is the difference between dropping a database and taking a database offline? : sql server DBA

0 Answers

What's the benefit of "dbms_stats" over "analyze"?

1 Answers

For more DB Administration Interview Questions Click Here