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

Question Posted / guest

3 Answers
8827 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 differences of where and if in SAS?

0 Answers

What are the different ways you can create databases in sql server? : sql server DBA

0 Answers

When creating a user, what permissions must you grant to allow them to connect to the database?

3 Answers

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

0 Answers

SUPPOSE AS A DBA YOU CREATED ONE USER BY DEFAULT HOW MANY PRIVILIZES WILL COME TO USER & WHERE CAN YOU SEE THAT PRIVILIZES.

4 Answers Cognizant,

What are the commands you'd issue to show the explain plan for "select * from dual"?

0 Answers

I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me

0 Answers

orra 1555 what is this error,why it is occur?

2 Answers Mphasis,

Compare and contrast TRUNCATE and DELETE for a table.

7 Answers

Query processing is slow(eg select query)how will u solve that

3 Answers TCS,

What is transparent data encryption? : sql server DBA

0 Answers

What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA

0 Answers

For more DB Administration Interview Questions Click Here