From Oracle FAQ
Jump to: navigation, search

The User Global Area (UGA) is a memory area (RAM) that holds session-based information.

Dedicated Server[edit]

When running in Dedicated Server mode (one session = one dedicated process), the UGA is stored in the PGA (process global area).

Shared Server[edit]

When running in Shared Server mode (MTS with shared servers and dispatchers), sessions can be served by multiple server processes. As a result, the UGA cannot be stored in the PGA, and is moved to the SGA (shared global area).

Also see[edit]

Glossary of Terms
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z #