White Papers

Self-Tuning Oracle9i Database: Oracle SGA

Overview As DBAs become more sophisticated in their self-tuning endeavors, many Oracle metrics may become self-tuning. In Oracle Database 10g, more self-tuning capability will be seen than ever before. For example, the dynamic memory allocation features of Oracle Database 10g make it possible to create a self-tuning Oracle SGA. By means of demonstration, in this paper the author will explain how to examine the Oracle instance in Oracle 9i Database and adjust the memory regions for sort_area_size or pga_aggregate_target, large_pool_size, sga_max_size and db_cache_size according to the processing demands on the server and within the database. The techniques discussed are based on the use of Statspack to monitor memory regions over time and develop signatures of system resource usage.

By downloading you agree to our Terms and Conditions. These include information regarding use of your personal data.

Publisher: Oracle
File Format: HTML
Date Published: Aug 21, 2007
Format: White Papers
Topics: Database Applications, Database Management

Similiar White Papers

Ten Things to Know About Grid Computing on Windows

This Oracle whitepaper offers insights into Oracle Grid.A grid allows a business to add capacity, cheaply, whenever it i

Publisher: Oracle | Tags: application server, computing, database, server

Maxmise IT Flexibility and Lower Costs With Grid Computing

This document discusses grid computing: Oracle's definition of it, the benefits of it, and the elements that comprise an

Publisher: Oracle | Tags: computing, grid computing

SGeRAC and Oracle RAC 10g R2 on HP-UX 11i Best Practices

This paper describes common best practices for configuring clusters with Serviceguard, Serviceguard Extension for RAC (S

Publisher: Hewlett-Packard (HP) | Tags: network

Bitmap Index Vs. B-Tree Index: Which and When?

Conventional wisdom holds that bitmap indexes are most appropriate for columns having low distinct values - such as GEND

Publisher: Oracle | Tags: data

Create and Deliver Reports with SQL Server Reporting Services 2008

If you work with report design or administration, this white paper is especially beneficial for you. You will learn how

Publisher: Global Knowledge

Oracle White Papers

Featured white papers

The Value of Location Intelligence in the Communications Industry

Pitney Bowes

Public Services are under pressure, the challenge is to do more with less. How do you improve citizen satisfaction, increase cost efficiencies and improve service delivery? The power of location intelligence is helping many local authorities...

Download now »
Best Practices for Translating Customer Satisfaction into Revenue

Citrix Online

Today's support organisations are focused on two top-level metrics: financial results and customer satisfaction. For most, it's easy to track financial performance, but customer satisfaction is akin to speaking a foreign language...

Download now »
HP print solutions and 3M

Hewlett-Packard (HP)

The objective for 3M was to optimize office printing infrastructure at 3M locations worldwide, reduce total cost and environmental footprint. Some of the business benefits acheived by switching to HP print solutions...

Download now »