Answer Posted / hariharanadh

It is a memory buffer that contains data and control information for server process
A PGA created when oracle server starts and deallocated
when server process down

What do you mean by a deadlock?

1008

---

Difference between pre-select and pre-query

1027

---

How to open and close an explicit cursor in oracle?

994

---

Differentiate between post-database commit and post-form commit?

978

---

How to upsert (update or insert into a table)?

948

---

What is oracle open database communication (odbc)?

957

---

Define oracle database

991

---

while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511

4291

---

What is the sid in oracle?

892

---

What is the difference between a user and a schema in oracle?

980

---

Explain the use of parfile option in exp command.

985

---

What is a nvl function?

954

---

Why should I use oracle database?

941

---

I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?

2395

---

How to check your oracle database 10g xe installation?

923

---