SGA/TMP size - HxGN EAM - 12.1 - Customization & Programming - Hexagon

HxGN EAM Architecture and Server Management

ft:locale
en-US
Product
HxGN EAM
Search by Category
Customization & Programming
HxGN EAM Version
12.1

The System Global Area (SGA) is a shared memory area used by Oracle database processes. The three main components are: shared pool, log buffer and database buffer cache. Increase the SGA size in Oracle and TMP size in MS SQL will ensure the queries and data are cached in memory longer for faster retrieval and processing.