Answer / su

-Oracle is a database, you can store data(RDBMS, since it
follows more than 8 rule out of 12 proposed by E F Codd).
-Made up of memory structures and back ground processes.
-Memory structure - SGA (system global area) and PGA
(Process Global Area)
-Background Process are Database writer (DBWR) which
actually writes to the physical files (Data files), Log
Writer (LGWR) which writes to the physical log files
(important to get the database in consistent state if there
is a crash)
-Combination of memory structure and backgroung processes
gives us oracle instances , which is instrumental in
helping us work with the oracle database

:)

What does coalescing a tablespace do?

2 Answers  

---

Give the stages of instance startup to a usable state where normal users may access it.

1 Answers  

---

Hi I am searching for best oracle Apps institute? Please tel me which is best institute in hyderabad I am working in developer 6i....

2 Answers   Ion Exchange,

---

difference of using cursor for loop and open,fetch,close.which one is better

0 Answers   Accenture,

---

8. Supporting AP, AR and GL?

0 Answers   Oracle,

---

---

Where in the Oracle directory tree structure are audit traces placed?

0 Answers  

---

as a technical developer in oracle applications which type errors feced in your experience sofar

0 Answers   HCL,

---

Explain the use of table functions.

0 Answers  

---

What are the main diff. between oracle 7.3 and oracle 8i?

1 Answers  

---

What is $FLEX$ and $PROFILES$?

2 Answers  

---

What is the difference between oracle media recovery and crash recovery?

0 Answers  

---

WHAT IS CARTESIAN PRODUCT?

2 Answers  

---