Sorry, I mentioned wrong note number, kindly go through SAP note number 441663
this described the solution of your problem please.
Thanks and regards
Mahesh Pandey
Quoting [Email address protected]
> Following are the astract of SAP note number 12366 which talk about maximum
> addressable memory to oracl sga:-
>
> NT/Windows 2000: For Windows (NT or 2000) a maximum of 2 GB of local
> process memory can be allocated.
> For the SGA, approx. 1.3 GB remain. However, this depends on the
> number of the shadow processes/threads in the database process
> (also see Note 130140). If the number of shadow processes/threads
> is very high (> 200), the SGA may have to be zoomed so that errors
> do not occur when you allocate memory at runtime.
> 2.5 GB memory (NT Intel) is only possible with the Enterprise
> Edition of Windows NT 4.0 Service Pack 3 and only as of Oracle
> 7.3, latest patch level (refer to Note 142019).
>
>
> Hope this will help you.
>
> Regards
> Mahesh Pandey
> SAP DBA
>
>
> Quoting Harish Karan-Technology-Hyderabad
> <oracledba-ezmlmshield-x78964430.[Email address protected]
>
> >
> > Mahesh,
> >
> > We are using the windows 32 bit and we had modified the boot.ini so that
> > it can detect 6 GB memory, but there is a parameter called LOCK_SGA to
> > lock the usage of virtual memory and make use of physical memory.
> >
> > Is this Parameter can make use of physical memory more and virtual less,
> > what are the loop pools?
> >
> > If some one help me
> >
> >
> >
> > THANKS & REGARDS
> >
> > S.R.HARISH KARAN
> >
> > -----Original Message-----
> > From: MaheshPandey
> > [mailto:oracledba-ezmlmshield-x2831141.[Email address protected]
> > Sent: Wednesday, June 27, 2007 9:19 AM
> > To: LazyDBA Discussion
> > Subject: Re: Virtual memory than the Physical Memory
> >
> > Is window2003 std 32 bit or 64 bit:?
> >
> > If 32 bit then window can not allocate memory more then 4 GB, if you
> > want to use
> > physical memory more then 4 GB then put /fastdetect/PAE/3GB option in
> > boot.ini
> > file.
> >
> > Regards Mahesh Pandey
> > SAP DBA
> > DSCL KOTA
> > [Email address protected]
> >
> >
> > Quoting Antuan Avdioukhine
> > <oracledba-ezmlmshield-x16383447.[Email address protected]
> >
> > > On Tue, Jun 26, 2007 at 06:22:45PM +0530, Harish
> > Karan-Technology-Hyderabad
> > > wrote:
> > > >
> > > > I am running SAP Prod on Oracle 9.2.0.6 on windows 2003 STD, the
> > > > problem is oracle service is using max Virtual memory than the
> > Physical
> > > > Memory,
> > > >
> > > >
> > > >
> > > > Physical memory 6 GB it uses 25% Approx
> > > >
> > > > Virtual memory 12 GB it users 74% Approx
> > > >
> > > > Can someone justify, it will be very helpful.
> > >
> > > This is not error. This is points a situation, where process alocated
> > > about 10G of memory, but 9G is not ever used at all. You can check
> > > another processes which never or very rare used. Maybe it is resonable
> > > to reduce amount of memory given to process because it is not needed.
> > >
> > > >
> > > >
> > ---------------------------------------------------------------------
> > > > TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> > > > To post a dba job: http://jobs.lazydba.com
> > > > To Subscribe : http://www.LazyDBA.com
> > > > To unsubscribe: http://www.lazydba.com/unsubscribe.html
> > > >
> > >
> > > --
> > > Antuan Avdioukhine (DEKA-RIPE).
> > > Convey Plus Telecommunications
> > > St.Petersburg, Russia.
> > >
> > >
> > > ---------------------------------------------------------------------
> > > TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> > > To post a dba job: http://jobs.lazydba.com
> > > To Subscribe : http://www.LazyDBA.com
> > > To unsubscribe: http://www.lazydba.com/unsubscribe.html
> > >
> > >
> > >
> > > ______________________________________________________________________
> > > This email has been scanned by the MessageLabs Email Security System
> > for DCM
> > > Shriram Consolidated Ltd. For more information please contact
> > > [Email address protected] or visit http://www.messagelabs.com/email
> > > ______________________________________________________________________
> > >
> >
> >
> >
> >
> >
> >
> > Confidentiality Notice
> >
> > The information contained in this communication and any accompanying
> > document(s) is confidential and/or privileged material of DCM Shriram
> > Consolidated Limited & group companies. This information is intended
> > only for the person or entity to which it is addressed. Any review,
> > retransmission, dissemination or other use of, or taking of any action
> > in reliance upon, this information by persons or entities other than the
> > intended recipient is unlawful and prohibited. If you have received this
> > message in error and / or are not the intended recipient, please notify
> > immediately the sender or DCM Shriram Consolidated Limited at [Email
> > address protected] and permanently delete the original message. The
> > views expressed in this e-mail message (including any attachments) are
> > those of the individual sender except where the sender expressly, and
> > with authority, states them to be the views of DCM Shriram Consolidated
> > Limited and the same shall be subject to the terms and conditions in
> > governing contract in writing, if any.
> >
> >
> > ---------------------------------------------------------------------
> > TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> > To post a dba job: http://jobs.lazydba.com
> > To Subscribe : http://www.LazyDBA.com
> > To unsubscribe: http://www.lazydba.com/unsubscribe.html
> >
> >
> >
> > Disclaimer:
> > Information contained in this email can be used only by the intended
> > recipient or by the people who are authorized to use it.If you are not the
> > right recipient, we kindly request you to notify the sender.
> > Any unauthorized use,copying and distribution of this information is
> strictly
> > prohibited.SerWizSol cannot assure that emails are timely, secure and
> virus
> > free.
> > Opinions made in this mail are not approved by SerWizSol and these solely
> > belong to the sender.
> > SerWizSol is a contact center with multi channel customer service
> capability
> > and offers voice based inbound and outbound interactions and interactions
> > through E-mail, Chat and Collaborative Web Sessions.
> >
> >
> > ---------------------------------------------------------------------
> > TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> > To post a dba job: http://jobs.lazydba.com
> > To Subscribe : http://www.LazyDBA.com
> > To unsubscribe: http://www.lazydba.com/unsubscribe.html
> >
> >
> >
> > ______________________________________________________________________
> > This email has been scanned by the MessageLabs Email Security System for
> DCM
> > Shriram Consolidated Ltd. For more information please contact
> > [Email address protected] or visit http://www.messagelabs.com/email
> > ______________________________________________________________________
> >
>
>
>
Confidentiality Notice
The information contained in this communication and any accompanying document(s) is confidential and/or privileged material of DCM Shriram Consolidated Limited & group companies. This information is intended only for the person or entity to which it is addressed. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is unlawful and prohibited. If you have received this message in error and / or are not the intended recipient, please notify immediately the sender or DCM Shriram Consolidated Limited at [Email address protected] and permanently delete the original message. The views expressed in this e-mail message (including any attachments) are those of the individual sender except where the sender expressly, and with authority, states them to be the views of DCM Shriram Consolidated Limited and the same shall be subject to the terms and conditions in governing contract in writing, if any.
Oracle LazyDBA home page