redo buffer max size

Posted on 2004-11-10
Medium Priority
Last Modified: 2010-08-05
would u plz tell me what is the maximum size of redo buffer?
my OS is windows 2000 advanced server SP4.
Question by:amiri
1 Comment

Accepted Solution

pettmans earned 1000 total points
ID: 12621097
Are you talking Oracle? Assuming Yes, then I don't think there is a limit specifically on the size of the redo buffer. However, sizing of this component contributes to the overall size of the SGA and there is a platform/os specific limit on the size of SGA. For for most 32 bit operating systems max SGA size is around 3.5 GB. For Windows2000 I have read that max SGA <3GB:

From a forum on metalink:
"Eventhough you are using Windows 2000 Advance Server, the size of the SGA must still fit into the 3GB address space of physical memory. This is the limitation of the OS and the fact that it is of 32-bit architecture."

Scott Pettman

Featured Post

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Creating a Cordova application which allow user to save to/load from his Dropbox account the application database.
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Suggested Courses

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question