What is user global area (UGA)?
What is user global area (UGA)?
Rating:
User global area (UGA) is an area in the large pool that stores session-related information. It should be created in the large pool to prevent fragmentation of the shared pool. This is because the shared pool is used for shared procedures and configuring UGA in it deteriorates its performance. If the shared server mode is used, the UGA is created in the large pool, and the space of UGA is specified by the large_pool_size initialization parameter. If the dedicated (non-shared) server mode is used, the UGA becomes a part of the process global area (PGA) in the user space and the session-related information is then stored in PGA. However, under the multi-threaded server mode, the UGA is configured in the shared global area.
Rating:
Other articles
- How is a client/server connection established in a dedicated server environment?
- What is a process failure?
- What is parallelization of backup sets?
- What is an open backup?
- What is row migration ?