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

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

1 Answer

Answer :

PMON
by

Related questions

When a user process fails, what Oracle background process will clean after it?

Description : When a user process fails, what Oracle background process will clean after it?

Last Answer : PMON

Is the After report trigger fired if the report execution fails?

Description : Is the After report trigger fired if the report execution fails?

Last Answer : Yes.

What background process refreshes materialized views?

Description : What background process refreshes materialized views?

Last Answer : The Job Queue Processes.

Why query fails sometimes ?

Description : Why query fails sometimes ?

Last Answer : Rollback segment dynamically extent to handle larger transactions entry loads. A single transaction may wipeout all available free space in the Rollback Segment Tablespace. This prevents other user using Rollback segments.

Name two specific RAC background processes

Description : Name two specific RAC background processes

Last Answer : RAC processes are: LMON, LMDx, LMSn, LKCx and DIAG.

How can you execute the user defined triggers in forms 3.0 ?

Description : How can you execute the user defined triggers in forms 3.0 ?

Last Answer : Execute Trigger (trigger-name)

What are the Built-ins to display the user-named editor?

Description : What are the Built-ins to display the user-named editor?

Last Answer : A user named editor can be displayed programmatically with the built in procedure SHOW-EDITOR, EDIT_TETITEM independent of any particular text item.

What are the roles and user accounts created automatically with the database?

Description : What are the roles and user accounts created automatically with the database?

Last Answer : DBA - role Contains all database system privileges. SYS user account - The DBA role will be assigned to this account. All of the base tables and views for the database's dictionary ... administrative information and internal tables and views used by oracle tools are created using this username.

When creating a user, what permissions must you grant to allow them to connect to the database?

Description : When creating a user, what permissions must you grant to allow them to connect to the database?

Last Answer : Grant the CONNECT to the user.

Does user exits supports DLL on MSWINDOWS ?

Description : Does user exits supports DLL on MSWINDOWS ?

Last Answer : YES .

Can you call WIN-SDK thruo' user exits?

Description : Can you call WIN-SDK thruo' user exits?

Last Answer : YES.

What are user-exits?

Description : What are user-exits?

Last Answer : It invokes 3GL programs.

