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 are statistics, under what circumstances they go out of date, how do you update them?
what is ora 24313?what is the procedure to exclude that error?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
Can you redefine a table online?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
Explain materialized views and how they are used.
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
What is the default fill factor value? : sql server DBA
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
What would you do with an "in-doubt" distributed transaction?
how can you connect from 10g user to 11g user??
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA