[PERFORM] Which PARAMETER is most important for load query??

2005-01-20 Thread amrit
I'm dealing with big database [3.8 Gb] and records of 3 millions . Some of the query seems to be slow eventhough just a few users in the night. I would like to know which parameter list below is most effective in rising the speed of these queries? Shmmax = 32384*8192 =265289728 Share buffer =

Re: [PERFORM] Which PARAMETER is most important for load query??

2005-01-20 Thread Christopher Kings-Lynne
[EMAIL PROTECTED] wrote: I'm dealing with big database [3.8 Gb] and records of 3 millions . Some of the query seems to be slow eventhough just a few users in the night. I would like to know which parameter list below is most effective in rising the speed of these queries? Shmmax = 32384*8192