how to find full database size
Answer / sudipta santra
select sum(bytes / (1024*1024)) "DB Size in MB" from
dba_data_files;
If u have the access of the table dba_data_files
| Is This Answer Correct ? | 3 Yes | 0 No |
Where are the settings stored for each instance in oracle?
select statement does not retrieve any records. what exception is raised?
Which is faster join or subquery in oracle?
What is truncate oracle?
Explain the difference between a procedure and a function? What do you understand by those terms?
what is the use of ondelete cascade?
Explain the use of constraints option in exp command.
How is it different from a normal table?
When do we use group by clause in a sql query?
what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?
How to define an anonymous procedure without variables?
What are the execution control statements in oracle?