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 |
What is difference between SUBSTR and INSTR?
How is it different from a normal table?
How to start your 10g xe server from command line?
How oracle handles dead locks?
Explain an exception?
What is meant by recursive hints in oracle?
if i have a procedure with 1000 line.when i run this in 61 line i got the error but i want to continue the programe without error.can anyone tell me how to handle that error.
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.
Write query to fetch second maximum salary from employee table.
4 Answers Bravura Solutions, HCL,
What is the maximum number of triggers that can be applied to a single table?
What are the uses of linked server and explain it in detail?
I have table-A(1,2,3,4,4,5,6,6,6,7). how to get all duplicate values?what is sql query?