Tag: db

Server Process,”Oracle creates server processes to handle the requests of user processes connected to the instance. In some situations when the application and Oracle operate on the same machine, it is possible to combine the user process and corresponding server process into a single process to reduce system overhead. However, when the application and Oracle operate on different machines, a user process always communicates with Oracle through a separate server process.Server processes (or the server portion of combined user/server processes) created on behalf of each user’s application can perform one or more of the following:Parse and run SQL statements issued through the applicationRead necessary data blocks from datafiles on disk into the shared database buffers of the SGA

Database

Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Server Process,”Oracle creates server processes[…]

Read more

PMON or Process monitorback,”Monitors the other background processes and performs process recovery when a server or dispatcher process terminates abnormallyPMON periodically performs cleanup of all the following:*Processes that died abnormally*Sessions that were killedtimeout*Detached network connections which have exceeded their idle timeoutIn addition, PMON monitors, spawns

Database

Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.PMON or Process monitorback,”Monitors the[…]

Read more

parsing,”Each time you execute a SQL statement, a lot happens in the background. This background activity is called parsing. Parsing can be quite expensive.During parsing, some of these things happen:The statement syntax is checked to make sure you typed everything correctly.The objects you’re referring to are checked. For example, if you’re trying access a table called emp

Database

Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.parsing,”Each time you execute a[…]

Read more