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

Question Posted / guest

3 Answers
7418 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

What are the ways tablespaces can be managed and how do they differ?

2 Answers IBM,

which background process will run @ the time of creation of catalog database

1 Answers CSC,

Explain the use of table functions.

1 Answers

what is ora 24313?what is the procedure to exclude that error?

0 Answers

How would you determine who has added a row to a table?

4 Answers

how can you process messages in order asynchronously?

0 Answers Oracle,

What is the difference between the 2 operating modes of database mirroring? : sql server DBA

0 Answers

You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?

3 Answers

what is the difference between catalog & nocatalog?

3 Answers CSC,

What is a system database and what is a user database? : sql server DBA

0 Answers

How many memory layers are in the shared pool?

3 Answers

What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?

2 Answers

For more DB Administration Interview Questions Click Here