Re: Performance Problem/Question

Mark - You need to post server type, # CPU's, other workload characterization, RAM size, and explain output of SQL in question. Off the top, I'd guess BUFFERS is too low, and RA_* parameters are too low. Greg Mark Stannard wrote: > > All: > > I am currently having a performance problem. This system is primarily > a batch system with most of the updates occuring at night. During the > day reports are pulled on the data loaded at night. If a report is requested > for a one month period of time the performance is acceptable although not > outstanding. However, if you ask for longer than one month then the snip.....