Interested to Buy Any Domain ? << Click Here >> for more details...
How can we find the size of a database?
- 2 Answers
- 6021 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 |
If a table column has is UNIQUE and has NOT NULL, is it equivalent to a PRIMARY KEY column?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
select * from emp what happened internally when we write this query in the sql prompt?
Can we create more than one constraint to column ?
how to find full database size
1 Answers BirlaSoft, Consultancy,
What is E-R diagram ?
2 Answers CGI, Keane India Ltd,
How to commit the current transaction in oracle?
What is a Temporary Segment ?
How do you find current date and time in oracle?
What is the recommended interval at which to run statspack snapshots, and why?
Can you have more than one content canvas view attached with a window ?
What is the purpose of tables, private synonyms and public synonyms in Oracle?
Oracle General 
