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
- What is row migration ?
- What is datafile striping?
- What is the CONTROL_FILE_RECORD_KEEP_TIME initialization parameter?
- What is the Import utility?
- What is ONLINE option?