Increase Sga_Max_Size

Solution Search:
How can I increase SGA_MAX_SIZE in Oracle ? I got the error "ORA-03113: end-of-file on communication channel" during startup. Please help me with the steps to increase the SGA. I'm connected to Oracle9i Enterprise Edition Release 9.0.1.1.1... More...
May 22, 2007
Can I resize SGA while the database is up and running? Yes and no. It depends on your setting for SGA_MAX_SIZE. If you have not set this parameter, it defaults to your total SGA size. In this case, you cannot increase your SGA size while the instance is running but you can decrease the SGA size. If you want to increase your... More...
Mar 10, 2008
there is an SGA discrepancy?

1. Oracle 10.2.0.1.0 2. The SGA was inadequately sized... suggest 1480M 3. sho parameter sga sga_max_size big_integer 1148 sga_target big_integer 1148 4. alter system set sga_max_size=1480M scope=spfile; System altered 5. startup force [good] 6. sho parameter sga sga_max_size big_integer 1776M sga_target big_integer 1776M

How did 1776M occur? Why isn't it 1480M?
And I did not have to do an... More...

Apr 9, 2008
I have an Oracle 10g R2 database that I run on Linux Enterprise Edition 2.4.21-4.ELsmp. I recently increased the RAM from 2GB to 3GB, but when I try to increase the sga_max_size I get the following error on startup: "ORA-27102: out of memory." I modified the kernel parameter shmmax from 2147483648 to 3221225472, but the error still persists. Would you help me please?

If you are running... More...

Jun 5, 2007
important for tuning purposes? Some important ones are the size of your log buffer, and the sizes of your various SGA components (shared pool, database buffer cache). With 10g, you can set SGA_MAX_SIZE and SGA_TARGET, and Oracle will allocate SGA_MAX_SIZE bytes of shared memory on startup, then divide SGA_TARGET bytes of shared memory among the SGA components dynamically based on need. Similarly, setting... More...
Our database is Oracle 9.2.0.4 running on Linux AS 3.0. Our database is around 110GB and has 16GB RAM. Even though we have set the parameters in SGA_MAX_SIZE to 12G, shared pool size as 2G, db_cache as 4G and pga_aggregate as 800m (changed to different combinations), we are still seeing the database as fully utilized and there is also some hang in the database during... More...
Mar 27, 2006
size is 8 KB. My advice would be to take advantage of Oracle10g's ability to allocate SGA memory among the various components by specifying a value for SGA_TARGET. I would suggest setting SGA_MAX_SIZE to about 5 GB for starters and setting SGA_TARGET to 4GB. Run the system under load for a time and observe how much memory is provided to the various SGA areas. You can always reduce SGA_MAX_SIZE and/or SGA_TARGET... More...
Jan 18, 2006
key to an optimized Oracle database is often the architecture of the system and the parameters that set the environment for the database. Setting four key initialization parameters (SGA_MAX_SIZE, PGA_AGGREGATE_TARGET, DB_CACHE_SIZE, and SHARED_POOL_SIZE) can be the difference between sub-second queries and queries that take several minutes. There is also a new SGA_TARGET parameter that can replace... More...
Jun 19, 2007
Highlights of a recent survey include a six-fold increase in costs related to unauthorized access... More...
Jul 20, 2005
Oracle is seeking to increase its ownership stake in Indian banking software firm i-flex Solutions to 90... More...
Dec 12, 2006
Electing to become an Oracle Certified Professional will increase opportunities since many are needed and will increase your paycheck since they earn top wages. There are a variety of tracks to choose from: Java, database administration and applicaiton development. (Feb... More...
May 25, 2001
A spending survey conducted by SearchEnterpriseLinux.com indicates that enterprises will increase their Linux spending by as much as 10% or more in 2004... More...
Feb 12, 2004
With online sales expected to increase up to 25% this year, tech upgrades at retailers like L.L. Bean and Ice.com focus on back-end enhancements... More...
Nov 24, 2004
Oracle plans to increase its ownership stake in Indian software firm I-flex from 52.5% to 55.1%. Based in Mumbai, I-flex makes analytical software for the banking industry... More...
Aug 17, 2006
Oracle says its Oracle University training centers in Brazil to be turning out about 10,000 professionals per year by the end of 2007... More...
Jun 5, 2006
The Boston Celtics use data analytics to increase ticket sales and evaluate players. Better analytics ultimately means better basketball games, according to the team... More...
Feb 9, 2006
First Trust Corp. has put Linux at the heart of its business, pushing aside long-standing Unix systems to realize substantial cost savings and a performance increase... More...
Dec 8, 2003
Oracle's $23 billion buying spree appears to be paying off. The software giant reported a 25.4% increase in profit during the first quarter, in spite of critics... More...
Sep 25, 2007
Oracle Certified Professional certification is in demand, since employers want an objective way to measure their employees' skills. These exams will validate your knowledge, increase the company's value, and expand your wallet (Jan., 2001... More...
Jan 13, 2001
Telecoms looking to use data mining initiatives to reduce customer churn and increase revenue would do well to take a look at this article... More...
Jul 13, 2001
Oracle Collaboration Suite could save you money, increase your employees' productivity and integrate your vital communication systems. In this article, Oracle makes the case for its collaboration suite software... More...
Jun 23, 2003
According to this white paper, grid computing can lower costs and increase availability. Here, you can learn what Oracle has been doing with it and how you could benefit (or not). (Nov. 2002... More...
Jun 19, 2003
will greatly help. Here are are some suggestions. Check the database alert log. If you see messages like Checkpoint Incomplete, or if log files are switching frequently, then you need to increase the size and number of redo log files. Set or increase the size of the BUFFER parameter on your import. This will increase the size of the buffer that Oracle uses to do the bulk inserts. If possible, create a... More...
Jun 11, 2007
Which would increase performance more: moving an Oracle database to its own server, or moving the Oracle application to its own server? Assume the application is being used for demand planning and forecasting and there is a new... More...
Jul 24, 2006
How can I increase the size of a datafile in any tablespace (what is the command)? How can I be sure that I have increased the right file size in the right schema? To modify the size of a datafile, use the following command: ALTER DATABASE... More...
Jul 19, 2006
Oracle Content
Wayne’s World: A complete primer to mobile BI by Oracle Corporation
Business intelligence (BI) is a natural fit for mobile devices. In this eBook, appropriate for business intelligence professionals, get a complete, accessible overview of mobile BI from industry expert Wayne Eckerson.

Business intelligence (BI) is a natural fit for mobile...
Journal of Management Excellence: The Value of Information by Oracle Corporation
In this issue, our authors have done an outstanding job of exploring many facets of VOI. Robert Shimp discusses the shift in the economy from that of a services economy to an information management economy.

In this issue, our authors have done an outstanding job of exploring many...
Effective Enterprise Java Virtualization with Oracle WebLogic Suite by Oracle Corporation
This technical white paper explores in detail the technology behind a new virtualized deployment paradigm for Java EE applications, describing not only the technology behind these advances, but also the benefits and usage.

Increased operating costs, inefficient hardware...
Oracle Solutions
Oracle Database Vault by Oracle Corporation
Oracle Database Vault is the industry's leading database security solution for addressing regulatory compliance and concerns over the insider threat. Oracle Database Vault is the industry's leading...
eBook: Must-Know Applications Trends for Oracle Developers by CipherSoft, Inc., A subsidiary of Unify Corp.
Since Forms technology is widely in use in many Oracle environments, it's critical that developers and IT professionals understand Oracle's short and long term plans that could affect their strategies. Read more about the key trends that may affect how your...