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

Question Posted / guest

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

suppose you want to audit specific activities on sensitive data. How can you achieve that?

0 Answers Oracle,

I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

1 Answers

What is the default fill factor value? : sql server DBA

0 Answers

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

0 Answers

Oracle 11g new features?

2 Answers

what is asm?

0 Answers Oracle,

how can you create a user-defined lock?

0 Answers Oracle,

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