1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category

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

Post New Answer

More DB Administration Interview Questions

You're getting high "busy buffer waits" - how can you find what's causing it?

1 Answers  

How do you troubleshoot errors in a sql server agent job? : sql server DBA

1 Answers  

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

1 Answers  

wat is global index and local indes

1 Answers   Oracle,

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2 Answers   IBM,

How can you control the amount of free space in your index pages? : sql server DBA

1 Answers  

What command would you use to create a backup control file?

2 Answers  

How many packages we have in db

1 Answers   Tesco,

What is replication? : sql server DBA

1 Answers  

Q. How to set ORACLE_HOME to my oracle software directory. Hi Friend I am installing oracle 10g Express Edition on Linux Fedora Core 6. Installation is success but when i run #sqlplus I getting command not found error. Then I have search sqlplus .i.e # find / -name sqlplus /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/sqlplus /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/sqlplus These above output from find i have doubt which is correct path of sqlplus. So doubtfully i have set path 1st one.i.e # PATH=$PATH:/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin Then I have run #sqlplus but still i have problem following Error 6 initializing SQL*Plus Message file sp1<lang>.msb not found SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory How overcome this please answer m???

1 Answers  

If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA

1 Answers  

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

1 Answers  

For more DB Administration Interview Questions Click Here
Categories