Answer / rahul khanke

hi,
basic oracle architecture is devided in 3 stages
1. storage structure
1. physical storage
a. data file
b. control file etc..
2.logical storage
a. tablespace
b. extents etc..
2. memory structure
a. SGA
b. PGA
2. process structure
1. mandatory process
a. SMON
b. PMON etc
2. optional process

and much more

what is the difference between undefined value and null value? : Sql dba

0 Answers  

---

Why cannot I use bind variables in ddl/scl statements in dynamic sql?

0 Answers  

---

Write a query to get 2nd maximum salary in an employee table ?

69 Answers   Accenture, BirlaSoft, Letse, Logica CMG, Qwest, Rheal Software, Saagam, Semantic Space, Tailor Solution, TCS, TinyERP,

---

How can I change database name in sql?

0 Answers  

---

Is big data nosql?

0 Answers  

---

---

How many types of cursors are available in pl/sql?

0 Answers  

---

What is insert command in sql?

0 Answers  

---

what is an associative array with example?

1 Answers  

---

Why functions are used in sql?

0 Answers  

---

What is trigger in pl sql?

0 Answers  

---

how to convert dates to character strings? : Sql dba

0 Answers  

---

What type of database is sql?

0 Answers  

---