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
- 8886 Views
- I also Faced
- E-Mail Answers
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 can you process messages in order asynchronously?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
what is the use of recording information about current session?
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.
What is the importance of a recovery model? : sql server DBA
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
What are the different types of indexes available in sql server? : sql server DBA
What is the difference between dropping a database and taking a database offline? : sql server DBA
who owns the operating system files created by the utl_file package?
Explain materialized views and how they are used.
internal architecture
suppose you want to audit specific activities on sensitive data. How can you achieve that?
What is a system database and what is a user database? : sql server DBA
