Answer Posted / bhaskar

Hi,
It is the part of memory used by a singe process or thread.
Each oracle background process have PGA area.and is not
sharable.it get allocated when the process starts and gets
deallocated on completion of the process by oracle server.

It contains short area,session specific information,user
previliges,cursor state etc.It is writable only by the
server process.

Thanks-Bhaskar Gouda

What is a sub query and what are the different types of subqueries?

1127

---

How to define an external table with a text file?

1070

---

How to use null as conditions in oracle?

1084

---

State and explain about oracle instance?

1000

---

How to end the current transaction in oracle?

1030

---

Will you be able to store pictures in the database?explain.

994

---

I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.

2309

---

What is rowid and rownum in oracle?

1011

---

Why does for update in oracle 8 cause an ora-01002 error?

1003

---

How to convert csv to table in oracle?

992

---

Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun

2188

---

Can a formula column referred to columns in higher group ?

2506

---

Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

2104

---

What is PL/SQL ?

2076

---

What is the difference between hot backup and cold backup in oracle?

1014

---