How does one switch to another user in Oracle? (for DBA

Description : How does one switch to another user in Oracle? (for DBA

Last Answer : Users normally use the "connect" statement to connect from one database user to another. However, DBAs can switch from one user to another without a password. Of course it is not advisable to ... tiger Connected. Note: Also see the su.sql script in the Useful Scripts and Sample Programs Page.

Who created all these users in my database?/ Can I drop this user? (for DBA

Description : Who created all these users in my database?/ Can I drop this user? (for DBA

Last Answer : Oracle creates a number of default database users or schemas when a new database is created. Below are a few of them: SYS/CHANGE_ON_INSTALL or INTERNAL Oracle Data Dictionary/ Catalog Created ... there should be no problem altering these users to use a different default and temporary tablespace.

What are various privileges that a user can grant to another user?

Description : What are various privileges that a user can grant to another user?

Last Answer : SELECT -CONNECT -RESOURCES

What is an User Exits ?

Description : What is an User Exits ?

Last Answer : A user exit is a subroutine which are written in programming languages using pro*C pro *Cobol , etc., that link into the SQL * forms executable.

What are the type of User Exits ?

Description : What are the type of User Exits ?

Last Answer : ORACLE Precompliers user exits OCI (ORACLE Call Interface) Non-ORACEL user exits. Page :

What is the User-Named Editor?

Description : What is the User-Named Editor?

Last Answer : A user named editor has the same text editing functionality as the default editor, but, because it is a named object, you can specify editor attributes such as windows display size, position, and title.

What is an user exit used for?

Description : What is an user exit used for?

Last Answer : A way in which to pass control (and possibly arguments ) form Oracle report to another Oracle products of 3 GL and then return control ( and ) back to Oracle reports.

How can I message to passed to the user from reports?

Description : How can I message to passed to the user from reports?

Last Answer : By using SRW.MESSAGE function. (Continued on next part...)

Do user parameters appear in the data modal editor in 2.5?

Description : Do user parameters appear in the data modal editor in 2.5?

Last Answer : No

How does one connect to an administrative user? (for DBA

Description : How does one connect to an administrative user? (for DBA

Last Answer : If an administrative user belongs to the "dba" group on Unix, or the "ORA_DBA" (ORA_sid_DBA) group on NT, he/she can connect like this: connect / as sysdba No password is required. This ... connections via Net8 are classified as non-secure. Look at this example: connect sys/password as sysdba

What is an administrative (privileged) user? (for DBA

Description : What is an administrative (privileged) user? (for DBA

Last Answer : Oracle DBAs and operators typically use administrative accounts to manage the database and database instance. An administrative account is a user that is granted SYSOPER or SYSDBA privileges. SYSDBA ... and special operating system groups. This password file is created with the orapwd utility.

What are the three types of user exits available ?

Description : What are the three types of user exits available ?

Last Answer : Oracle Precompiler exits, Oracle call interface, NonOracle user exits.

What is user Account in Oracle database?

Description : What is user Account in Oracle database?

Last Answer : A user account is not a physical structure in database but it is having important relationship to the objects in the database and will be having certain privileges.

What is user Account in Oracle database?

Description : What is user Account in Oracle database?

Last Answer : An user account is not a physical structure in Database but it is having important relationship to the objects in the database and will be having certain privileges.

Can one rename a database user (schema)? (for DBA)

Description : Can one rename a database user (schema)? (for DBA)

Last Answer : No, this is listed as Enhancement Request 158508. Workaround: Do a user-level export of user A create new user B Import system/manager fromuser=A touser=B Drop user A

Will a user be able to modify a table with SELECT only privilege?

Description : Will a user be able to modify a table with SELECT only privilege?

Last Answer : He won’t be able to UPDATE/INSERT into that table, but for some reason, he will still be able to lock a certain table.

If fiber cleans out your colon then would the equivalent be useful in plumbing?

Description : If fiber cleans out your colon then would the equivalent be useful in plumbing?

Last Answer : No NO NO !

Do you know of any app that cleans blemishes off from old photos automatically?

Description : Do you know of any app that cleans blemishes off from old photos automatically?

Last Answer : lunaPic Restore photo feature does this in one shot.

Is it psychological peculiarity in humans to believe that a cleaner cleans better if there are an abundance of suds?

Description : Is it psychological peculiarity in humans to believe that a cleaner cleans better if there are an abundance of suds?

Last Answer : Lathering up in a shower. People relate to that.

What ingredient in a Coke cleans a cars windshield?

Description : What ingredient in a Coke cleans a cars windshield?

Last Answer : In all my life I never heard of this, but Google turned up a number of links about it, this one, for example

How do you feel about tipping the person that cleans your hotel room?

Description : How do you feel about tipping the person that cleans your hotel room?

Last Answer : If they do a great job, definitely feel free to do so. We usually leave about $5/day.

That "Clean Shower" stuff that you spray on the shower walls and it cleans automatically...can you spray it on the rest of the bathroom walls if they're the same tile?

Description : That "Clean Shower" stuff that you spray on the shower walls and it cleans automatically...can you spray it on the rest of the bathroom walls if they're the same tile?

Last Answer : you must believe in magic.

What cleans Oxy-Clean?

Description : What cleans Oxy-Clean?

Last Answer : More rinsing is needed. Lots of clean water. Might even help if you use the toothbrush with clean water.

What cleans but never ever gets dirty? -Riddles

Description : What cleans but never ever gets dirty? -Riddles

Last Answer : A bar of soap.

Which fruit cleans contaminated blood ?

Description : Which fruit cleans contaminated blood ?

Last Answer : Does playing mango clear the contaminated blood ?

Who cleans how much with a small child?

Description : How many times a week do you clean it every day?

Last Answer : On a daily basis there is a vacuuming mopping with us .Clear it every two days. 

what cleans a penny better vinegar and salt or ketchup

Description : what cleans a penny better vinegar and salt or ketchup

Last Answer : Both work equally well because they contain the same acids that clean the penny. Hot sauce also works. Probably whichever is easiest to you would be the best.

What cleans PCP from your system?

Description : What cleans PCP from your system?

Last Answer : What is the answer ?

What product best cleans a bathroom sink without scratching it?

Description : What product best cleans a bathroom sink without scratching it?

Last Answer : If you want a natural cleaner that will not scratch the sink, try baking soda. Lemon juice will also spiff up a bathroom and add a nice scent. If you need a commercial strength cleaner and are concerned about your sink getting scratched, Soft Scrub is probably your best bet!

Who cleans gutters really well?

Description : Who cleans gutters really well?

Last Answer : It depends on the area where you live, but if you are looking for a generic place to start looking is ultimatewasher.com. At this site you can find information on cleaning gutters.

Which Process writes data in Datafiles?

Description : Which Process writes data in Datafiles?

Last Answer : Database Writer background process DBWn (20 possible) writes dirty buffers from the buffer cache to the data files. In other words, this process writes modified blocks permanently to disk.

Which Process reads data from Datafiles?

Description : Which Process reads data from Datafiles?

Last Answer : Server Process - There is no background process which reads data from datafile or database buffer. Oracle creates server processes to handle requests from connected user processes. A server process ... , minimizing the number of server processes and maximizing the use of available system resources.

Point out the wrong statement. a) Taken as a unit, “Request => Process => Response” is not an atomic transaction b) A coherent transaction either succeeds and is enacted, or fails and is rolled back c) When rollback is not possible due to optimistic transaction commitment in a multiuser application, durability requires correcting the condition d) None of the mentioned

Description : Point out the wrong statement. a) Taken as a unit, Request => Process => Response is not an atomic transaction b) A coherent transaction either succeeds and is enacted, or ... transaction commitment in a multiuser application, durability requires correcting the condition d) None of the mentioned

Last Answer : Taken as a unit, “Request => Process => Response” is not an atomic transaction

The transfer of stress by tensile action employs T. reaction; a process that within limits: A. Fails to promote bone growth B. Promotes bone growth and maintenance C. Fails to promote maintenance D. None of the above

Description : The transfer of stress by tensile action employs T. reaction; a process that within limits: A. Fails to promote bone growth B. Promotes bone growth and maintenance C. Fails to promote maintenance D. None of the above

Last Answer : B. Promotes bone growth and maintenance

Which parameter specified in the DEFAULT STORAGE clause of CREATE TABLESPACE cannot be altered after creating the tablespace?

Description : Which parameter specified in the DEFAULT STORAGE clause of CREATE TABLESPACE cannot be altered after creating the tablespace?

Last Answer : All the default storage parameters defined for the tablespace can be changed using the ALTER TABLESPACE command. When objects are created their INITIAL and MINEXTENS values cannot be changed.

What will happen after commit statement ?

Description : What will happen after commit statement ?

Last Answer : Cursor C1 is Select empno, ename from emp; Begin open C1; loop Fetch C1 into eno.ename; Exit When C1 %notfound;----- commit; end loop; end; The cursor having query as SELECT .... FOR ... after COMMIT/ROLLBACK. The cursor having query as SELECT.... does not get closed even after COMMIT/ROLLBACK.

Is it possible to link two groups inside a cross products after the cross products group has been created?

Description : Is it possible to link two groups inside a cross products after the cross products group has been created?

Last Answer : no