--- title: Managing a Large Oracle Database SGA description: Learn how a performance issue in an Oracle database was resolved by disabling fast object checkpointing, improving system performance and batch processing times significantly. image: https://claremont.co.uk/hubfs/pexels-kevin-ku-92347-577585.jpg --- [Skip to content](https://claremont.co.uk/blog/managing-a-large-oracle-database-sga#main-content) [Release 12.2.14 is out now! Contact us to upgrade your Oracle EBS...](https://claremont.co.uk/oracle-ebs-upgrade) [![Claremont | Oracle E-Business Suite Services](https://claremont.co.uk/hs-fs/hubfs/Claremont%20Logos/Claremont_Logo_Blue.png?width=250&height=52&name=Claremont_Logo_Blue.png "Claremont | Oracle E-Business Suite Services")](https://www.claremont.co.uk) [![Claremont | Oracle E-Business Suite Services](https://claremont.co.uk/hubfs/Claremont%20Logos/Claremont_logo_white.svg "Claremont | Oracle E-Business Suite Services")](https://www.claremont.co.uk) - [About](https://claremont.co.uk/about-us) #### Claremont now part of DSP ![DSP-Logo-Blue](https://claremont.co.uk/hs-fs/hubfs/DSP%20Branding/DSP-Logo-Blue.png?width=200&height=205&name=DSP-Logo-Blue.png)In May 2022, DSP, the UK's Leading Oracle Partner acquired Claremont to further expand their Oracle expertise. The acquisition builds on DSP’s “Oracle Anywhere” strategy enabling it to deliver a 360° Oracle services portfolio and form one of the most comprehensive Oracle Partner service offerings in Europe. [Read More](https://content.dsp.co.uk/press-coverage/dsp-acquires-claremont)   #### Getting to know us - [About Us](https://claremont.co.uk/about-us) - [Leadership](https://www.dsp.co.uk/leadership) - [Case Studies](https://www.dsp.co.uk/case-studies) - [Blogs](https://claremont.co.uk/blog) - [Webinars](https://www.dsp.co.uk/webinars) - [Events](https://www.dsp.co.uk/events) - [Managed Services](https://claremont.co.uk/oracle-e-business-suite-managed-services) #### The Home of Oracle EBS Managed Services - [Oracle EBS Managed Service](https://claremont.co.uk/oracle-e-business-suite-managed-services) - [EBS DBA Support](https://claremont.co.uk/oracle-ebs-dba-support) - [Functional Support](https://claremont.co.uk/oracle-ebs-functional-support) - [Technical Support](https://claremont.co.uk/oracle-ebs-technical-support) - [Archive Managed Service](https://claremont.co.uk/oracle-e-business-suite-ebs-archive-managed-service) - [Extended Managed Service](https://claremont.co.uk/oracle-ebs-extended-managed-service) - [EBS Module Support](https://claremont.co.uk/oracle-ebs-module-support) #### National Trust Case Study ![National Trust - transparent thumbnail](https://claremont.co.uk/hs-fs/hubfs/Customer%20Logos/National%20Trust%20-%20transparent%20thumbnail.png?width=250&height=250&name=National%20Trust%20-%20transparent%20thumbnail.png)The NT uses Oracle E-Business Suite as its CRM System to manage member transactions. Our Managed Services team reduced the support backlog of incidents, problems, and changes in the NT’s CRM system. [Read More](https://www.dsp.co.uk/national-trust-oracle-ebs-managed-service-and-migration-to-claremont-case-study-cloud)   - [Consulting Services](https://claremont.co.uk/oracle-ebs-consulting) #### The UK's Leading Oracle EBS Partner - [Oracle EBS Upgrade](https://claremont.co.uk/oracle-ebs-upgrade) - [Oracle EBS Updates](https://claremont.co.uk/oracle-ebs-updates) - [Oracle EBS Licensing](https://www.dsp.co.uk/oracle-e-business-suite-licensing) - [Oracle EBS Extensions](https://www.dsp.co.uk/oracle-e-business-suite-extensions) - [Oracle EBS Mobile Apps](https://claremont.co.uk/oracle-ebs-mobile-apps) - [Oracle EBS Health Checks](https://claremont.co.uk/oracle-ebs-health-check) - [Oracle EBS Implementations](https://claremont.co.uk/oracle-ebs-implementations) - [Oracle ECC Deployments](https://claremont.co.uk/ecc-deployments) #### Unite Students Case Study ![Unite Students - transparent thumbnail](https://claremont.co.uk/hs-fs/hubfs/Customer%20Logos/Unite%20Students%20-%20transparent%20thumbnail.png?width=250&height=250&name=Unite%20Students%20-%20transparent%20thumbnail.png)Claremont has provided a solution capable of booking, managing, maintaining and analysing Unite Students’ complete property portfolio, allowing them to significantly differentiate themselves from their competitors. [Read More](https://www.dsp.co.uk/unite-students-oracle-ebs-application-implementation-case-study)   - [Hosting Services](https://claremont.co.uk/oracle-ebs-hosting-cloud-infrastructure) #### Cloud Hosting Solutions Tailored to Your Needs - [Hosting Oracle EBS on Private Cloud](https://claremont.co.uk/hosting-oracle-ebs-on-private-cloud) - [Hosting Oracle EBS on Public Cloud](https://claremont.co.uk/hosting-oracle-ebs-on-public-cloud) - [Oracle EBS Archiving](https://claremont.co.uk/oracle-ebs-archiving) #### Stonewater Case Study ![Stonewater](https://claremont.co.uk/hs-fs/hubfs/Customer%20Logos/Stonewater.png?width=200&height=200&name=Stonewater.png)Stonewater chose DSP to consolidate and migrate their assets to Oracle Cloud Infrastructure with an Oracle EBS Cloud Deployment, leading to a significantly reduced TCO. [Read More](https://www.dsp.co.uk/stonewater)   - More Services #### Oracle Services - [Oracle Database Managed Service](https://www.dsp.co.uk/oracle-database-managed-service) - [Oracle Database Consultancy Services](https://www.dsp.co.uk/oracle-consultancy) - [Oracle Cloud Services](https://www.dsp.co.uk/oracle-cloud-solutions-provider-csp) - [Oracle APEX Services](https://www.dsp.co.uk/oracle-apex-services) - [Oracle Licensing Services](https://www.dsp.co.uk/oracle-licensing-services) - [Oracle MySQL Services](https://www.dsp.co.uk/mysql-managed-services) - [Oracle Engineered Systems](https://www.dsp.co.uk/oracle-engineered-systems-partner) #### Microsoft Services - [SQL Server Managed Services](https://www.dsp.co.uk/sql-server-managed-services) - [SQL Server Consultancy](https://www.dsp.co.uk/sql-server-consultancy) - [Microsoft Azure Services](https://www.dsp.co.uk/microsoft-azure-services) - [Power BI Consultancy](https://www.dsp.co.uk/power-bi-services) #### Other Services - [Google Cloud Platform Services](https://www.dsp.co.uk/google-cloud-partner) - [API Development Services](https://www.dsp.co.uk/api-development-services) - [PostgreSQL Services](https://www.dsp.co.uk/postgresql-services) - [MongoDB Services](https://www.dsp.co.uk/mongodb-services) - [Hadoop Services](https://www.dsp.co.uk/hadoop-services) - [Contact Us](https://claremont.co.uk/contact-us) [Contact Us](https://claremont.co.uk/contact-us) This is a search field with an auto-suggest feature attached. - There are no suggestions because the search field is empty. # Managing a Large Oracle Database SGA [Ben Morris](https://claremont.co.uk/blog/author/ben-morris) Mar 27, 2013 11:59:00 AM ### Contents [Aug 29, 2014 5:50:00 PM Configuring Huge Pages For Database on Oracle Linux](https://claremont.co.uk/blog/configuring-huge-pages-for-database-on-oracle-linux) [Oct 12, 2022 4:21:00 PM How to improve the performance of Oracle E-Business Suite release 12.2 on a shared file system while using NFS Mount points](https://claremont.co.uk/blog/how-to-improve-the-performance-of-oracle-e-business-suite-release-12.2-on-a-shared-file-system-while-using-nfs-mount-points) [Apr 7, 2021 12:01:00 PM 6 of the best Oracle blogs for techies](https://claremont.co.uk/blog/6-of-the-best-oracle-blogs-for-techies) - [Tweet](https://twitter.com/share) Recently one of our customers experienced a number of performance related issues. These tended to be demonstrated during periods when the customer was running batch-type activities during the working day, clashing with the online user load. Due to business requirements rescheduling the batch work to out of hours was not an option, so a workable solution was required. The database is Oracle version 11.2.0.3 with a 60Gb System Global Area (“SGA”) and 40GB Program Global Area (“PGA”) running on a virtual server with 16 CPU cores, 128Mb RAM and using the Oracle Linux 5.8 operating system (“OS”). The OS uses huge pages, hence sga\_target rather than memory\_target is used in Oracle’s initialisation parameters, and the virtualisation platform is Oracle VM. Initial analysis was performed with Oracle Enterprise Manager (OEM) and showed the following load profile during an affected period: ![Diagram 1](https://www.claremont.co.uk/application/files/4315/8351/4351/MS_diag1.jpg?width=761&height=140&name=MS_diag1.jpg)   At face value, this would look to be a pretty typical storage IO issue, the blue on the above graph being dominant and showing IO to be circa 65% of all wait time in the database. However, the issue only affected online user performance during the periods where we see “red” on the graph. This is related to concurrency waits on blocking locks. After running some targeted tests set up to replicate the scenario over a sustained period of time, we saw the following:   ![Diagram 2](https://www.claremont.co.uk/application/files/1015/8351/4478/MS_diag2.jpg?width=758&height=188&name=MS_diag2.jpg)   Eventually, under this load, the system would get to a state where it ran out of redo space, and the infamous “checkpoint incomplete” error message occurred. It was also noted that the blocking locks were sessions waiting on the “ckpt” background process, producing, amongst others, the “enq KO: Fast Object Checkpoint” wait event.   A checkpoint is a point in time, before which all dirty buffers associated with historical SCNs  (or System Change Numbers) have been written to the physical data files and the datafile headers and controlfiles are updated to record this SCN. The checkpoint incomplete error occurs when the next redo log group is still awaiting the write of some dirty buffers (those which have changed) associated with the log group’s redo data.  The database hangs completely until the redo log group becomes available or until another empty one is added.   In this instance, the system had 25 1Gb redo log groups, so over a period of time 25Gb of redo had been generated before it was able to be written to disk. A slow IO subsystem was looking likely considering the nature of the performance graphs OEM gave us.  However, something wasn’t quite stacking up – the time it took to force the database into this state was ample to write this size of data to data files under normal circumstances.   The issue was actually related to a new feature in Oracle 11g – fast object checkpointing.  Fast object checkpointing is a mechanism intended to improve performance of direct path reads on data objects. A direct path read can only occur when there are no dirty buffers associated with the data block in memory – otherwise it would be data-inconsistent, or not actually a direct read. Therefore a fast object checkpoint will attempt to checkpoint all changes on an object-by-object basis rather than sequentially through SCN. This is to cut down on unnecessary duplicated writes to disk of buffer changes in the event of direct reads occurring.   We found the redo log groups were remaining active (i.e. the changes stored in them had not been written to datafiles) longer than seemed desirable. The large SGA has the ability to cache large amounts of data and since the database was also large (circa 3.5Tb), this data often pertained to the same object. Therefore a single direct read request on such an object caused the writing of all the blocks for a specific object to disk before completing a checkpoint. We saw contention in buffer cache latches and eventually ran into the dreaded checkpoint incomplete error where the database hangs causing user sessions to timeout and all manner of problems.   The fix was simply to set \_db\_fast\_obj\_ckpt=FALSE in the database’s initialisation parameters. This turned off fast object checkpointing and reverted to the old fashioned style of checkpointing, regardless as to object, based on a “first come, first served” basis. This means that the checkpoints completed more quickly, allowing the database to continue processing forwards without hanging on the checkpoint incomplete message.  The trade-off here was a degradation of performance in direct reads, but overall system performance was tested and found to have improved to a large degree, for example some batch processes take around 5 times less time to complete. More importantly, the system was then able to outlast sustained periods of load before redo space became a problem. [Aug 29, 2014 5:50:00 PM Configuring Huge Pages For Database on Oracle Linux](https://claremont.co.uk/blog/configuring-huge-pages-for-database-on-oracle-linux) [Oct 12, 2022 4:21:00 PM How to improve the performance of Oracle E-Business Suite release 12.2 on a shared file system while using NFS Mount points](https://claremont.co.uk/blog/how-to-improve-the-performance-of-oracle-e-business-suite-release-12.2-on-a-shared-file-system-while-using-nfs-mount-points) [Apr 7, 2021 12:01:00 PM 6 of the best Oracle blogs for techies](https://claremont.co.uk/blog/6-of-the-best-oracle-blogs-for-techies) [Next Oracle E-Business Suite 12.2 and Online Patching](https://claremont.co.uk/blog/oracle-e-business-suite-12.2-and-online-patching) #### Contact **Sales Enquiries** +44 (0) 203 880 1686 **Technical Support** +44 (0) 330 058 8367 **Accounts Team** +44 (0) 203 855 4160 [enquiries@claremont.co.uk](mailto:enquiries@claremont.co.uk) #### Follow Us #### European Locations [**London (Head Office)** 70 Gracechurch Street, London, EC3V 0HR](https://www.google.com/maps/place/70+Gracechurch+St,+Langbourn,+London+EC3V+0XL/@51.512117,-0.0869173,17z/data=!3m1!4b1!4m5!3m4!1s0x4876035256ab55cb:0x1f93b337c0190cf0!8m2!3d51.512117!4d-0.0847286) [**Leeds** Richmond House, Lawnswood Business Park, Leeds, LS16 6QY](https://www.google.com/maps/dir/53.8405223,-1.6062773/DSP-Explorer/@53.8404788,-1.6061783,17z/data=!4m9!4m8!1m1!4e1!1m5!1m1!1s0x4879591e5d204ac9:0x4e41b926d72adca!2m2!1d-1.6064847!2d53.8404842) [**Derby** Oberoi Business Hub](https://www.google.com/maps/place/Oberoi+Business+Hub/@52.9122857,-1.4544847,18z/data=!3m1!5s0x4879f100a33e1f13:0xec7015350054c46d!4m15!1m8!3m7!1s0x4879f100bd725ba7:0xe41f7b92cf5c3554!2sSt+Christopher's+Way,+Derby+DE24+8JY!3b1!8m2!3d52.9122715!4d-1.4523846!16s%2Fg%2F1tfpzcdf!3m5!1s0x4879f100a26d7637:0x54f72186b2624b42!8m2!3d52.9124866!4d-1.4519474!16s%2Fg%2F11bccjklqv?hl=en&entry=ttu) [19/20 St Christophers Way](https://www.google.com/maps/place/Oberoi+Business+Hub/@52.9122857,-1.4544847,18z/data=!3m1!5s0x4879f100a33e1f13:0xec7015350054c46d!4m15!1m8!3m7!1s0x4879f100bd725ba7:0xe41f7b92cf5c3554!2sSt+Christopher's+Way,+Derby+DE24+8JY!3b1!8m2!3d52.9122715!4d-1.4523846!16s%2Fg%2F1tfpzcdf!3m5!1s0x4879f100a26d7637:0x54f72186b2624b42!8m2!3d52.9124866!4d-1.4519474!16s%2Fg%2F11bccjklqv?hl=en&entry=ttu) [Pride Park](https://www.google.com/maps/place/Oberoi+Business+Hub/@52.9122857,-1.4544847,18z/data=!3m1!5s0x4879f100a33e1f13:0xec7015350054c46d!4m15!1m8!3m7!1s0x4879f100bd725ba7:0xe41f7b92cf5c3554!2sSt+Christopher's+Way,+Derby+DE24+8JY!3b1!8m2!3d52.9122715!4d-1.4523846!16s%2Fg%2F1tfpzcdf!3m5!1s0x4879f100a26d7637:0x54f72186b2624b42!8m2!3d52.9124866!4d-1.4519474!16s%2Fg%2F11bccjklqv?hl=en&entry=ttu) [Derby](https://www.google.com/maps/place/Oberoi+Business+Hub/@52.9122857,-1.4544847,18z/data=!3m1!5s0x4879f100a33e1f13:0xec7015350054c46d!4m15!1m8!3m7!1s0x4879f100bd725ba7:0xe41f7b92cf5c3554!2sSt+Christopher's+Way,+Derby+DE24+8JY!3b1!8m2!3d52.9122715!4d-1.4523846!16s%2Fg%2F1tfpzcdf!3m5!1s0x4879f100a26d7637:0x54f72186b2624b42!8m2!3d52.9124866!4d-1.4519474!16s%2Fg%2F11bccjklqv?hl=en&entry=ttu) [DE24 8JY](https://www.google.com/maps/place/Oberoi+Business+Hub/@52.9122857,-1.4544847,18z/data=!3m1!5s0x4879f100a33e1f13:0xec7015350054c46d!4m15!1m8!3m7!1s0x4879f100bd725ba7:0xe41f7b92cf5c3554!2sSt+Christopher's+Way,+Derby+DE24+8JY!3b1!8m2!3d52.9122715!4d-1.4523846!16s%2Fg%2F1tfpzcdf!3m5!1s0x4879f100a26d7637:0x54f72186b2624b42!8m2!3d52.9124866!4d-1.4519474!16s%2Fg%2F11bccjklqv?hl=en&entry=ttu) **[Dublin](https://www.google.com/maps/search/Inniscarra,+Main+Street,+Rathcoole,+Dublin/@53.2810032,-6.4764674,17z/data=!3m1!4b1?entry=ttu)** [Inniscarra,](https://www.google.com/maps/search/Inniscarra,+Main+Street,+Rathcoole,+Dublin/@53.2810032,-6.4764674,17z/data=!3m1!4b1?entry=ttu) [Main Street,](https://www.google.com/maps/search/Inniscarra,+Main+Street,+Rathcoole,+Dublin/@53.2810032,-6.4764674,17z/data=!3m1!4b1?entry=ttu) [Rathcoole,](https://www.google.com/maps/search/Inniscarra,+Main+Street,+Rathcoole,+Dublin/@53.2810032,-6.4764674,17z/data=!3m1!4b1?entry=ttu) [Dublin](https://www.google.com/maps/search/Inniscarra,+Main+Street,+Rathcoole,+Dublin/@53.2810032,-6.4764674,17z/data=!3m1!4b1?entry=ttu) #### North America Locations [**Ottawa**](https://www.google.com/maps/place/411+Legget+Dr,+Ottawa,+ON+K2K+3C9,+Canada/@45.3453062,-75.9105022,17z/data=!3m1!4b1!4m6!3m5!1s0x4cd1ffeda28bec45:0x2262adc8183266a7!8m2!3d45.3453062!4d-75.9105022!16s%2Fg%2F11c3q3qjm4?hl=en-GB&entry=ttu) [411 Legget Drive](https://www.google.com/maps/place/411+Legget+Dr,+Ottawa,+ON+K2K+3C9,+Canada/@45.3453062,-75.9105022,17z/data=!3m1!4b1!4m6!3m5!1s0x4cd1ffeda28bec45:0x2262adc8183266a7!8m2!3d45.3453062!4d-75.9105022!16s%2Fg%2F11c3q3qjm4?hl=en-GB&entry=ttu) [Suite 701](https://www.google.com/maps/place/411+Legget+Dr,+Ottawa,+ON+K2K+3C9,+Canada/@45.3453062,-75.9105022,17z/data=!3m1!4b1!4m6!3m5!1s0x4cd1ffeda28bec45:0x2262adc8183266a7!8m2!3d45.3453062!4d-75.9105022!16s%2Fg%2F11c3q3qjm4?hl=en-GB&entry=ttu) [Kanata](https://www.google.com/maps/place/411+Legget+Dr,+Ottawa,+ON+K2K+3C9,+Canada/@45.3453062,-75.9105022,17z/data=!3m1!4b1!4m6!3m5!1s0x4cd1ffeda28bec45:0x2262adc8183266a7!8m2!3d45.3453062!4d-75.9105022!16s%2Fg%2F11c3q3qjm4?hl=en-GB&entry=ttu) [ON](https://www.google.com/maps/place/411+Legget+Dr,+Ottawa,+ON+K2K+3C9,+Canada/@45.3453062,-75.9105022,17z/data=!3m1!4b1!4m6!3m5!1s0x4cd1ffeda28bec45:0x2262adc8183266a7!8m2!3d45.3453062!4d-75.9105022!16s%2Fg%2F11c3q3qjm4?hl=en-GB&entry=ttu) [K2K 3C9](https://www.google.com/maps/place/411+Legget+Dr,+Ottawa,+ON+K2K+3C9,+Canada/@45.3453062,-75.9105022,17z/data=!3m1!4b1!4m6!3m5!1s0x4cd1ffeda28bec45:0x2262adc8183266a7!8m2!3d45.3453062!4d-75.9105022!16s%2Fg%2F11c3q3qjm4?hl=en-GB&entry=ttu) [**Toronto**](https://www.google.com/maps/place/161+Bay+St,+Toronto,+ON+M5J+1C4/@43.6466205,-79.3809498,17z/data=!3m1!4b1!4m5!3m4!1s0x89d4cb2d1ffa4113:0x910adf0e4d771b3a!8m2!3d43.6466166!4d-79.3787611?hl=en-GB&shorturl=1) [TD Canada Trust Tower](https://www.google.com/maps/place/161+Bay+St,+Toronto,+ON+M5J+1C4/@43.6466205,-79.3809498,17z/data=!3m1!4b1!4m5!3m4!1s0x89d4cb2d1ffa4113:0x910adf0e4d771b3a!8m2!3d43.6466166!4d-79.3787611?hl=en-GB&shorturl=1) [161 Bay Street](https://www.google.com/maps/place/161+Bay+St,+Toronto,+ON+M5J+1C4/@43.6466205,-79.3809498,17z/data=!3m1!4b1!4m5!3m4!1s0x89d4cb2d1ffa4113:0x910adf0e4d771b3a!8m2!3d43.6466166!4d-79.3787611?hl=en-GB&shorturl=1) [Suite 2330](https://www.google.com/maps/place/161+Bay+St,+Toronto,+ON+M5J+1C4/@43.6466205,-79.3809498,17z/data=!3m1!4b1!4m5!3m4!1s0x89d4cb2d1ffa4113:0x910adf0e4d771b3a!8m2!3d43.6466166!4d-79.3787611?hl=en-GB&shorturl=1) [Toronto](https://www.google.com/maps/place/161+Bay+St,+Toronto,+ON+M5J+1C4/@43.6466205,-79.3809498,17z/data=!3m1!4b1!4m5!3m4!1s0x89d4cb2d1ffa4113:0x910adf0e4d771b3a!8m2!3d43.6466166!4d-79.3787611?hl=en-GB&shorturl=1) [ON](https://www.google.com/maps/place/161+Bay+St,+Toronto,+ON+M5J+1C4/@43.6466205,-79.3809498,17z/data=!3m1!4b1!4m5!3m4!1s0x89d4cb2d1ffa4113:0x910adf0e4d771b3a!8m2!3d43.6466166!4d-79.3787611?hl=en-GB&shorturl=1) [M5J 2S1](https://www.google.com/maps/place/161+Bay+St,+Toronto,+ON+M5J+1C4/@43.6466205,-79.3809498,17z/data=!3m1!4b1!4m5!3m4!1s0x89d4cb2d1ffa4113:0x910adf0e4d771b3a!8m2!3d43.6466166!4d-79.3787611?hl=en-GB&shorturl=1) [**Montreal**](https://www.google.com/maps/place/725+Boulevard+de+Maisonneuve+O,+Montr%C3%A9al,+QC/@45.50201,-73.574302,15z/data=!4m5!3m4!1s0x4cc91a46787e39af:0x260be1fbf0ee774f!8m2!3d45.5040751!4d-73.5716092?ll=45.50201,-73.574302&z=15&t=m&hl=en-GB&gl=CA&mapclient=embed&q=725-999+Boulevard+de+Maisonneuve+O+Montr%C3%A9al,+QC+H3A+3L4&shorturl=1) [2000 McGill College Avenue 6e étage Montréal QC H3A 3H3](https://www.google.com/maps/place/725+Boulevard+de+Maisonneuve+O,+Montr%C3%A9al,+QC/@45.50201,-73.574302,15z/data=!4m5!3m4!1s0x4cc91a46787e39af:0x260be1fbf0ee774f!8m2!3d45.5040751!4d-73.5716092?ll=45.50201,-73.574302&z=15&t=m&hl=en-GB&gl=CA&mapclient=embed&q=725-999+Boulevard+de+Maisonneuve+O+Montr%C3%A9al,+QC+H3A+3L4&shorturl=1) [T2P 5C5](https://www.google.com/maps/place//data=!4m2!3m1!1s0x53716fe2d30437cd:0x83b76c388e1b9fee?source=g.page.share) [**Minneapolis**](https://www.google.com/maps/place/1650+West+End+Blvd+%23100,+St+Louis+Park,+MN+55416,+USA/@44.966643,-93.348228,15z/data=!4m6!3m5!1s0x52b334a30885024d:0xdf4b02e006f8776c!8m2!3d44.9667611!4d-93.3484684!16s%2Fg%2F11pvcvdwr2?hl=en-GB&entry=ttu) [1650 West End Blvd](https://www.google.com/maps/place/1650+West+End+Blvd+%23100,+St+Louis+Park,+MN+55416,+USA/@44.966643,-93.348228,15z/data=!4m6!3m5!1s0x52b334a30885024d:0xdf4b02e006f8776c!8m2!3d44.9667611!4d-93.3484684!16s%2Fg%2F11pvcvdwr2?hl=en-GB&entry=ttu) [Suite #100](https://www.google.com/maps/place/1650+West+End+Blvd+%23100,+St+Louis+Park,+MN+55416,+USA/@44.966643,-93.348228,15z/data=!4m6!3m5!1s0x52b334a30885024d:0xdf4b02e006f8776c!8m2!3d44.9667611!4d-93.3484684!16s%2Fg%2F11pvcvdwr2?hl=en-GB&entry=ttu) [St Louis Park](https://www.google.com/maps/place/1650+West+End+Blvd+%23100,+St+Louis+Park,+MN+55416,+USA/@44.966643,-93.348228,15z/data=!4m6!3m5!1s0x52b334a30885024d:0xdf4b02e006f8776c!8m2!3d44.9667611!4d-93.3484684!16s%2Fg%2F11pvcvdwr2?hl=en-GB&entry=ttu) [Minnesota](https://www.google.com/maps/place/1650+West+End+Blvd+%23100,+St+Louis+Park,+MN+55416,+USA/@44.966643,-93.348228,15z/data=!4m6!3m5!1s0x52b334a30885024d:0xdf4b02e006f8776c!8m2!3d44.9667611!4d-93.3484684!16s%2Fg%2F11pvcvdwr2?hl=en-GB&entry=ttu) [USA](https://www.google.com/maps/place/1650+West+End+Blvd+%23100,+St+Louis+Park,+MN+55416,+USA/@44.966643,-93.348228,15z/data=!4m6!3m5!1s0x52b334a30885024d:0xdf4b02e006f8776c!8m2!3d44.9667611!4d-93.3484684!16s%2Fg%2F11pvcvdwr2?hl=en-GB&entry=ttu) [55416](https://www.google.com/maps/place/1650+West+End+Blvd+%23100,+St+Louis+Park,+MN+55416,+USA/@44.966643,-93.348228,15z/data=!4m6!3m5!1s0x52b334a30885024d:0xdf4b02e006f8776c!8m2!3d44.9667611!4d-93.3484684!16s%2Fg%2F11pvcvdwr2?hl=en-GB&entry=ttu) #### About Us Claremont, part of [DSP](http://www.dsp.co.uk), is the UK's leading Oracle E-Business Suite Partner. Specialising in Oracle EBS Managed Services, Consulting and Hosting. ![Oracle EBS Expertise](https://claremont.co.uk/hs-fs/hubfs/Expertise%20Logos/E-Business%20Suite/o-sell-prtnr-OracleEBS-EMEA-BENELUX-clr-rgb.png?width=150&height=87&name=o-sell-prtnr-OracleEBS-EMEA-BENELUX-clr-rgb.png)![Oracle EBS App to Oracle Cloud Expertise](https://claremont.co.uk/hs-fs/hubfs/Expertise%20Logos/EBS%20to%20OCI/Oracle%20EBS%20App%20to%20Oracle%20Cloud%20Expertise.png?width=150&height=98&name=Oracle%20EBS%20App%20to%20Oracle%20Cloud%20Expertise.png)   Registered Office: 2 Leman Street, London, United Kingdom, E1W 9US Company Registration Number: 05294592 [Privacy Policy](https://www.dsp.co.uk/privacy-policy) - [Cookies Policy](https://www.dsp.co.uk/cookies-policy) - [Accessibility](https://www.dsp.co.uk/accessibility) Copyright © 2024. Premiertec Consulting Ltd, trading as Claremont IT Services Ltd. All Right Reserved. ![Oracle EBS Partner](https://claremont.co.uk/hs-fs/hubfs/Certifications/Approachable_UKAS.jpg?width=150&height=95&name=Approachable_UKAS.jpg) ![Oracle EBS Partner](https://claremont.co.uk/hs-fs/hubfs/Certifications/new-cep-badge.png?width=100&height=119&name=new-cep-badge.png)   ```json { "@context" : "https://schema.org", "@type" : "BlogPosting", "dateModified" : "2024-10-01", "datePublished" : "2024-10-01", "headline" : "Managing a Large Oracle Database SGA", "image" : [ "https://144513092.fs1.hubspotusercontent-eu1.net/hubfs/144513092/pexels-kevin-ku-92347-577585.jpg" ], "mainEntityOfPage" : { "@id" : "https://claremont.co.uk/blog/managing-a-large-oracle-database-sga", "@type" : "WebPage" } } ``` ```json { "@context" : "https://schema.org", "@type" : "BlogPosting", "author" : { "@type" : "Person", "name" : "Ben Morris", "url" : "https://claremont.co.uk/blog/author/ben-morris" }, "dateModified" : "2024-07-15T10:59:41.385Z", "datePublished" : "2013-03-27T11:59:00.000Z", "headline" : "Managing a Large Oracle Database SGA", "image" : [ "https://claremont.co.uk/hubfs/pexels-kevin-ku-92347-577585.jpg" ], "mainEntityOfPage" : { "@id" : "https://claremont.co.uk/blog/managing-a-large-oracle-database-sga", "@type" : "WebPage" }, "publisher" : { "@type" : "Organization", "logo" : { "@type" : "ImageObject", "url" : "https://claremont.co.uk/hubfs/Claremont%20Logos/Claremont_Logo_Blue.png" }, "name" : "Claremont" } } ```