How can we find the size of a database?
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 |
What are the types of trigger in oracle?
can you write commit in triggers?
Why is oracle database so popular?
What are the different oracle database objects?
you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz
How do I manually create a database in oracle?
I know that i can create a table without a primary key.But is there any significance for that table???? while creating an application.
Difference between varchar and varchar2 data types?
In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?
what is the syntax of CREATE command?
How to use select statement to count the number of rows in oracle?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?