Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Shared pool,”caches various types of[…]
Read moreAuthor: mfadmin
Large pool,”is an optional memory area in the SGA. It is intended for memory allocations that are larger than is appropriate to store in the shared pool. Eg
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Large pool,”is an optional memory[…]
Read moreJava pool
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Java pool It stores all[…]
Read moreStreams pool
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Streams pool is used exclusively[…]
Read morePGA(Program Global Area)
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.PGA(Program Global Area) The Program[…]
Read moreOracle Flashback,”Oracle Flashback
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Oracle Flashback,”Oracle Flashback a means[…]
Read moreIn-Doubt Transactions
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.In-Doubt Transactions The two-phase commit[…]
Read moreServer 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
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“Process, Job, task”
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.“Process, Job, task” A Thread[…]
Read moreDatabase Listener
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Database Listener The listener is[…]
Read more