Answer / ammar takieddin

select sum(bytes)/1024/1024 from dba_data_files;
+
select sum(bytes)/1024/1024 from v$log;

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)

There are three tables : E : EID,ENAME D : DID,DNAME empdept : eid, did select the employees who doesn't belong to any dep

4 Answers   Microsoft,

---

What privilege is needed for a user to create indexes in oracle?

0 Answers  

---

what is the difference between table and veiw?

4 Answers   IBM,

---

How to shutdown your 10g xe server from command line?

0 Answers  

---

What is a subquery?

0 Answers  

---

How to recover a dropped table in oracle?

0 Answers  

---

What is oracle rownum?

0 Answers  

---

create or replace procedure show_tab_rec ( P_tab VARCHAR2 ) IS cmd varchar2(50); begin cmd := 'select * from '|| P_tab; for int in ( execute immediate cmd ) loop dbms_output.put_line ( int.ename||' '||int.deptno); end loop; end; when i m compling this procedure i m getting this error PLS-00103: Encountered the symbol "IMMEDIATE" when expecting one of the following: . ( ) , * @ % & | = - + < / > at in is mod remainder not range rem => .. <an exponent (**)> <> or != or ~= >= <= <> and or like LIKE2_ LIKE4_ LIKEC_ between || multiset member SUBMULTISET_ PLZ solve this error give this question answer asap Thanks advance.......

1 Answers   HCL,

---

What are the types of partitions in oracle?

0 Answers  

---

How do I limit the number of rows returned by an oracle query after ordering?

0 Answers  

---

why can't we assign not null constraint as table level constraint

3 Answers   CTS, Wipro,

---

How to define Data Block size ?

2 Answers  

---