Answer / guest

It is PMON which clean up the memory and other resources
allocated to a given user process after it fails


Regards
Abhinav

What is a system database and what is a user database? : sql server DBA

0 Answers  

---

I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me

0 Answers  

---

Where do you find the default index fill factor and how to change it? : sql server DBA

0 Answers  

---

Is it possible to update the multiple field values in a single query? If possible then write the actual query.

1 Answers   Oracle,

---

what do you understand by fine-grained auditing?

0 Answers   Oracle,

---

what is the difference between hot backup n rman backup?

1 Answers   Value Labs,

---

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

0 Answers  

---

who owns the operating system files created by the utl_file package?

0 Answers   Oracle,

---

What are the different types of database compression introduced in sql server 2008? : sql server DBA

0 Answers  

---

which background process invoke at the time of upgradation tell me???

0 Answers   iGate,

---

what is difference between user managed backup and rman backup?

1 Answers   CTS,

---

What would you use to improve performance on an insert statement that places millions of rows into that table?

2 Answers   TCS,

---