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

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

Question Posted / guest

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

More DB Administration Interview Questions

Hot backup procedure?

You have just compiled a PL/SQL package but got errors, how would you view the errors?

what is the difference between catalog & nocatalog?

Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA

List out some of the requirements to setup a sql server failover cluster.? : sql server DBA

Give the two types of tables involved in producing a star schema and the type of data theyhold.

what is meant by gateway

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

For more DB Administration Interview Questions Click Here