Interested to Buy Any Domain ? << Click Here >> for more details...
How can we find the size of a database?
- 2 Answers
- 6096 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 |
Explain cascading triggers.
how to select alphabets in a one column , for this the table name is PA_TASKS and column name is TASK_NUMBER, In TASK_NUMBER the data like this 1.1.3NN,1.1.4NN,1.5.1NN,1.3.2NE,1.5NN,1NN,1.2NE,1CE , For this i need to disply output as only NN,but not other alphabets, if NN is thre means i should display , otherwise leave that blank or empty Its some urgent requirement ,thanks in advance
3. Display all the client numbers in the ORDER table. Remove duplicates.
What is integrity and what is constraint??Explain with example
How to create a table in a specific tablespace?
What are internal user account in oracle?
what is dynamic SGA and static SGA
How to use in conditions in oracle?
What is the difference between SQL, DDL, and DML?
7 Answers BeBo Technologies, Wipro,
What is the difference between a vector and an Array? (Java)
What is Read-Only Transaction ?
What is a procedure in oracle?
Oracle General 
