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 authentication modes does sql server support? : sql server DBA
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
What is transparent data encryption? : sql server DBA
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
Why does Oracle not permit the use of PCTUSED with indexes?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
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
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
Where do you find the default index fill factor and how to change it? : sql server DBA
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
How would you extract DDL of a table without using a GUI tool?
how can you find out if a table can be redefined?
What is fill factor? : sql server DBA
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?