databasejournal.com databasejournal.com

Activating, Monitoring, and Tuning Automatic PGA Memory Management via PGA_AGGREGATE_TARGET Under Oracle 9i - Page 2

Jim Czuprynski Using PGA_AGGREGATE_TARGET To Activate Automatic Memory Management To activate automatic PGA memory management, the PGA_AGGREGATE_TARGET initialization parameter must be set to a non-zero value (Oracle defaults its setting to zero unless overridden). However, just as we would do with tuning the SGA, Oracle recommends setting an initial value, evaluating the results over time, and then tuning the PGA based on those...

databasejournal.com databasejournal.com

SQL Server 2000 Installation

Introduction Hardware and Software Requirements SQL Server Editions Installation Types Testing an installation Literature Introduction In this article I want to tell you about some general details of SQL Server 2000 installation. I also described hardware and software requirements for SQL Server 2000 and SQL Server 2000 editions. Hardware and Software Requirements Hardware requirements: Intel or compatible...