Re: Database testing

Hi Pap,

After you capture the workload, the next step it's preprocessing. It depends on the size and type of your workload, but be aware that preprocessing time increases nonlinearly with increasing capture workload time. For example, we were able to preprocess only 30-60 minutes of captured production workload in the cluster in a reasonable amount of time.

--

Anton Spitsyn

Database Administrator

http://aspitsyn.wordpress.com


On Mon, Aug 30, 2021 at 11:18 PM Pap <oracle.developer35_at_gmail.com> wrote:



> Hello Listers, We are trying to use the "real application testing" feature


> to test one of the upgrade changes. And during the capture workload from

> production ,we want to do it for the whole day(~15-16hrs) as we have

> different critical jobs running throughout and want to replay that

> ~15-16hrs of captured workload to see and compare their response as against

> run time production.

>

> Few team members stating we should not capture the workload for such a

> long duration but should do it for a 5-6hrs window only as a bigger window

> will average out the results and we may miss real performance issues? Want

> to understand from experts, if that thought is correct?

>


--
http://www.freelists.org/webpage/oracle-l