To generate Redologs frequently

[cam_01]

Hi

I want to carry out a test and need to simulate a condition so
that redologs are generated at a very high frequency.

What can be the best and easiest way to generate redo logs at
a high frequency i.e to have Archive log writes frequency rate too high, less than 5min.


Any ideas ?.

Thanks

[sambavan]

Writ a procedure that would do a loop insert/update/deleter form a table(s). This would geneerate redologs


Sam

[Chintz]

This can be done by setting the following parameters in the init.ora file:

LOG_CHECKPOINT_INTERVAL - This specifies the interval in blocks between log checkpoints. Setting it to larger than the size of the redo logs allows checkpoints only when logs fill.
LOG_CHECKPOINT_TIMEOUT - This parameter specifies the time interval between log checkpoints. Setting this to zero forces checkpoints only when logs fill.

Chintz

[jmodic]

1. Create a very small redo log files
2. Generate a high transactions activity.

Using only standard SCOTT schema will do, without even actually changing any database data. For example:

CREATE TABLE scott.emp1 AS SELECT * FROM scott.emp WHERE 1=2;

BEGIN
FOR i IN 1..100000 LOOP
INSERT INTO scott.emp1 SELECT * FROM scott.emp;
UPDATE scott.emp1 SET empno=123*empno, sal=123*sal, manager='xyz';
DELETE FROM scott.emp1;
ROLLBACK;
END LOOP;
END;
/

[jmodic]

Originally posted by Chintz
This can be done by setting the following parameters in the init.ora file:

LOG_CHECKPOINT_INTERVAL - This specifies the interval in blocks between log checkpoints. Setting it to larger than the size of the redo logs allows checkpoints only when logs fill.
LOG_CHECKPOINT_TIMEOUT - This parameter specifies the time interval between log checkpoints. Setting this to zero forces checkpoints only when logs fill.

None of this two parameters have any influence on redo log generation... As you mention, they influence only on the frequency of checkpoints, which have no impact on the log switches or the amount of redo log generated.

[badrinathn]

How about switching the logfiles from the other session so that, the archive logs keep generating.Ofcouse, before the logfie switching, some dml should be performed.


alter system switch logfile

Badrinath

[cam_01]

Thanks

JModic it worked. I appreciate it.