Refer to OSS Note 337445 for explanation on how to calculate OMS_HEAP_LIMIT for AIX.
thanks bj ----- Original Message ----- From: "Zabach, Elke" <[EMAIL PROTECTED]> To: "'Kok Seng Pun'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, February 06, 2002 10:25 AM Subject: RE: liveCache Parameters setting > Kok Seng Pun wrote: > > > I am running APO 3.0A with liveCache 7.2.5 Build 11 (SAP-DB). The > > liveCache is running on a IBM p660 SP-Attached with 24GB RAM, > > sitting on AIX > > 4.3. > > I am encountering some performance issues with the LC that > > puzzled me. As > > such, I would like to understand more regarding the following:- > > > > 1) Locks Escalation. How can I know what types and how many > > locks are used > > at a single point of time? > > select the system-view domain.locks > > > When will locks escalation occurs? > > if row locks (share + exclusive) of one table exceeds > 20% of all possible locks (see configuration-parameter MAXLOCKS) > then an escalation is possible. > > > How can I 'delay' locks escalation? > > increase configuration-parameter MAXLOCKS > > > 2) Heap Memory. For AIX platform, what should be the value for > > OMS_HEAP_LIMIT? Is there a rule of thumb? > > Good question for SAP/R3 - liveCache support. > Here we will not answer questions concerning R/3-applications, > settings needed for those and so on. It will be dependant on the > application, > not on the database itself. > > Elke > SAP Labs Berlin > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
