Interested to Buy Any Domain ? << Click Here >> for more details...
How can we find the size of a database?
- 2 Answers
- 5968 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 |
I want a table like, no name address addr1 addr2 So i want columns like addr1,addr2 under address column. Can one please answer me. Advance Thanks.
What is tns entry?
Compare and contrast between sql and sql server and explain its various functions?
What is oracle host variable?
How to recover a dropped table in oracle?
Please explain oracle data types with examples?
What is the difference between an Oracle Schema and an Oracle Instance?
Explain the blob datatype?
What is the database name in oracle?
please explain.. DB architecture ...
Give the advantages and disadvantages of clusters.
How to get a create statement for an existing table?
Oracle General 
