16 lines
282 B
SQL
16 lines
282 B
SQL
-- DROP TABLE t_commit;
|
|
-- CREATE TABLE t_commit AS SELECT 1 a FROM dual;
|
|
|
|
-- experiment with
|
|
-- ALTER SESSION SET COMMIT_LOGGING = IMMEDIATE;
|
|
-- ALTER SESSION SET COMMIT_WRITE = WAIT;
|
|
|
|
BEGIN
|
|
FOR i IN 1..10000 LOOP
|
|
UPDATE t_commit SET a=a+1;
|
|
COMMIT;
|
|
END LOOP;
|
|
END;
|
|
/
|
|
|