When a user process fails, what background process cleans up
after it?
Answer Posted / 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 View All Answers
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
what do you understand by flashback feature of oracle?
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
who owns the operating system files created by the utl_file package?
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
internal architecture
What is fill factor? : sql server DBA
What purpose does the model database server? : sql server DBA
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
What are the different types of database compression introduced in sql server 2008? : sql server DBA
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
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
How would you extract DDL of a table without using a GUI tool?
How can you control the amount of free space in your index pages? : sql server DBA
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?