Dr. Ralf Czekalla > > Hi Chinmay, > > "Dhodapkar, Chinmay S" wrote: > > > > Well, it's a part of a bigger setup that I need to test. I cannot > > describe the whole reasons of why I want to turn off cache...but the > > basic reason is that I want to put a HEAVY load on the > disk(and maybe > > the processor). (although I know there are benchmarks > available to do > > that...) > > My only question is whether it is possible to turn off the cache? > > Will setting DATA_CACHE to 0 work? > > Thanks! > > -Chinmay > > so far I did never ever had this idea so that I never tested it. > Therefore I can't answer this. But try it. I suppose you will > then find > some error messages in the knldiag file that the database won't run > without DATA_CACHE or CACHE_SIZE (set to 0) and the kernel will stop > then. > > Ciao Ralf >
Minimal CACHE_SIZE is 800 as given in the help info for this installation parameter. But if you have big tables, doing tables scans, doing joins with big results, your cache will have not enough space to hold all the things needed during those statements and will throw out pages from cache and read and write (pages with resultrows). Elke SAP Labs Berlin > > -----Original Message----- > > From: Dr. Ralf Czekalla [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, July 09, 2003 11:40 AM > > To: Dhodapkar, Chinmay S > > Cc: [EMAIL PROTECTED] > > Subject: Re: sapdb newbie question > > > > > I am running a standalone SAPDB (7.3.0.25) on linux. > > > > > > Is there a way I can turn off caching by sapdb > completely? (both read > > and write) > > > > Let me answer with a question: Why would you want to wipe out the > > gearing out of a Porsche? Would it then drive any longer. > > > > The caches are implemented so deep in the SAP DB (shadow memory > > architecture) that it wouldn't work without, like a Porsche > without a > > gearing. > _______________________________________________ > 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
