What view would you use to look at the size of a data file?
Answer Posted / 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 |
Post New Answer View All Answers
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
what is the diffrence between core dba and apps dba?
What purpose does the model database server? : sql server DBA
How can you control the amount of free space in your index pages? : sql server DBA
How would you go about verifying the network name that the local_listener is currently using?
what is a crs resource?
Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com
what is the role of dip user in our database?
What are statistics, under what circumstances they go out of date, how do you update them?
how can you process messages in order asynchronously?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
What are the different types of upgrades that can be performed in sql server? : sql server DBA
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA