What Is The Function Of Smon?

1.	What Is The Function Of Smon?
Answer» The SMON background PROCESS PERFORMS all system monitoring functions on the oracle database. Each time oracle is re-started, SMON performs a WARM start and makes sure that the transactions that were left incomplete at the LAST shut down are recovered. SMON performs periodic cleanup of temporary segments that are no LONGER needed. The SMON background process performs all system monitoring functions on the oracle database. Each time oracle is re-started, SMON performs a warm start and makes sure that the transactions that were left incomplete at the last shut down are recovered. SMON performs periodic cleanup of temporary segments that are no longer needed.

Answer»

The SMON background PROCESS PERFORMS all system monitoring functions on the oracle database.
Each time oracle is re-started, SMON performs a WARM start and makes sure that the transactions that were left incomplete at the LAST shut down are recovered.

SMON performs periodic cleanup of temporary segments that are no LONGER needed.

The SMON background process performs all system monitoring functions on the oracle database.
Each time oracle is re-started, SMON performs a warm start and makes sure that the transactions that were left incomplete at the last shut down are recovered.

SMON performs periodic cleanup of temporary segments that are no longer needed.

Discussion

No Comment Found

Related InterviewSolutions

What Is Sql Loader? Explain The Files Used By Sql Loader To Load File?
Explain Sga Memory Structures?
Explain Different Types Of Segment?
What Is The Function Of Smon?
What Is The Difference Between Vb Debugger And The Script Debugger?
Why Is The Use Of Exit Do Or Exit For Statements Within Loops Discouraged?
Write A Vbscript Procedure That Converts Feet To Inches. Hint: There Are 12 Inches In A Foot?
Assume You Have A Variable Called Age That Contains An Age Provided By The User. Write The Code That Ensures That The User Has Entered A Number As Her Age. If The User Hasn't Entered A Number, Tell Her She Needs To Enter Her Age Correctly?
Write The Code Required Within A Procedure To Create A Variable For Storing Your Name With Vbscript Code. Assign Your Name To That Variable?
What Aspects Of Vbscript Make It Safe So That A Web Page Using Vbscript Cannot Destroy Or Corrupt Information On A User's Computer?