Interested to Buy Any Domain ? << Click Here >> for more details...
How can we find the size of a database?
- 2 Answers
- 6086 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ammar takieddin
select sum(bytes)/1024/1024 from dba_data_files;
+
select sum(bytes)/1024/1024 from v$log;
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / er. debashreet das
actually, size of a database can be calculated by various
factors:
1. total bytes allocated to the table, i.e., suppose we
create a table as
create table tr_deb(name varchar2(15), roll_no number(4),
branch varchar(20), photo blob(50));
then, total size will be 15 + 4 + 20 +50 = 89 bytes
2. also, calculate the primary and secondary extents. That
means we have to calculate the memory size required for
that table(relation), i.e., for tr_deb relation. This is
called primary extent.
3. Then, finally, we have to calculate(actually predict)
the secondary extent. Let us understand in this way:
suppose, our table "tr_deb" may be expanded in near future,
if students get admitted, then, we have to store their
address, phone number, etc. Again, we can decompose the
composite attributes into component attributes(sub-
attributes) and calculate their size(primary and secondary
extent)
| Is This Answer Correct ? | 4 Yes | 2 No |
Can we store pictures in the database and if so, how it can be done?
Calculate difference between 2 date / times in oracle sql?
What is the difference between a hot backup and a cold backup in oracle?
Preparing for Oracle PL/SQL Interviews – Need Help with Common Questions
How to check the server version in oracle?
Select all the employees who were hired in last 2 years and who works in dept where max managers are working.
How to recover a dropped index?
Is it possible to join two tables, that are in two different users (e.g. SCOTT and HR etc.),but im same database (e.g. ORCL)? If yes, then how it is possible? Explain with step by step procedure.
Explain about the analyze command in oracle?
Explain joins in oracle?
What is the exact use of Collections?
What are the commands youd issue to show the explain plan for select
Oracle General 
