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

Question Posted / guest

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

Hot backup procedure?

2 Answers

How do you trace the traffic hitting a sql server? : sql server DBA

0 Answers

Can we take incremental backups in datapump?

1 Answers

When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA

0 Answers

Which autogrowth database setting is good? : sql server DBA

0 Answers

What types of replication are supported in sql server? : sql server DBA

0 Answers

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2 Answers IBM,

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

0 Answers

What would you use to improve performance on an insert statement that places millions of rows into that table?

2 Answers TCS,

How would you force a log switch?

4 Answers

How can we see the database version in os level

6 Answers Oracle,

What the different components in replication and what is their use? : sql server DBA

0 Answers

For more DB Administration Interview Questions Click Here