Best approach for resizing SGA

What is the best approach for resizing the SGA? I have a Solaris Server with 8 gigs of RAM with three databases on the server. Is there a formula for how to configure the SGA?

It's important to mention which version of Oracle you are running when you ask a question such as this. If you are running Oracle9i or later, you can let Oracle manage SGA component sizes. Define the init.ora parameter SGA_TARGET to set the total SGA size for an instance; Oracle will arrive at an initial configuration, and then adjust the sizes of SGA areas as needed.

This was last published in March 2006

Dig Deeper on Oracle database performance problems and tuning

All
News
Get Started
Evaluate
Manage
Problem Solve

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

Meet all of our Oracle Database / Applications experts

View all Oracle Database / Applications questions and answers

SearchDataManagement

The main picks for Hadoop distributions on the market

Check out the current top Hadoop distribution vendors in the market to help you determine which product is best for your company.

Inside view of Tibco integration architecture planning

Tibco's acquisitions of well-regarded, small software specialists such as SnappyData are part of a drive toward what it calls '...

Lumina launches Radiance, a data risk management platform

In an effort to prevent data loss, Lumina launched Radiance, a SaaS data risk management platform. It collects and analyzes data ...

SearchBusinessAnalytics

Tableau launches BI software update, upgrades map technology

Tableau Software has released Tableau 2019.2, an update to previous BI software. It includes upgrades to location data, new ...

McDonald's orders up customer service analytics, shakes up fast food

The fast-food giant announced last month that it is acquiring Dynamic Yield, a big data platform, in pursuit of a more ...

Sisense acquisition of Periscope yields versatile BI platform

The Sisense merger with Periscope Data is expected to create a new, combined BI product that will cater to casual business users ...

SearchSAP

Patch early, patch often to manage SAP exploit

In this Q&A, Onapsis CEO Mariano Nunez and SAP security head Tim McKnight discuss the recent SAP security system threat and what ...

Plattner: Cloud is the way forward for S/4HANA systems

In this Q&A, SAP's Hasso Plattner explains why the cloud is the best option for SAP S/4HANA systems and why companies must know ...

Hasso Plattner discusses the state of the SAP HANA database

In this Q&A, SAP co-founder Hasso Plattner explains why SAP HANA is now more accessible with the new HANA Cloud Services and can ...

SearchSQLServer

Check SQL Server Query Store performance impact before using

Many IT teams are hesitant to use SQL Server Query Store due to performance concerns. Consultant Andy Warren offers advice on how...

SQL Server vs. MySQL: Learn the differences

MySQL and Microsoft SQL Server relational databases have their pros and cons. Weigh the differences between SQL Server and MySQL ...

SQL Server performance tuning best practices for DBAs

Tuning database performance is a complex process, but consultant Joey D'Antoni details a list of SQL Server performance tuning ...

TheServerSide.com

Don't let plugins open up more Jenkins vulnerabilities

Let's explore the Blue Ocean, Config File Provider and Groovy plugins with security vulnerabilities. Here's how to address them, ...

NetBeans Java IDE becomes top-level Apache project

The NetBeans Java development environment has achieved top-level project status at the Apache Software Foundation, a leading open...

Use entropy as a service to bolster your security

Cryptographic keys help improve security in your enterprise. Consider entropy as a way to safeguard your data and prevent hackers...

SearchDataCenter

3 ways to approach cloud bursting

With different cloud bursting techniques and tools from Amazon, Zerto, VMware and Oracle, admins can bolster cloud connections ...

Exascale computing, now at $2.8B, described as critical to U.S.

The race to build exascale supercomputers is a project of big governments -- China, Japan, the European Union and the U.S. ...

HPE-Cray deal brings supercomputers to enterprises for AI

HPE's $1.3 billion deal to acquire supercomputing pioneer Cray Inc. should better position the company in the HPC market among IT...

SearchContentManagement

Box workflow automation software, Box Relay, overhauled

Content management software vendor Box makes over Box Relay, integrating the workflow automation system more fully into the Box ...

Fluid Framework opens the door to new Microsoft capabilities

Fluid Framework provides multiuser co-authoring capabilities -- offering never-seen-before flexibility. It also has the potential...

The power of enterprise collaboration software and tools

Research indicates that companies are snapping up enterprise collaboration software. But do they know how to boost worker ...

SearchHRSoftware

Improved HR security may be why W-2 scams are down

HR's focus on better securing employee data may be working. In its annual data breach investigations report, Verizon found a ...

Manage information overload with AI, insight curation tools

With information increasingly spread across several sources, knowledge workers often struggle to find what they need quickly. ...

PTC headquarters follows open-plan digital workplace strategy

Moving from suburb to booming Boston Seaport District required a huge HR change management effort and interior design that ...

Dig Deeper on Oracle database performance problems and tuning

Have a question for an expert?

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.