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
what is ora 24313?what is the procedure to exclude that error?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
What are the commands you'd issue to show the explain plan for "select * from dual"?
what functionality does oracle provide to secure sensitive information?
What are the different types of upgrades that can be performed in sql server? : sql server DBA
Which autogrowth database setting is good? : sql server DBA
What happens on checkpoint? : sql server DBA
what are the differences of where and if in SAS?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
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?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
Explain materialized views and how they are used.
How would you go about verifying the network name that the local_listener is currently using?
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
what is the use of ocr?