Interested to Buy Any Domain ? << Click Here >> for more details...
What view would you use to look at the size of a data file?
- 3 Answers
- 8994 Views
- I also Faced
- E-Mail Answers
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 authentication modes does sql server support? : sql server DBA
Explain about your sql server dba experience? : sql server DBA
what is asm?
how can you schedule a job in database?
what is the role of dip user in our database?
How do you trace the traffic hitting a sql server? : sql server DBA
Query processing is slow(eg select query)how will u solve that
what is the diffrence between core dba and apps dba?
what is grd?
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA
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
how can you generate profile of pl/sql applications to identify performance bottlenecks?
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
How to start SQL Server in minimal configuration mode?
suppose you want to audit specific activities on sensitive data. How can you achieve that?
