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

Originators form group to boost Presto SQL query engine

The Presto engine arose as an alternative to Hive for big data queries. Now, the Presto Software Foundation has formed to promote...

5 best practices for managing real-time data integration

Real-time data integration isn't like traditional data integration -- "it's moving, it's dirty and it's temporal," cautions one ...

Web integration platform eases way to machine learning models

StoryFit data scientists employ machine learning algorithms to gauge film script scenarios' prospects. They use Import.io tools ...

SearchBusinessAnalytics

Tableau Ask Data gives BI users simple NLP data query tool

Tableau's new Ask Data software uses natural language processing to enable users of any skill level to more easily search for ...

Expert urges data pros to hone data science skills

IT expert William McKnight shares job tips for data professionals looking to prosper in a changing enterprise. His first piece of...

Demand for data scientists is booming and will only increase

Fueled by big data and AI, demand for data science skills is growing exponentially, according to job sites. The supply of skilled...

SearchSAP

SAP managed services weed out IT complexity at Ball Horticulture

Ball Horticultural outsourced its SAP Basis administration to Symmetry when the complexity of its SAP environment grew, but ...

Haribo can't bear SAP S/4HANA implementation

Haribo's recent deployment of S/4HANA may have led to problems getting its products into stores, but experts believe they could ...

10 record-to-report tips in SAP ECC for audit compliance

Ensuring a comprehensive segregation of duties and limiting the financial postings that can be made manually are some of the ways...

SearchSQLServer

Talend Stitch tools load data to Azure SQL Data Warehouse

Cloud data warehouses see serious data transformation work moving cloud side. Talend's first integration with Stitch, which it ...

5 trends for SQL Server environments as SQL Server 2019 looms

SQL Server is undergoing new changes, as Microsoft prepares to release the 2019 version of the database software. Other changes ...

SQL Server 2019 improves Linux, container support

The SQL Server 2019 release includes new big data integration features, a collection of database engine enhancements and improved...

TheServerSide.com

Master-slave terminology alternatives you can use right now

Software companies have found alternatives for master-slave terminology to describe their distributed systems. It's time for the ...

RESTful parameters antipattern considerations for queries, paths

Choose carefully for path and query parameters in URL design. Lackluster choices in the design phase can plague client resource ...

Developers find cautious optimism for serverless platforms

Experts urge cautious optimism around serverless development. It has its benefits, but tools that don't work as expected and a ...

SearchDataCenter

How to prepare your data center for an HCI appliance

Vendors tout hyper-converged infrastructure as a plug-and-play offering, but before you install anything in your data center, be ...

Hone these top 5 data center skills in 2019

As data centers become more software-based, admins should prepare themselves by learning about the cloud, containers, DevOps and ...

Carbon Relay debuts AI-based software for data center cooling

Newcomer Carbon Relay has introduced two products that use artificial intelligence to help IT pros manage data center efficiency.

SearchContentManagement

Personalized content solidifies the customer experience

Today's customers expect customized, curated digital experiences. Learn how to deliver what customers need and stay ahead of the ...

Create a winning personalized customer journey

Web content management platforms, customer data platforms and matchmaking can all help companies create and implement a ...

Google, WordPress develop a CMS for news

Google is funding a WordPress-based content management system aimed at helping small news publishers juggle the demands of ...

SearchHRSoftware

LinkedIn's recruiting platform billed as 'Intelligent Hiring Experience'

LinkedIn's use of AI requires the sharing of data. It is one reason why the company is combining its talent tools into one system...

HR chatbots take on recruitment, benefits tasks

HR chatbots are taking on straightforward administrative tasks in recruitment and benefits. And that could be a good thing for HR...

Despite demand, few job ads cite flexible work options

Flexible work options are desirable, but not advertised. Hired has acquired Py, a platform used by employers to assess a ...

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.