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

Question Posted / guest

3 Answers
8720 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 is the difference between catalog & nocatalog?

3 Answers CSC,

How many packages we have in db

1 Answers Tesco,

Which dictionary tables and/or views would you look at to diagnose a locking issue?

2 Answers

CTS int questions: 1.Temperory tablespace corrupted,how to resolve?If you need to recover? 2.In tablespace begin backup mode,Its possible to add the datafile? 3.How to partition the table using Hash partioning,what happened internally? 4.During rman backup,some files are missing Rman will continue the backup? 5.what are the errors occurs frequently? 6.which join method is best?why? 7.how to solve deadlock errors? please reply anyone.... regards siva

2 Answers CTS,

How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?

0 Answers

What are the recovery models for a database? : sql server DBA

0 Answers

what is the difference between db2start command and start database manager command?

1 Answers

1. how do you delete duplicate rows in a table? 2. can you disable and enable primary key? 3. how do you move tables from one tablespace to another tablespace?????

2 Answers Genpact,

You're getting high "busy buffer waits" - how can you find what's causing it?

1 Answers

How to determine the service pack currently installed on SQL Server?

1 Answers

How would you best determine why your MVIEW couldn't FAST REFRESH?

0 Answers

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.

0 Answers Infosys,

For more DB Administration Interview Questions Click Here