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
