Interested to Buy Any Domain ? << Click Here >> for more details...
How can we find the size of a database?
- 2 Answers
- 6071 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 |
Is oracle a relational database?
State some uses of redo log files?
What is the sid in oracle?
What is the data type of dual table?
What is the data pump export utility?
What are the database administrators utilities available?
candidate key is subset of super key but not vice-verse explain
Can a formula column be obtained through a select statement ?
What are the uses of linked server and explain it in detail?
Which environment variables are absolutely critical in order to run the OUI?
What is background process in Oracle?
What is snapshot is too old? Give and example for better understand.
Oracle General 
