When a user process fails, what background process cleans up
after it?



When a user process fails, what background process cleans up after it?..

Answer / guest

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


Regards
Abhinav

Is This Answer Correct ?    14 Yes 0 No

Post New Answer

More DB Administration Interview Questions

How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?

0 Answers   EDS,


Give the reasoning behind using an index.

2 Answers  


I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution

0 Answers  


Give two examples of how you might determine the structure of the table DEPT.

2 Answers  


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  






How do you switch from an init.ora file to a spfile?

4 Answers   TCS,


How would you go about verifying the network name that the local_listener is currently using?

0 Answers  


what is ora 600?

1 Answers  


What background process refreshes materialized views?

2 Answers   Accenture, FLSmidth,


How to start SQL Server in minimal configuration mode?

1 Answers  


what is the last version,the release date of that version and fix pack of ibm db2 udb?

0 Answers  


why Datapump is faster than traditional export and import

4 Answers   Mphasis,


Categories