What view would you use to look at the size of a data file?
Answer Posted / 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 View All Answers
Query processing is slow(eg select query)how will u solve that
What is dcl? : 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 are the operating modes in which database mirroring runs? : sql server DBA
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
how can you record information about current session?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
how can you find out if a table can be redefined?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
what is the role of dip user in our database?
What is the importance of a recovery model? : sql server DBA
What is a correlated sub-query? : sql server DBA
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?
You create a private database link and upon
connection, fails with: ORA-2085: connects to
what do you understand by flashback feature of oracle?