Database Tuning (MOSC)

MOSC Banner

Mistery about commit statement

edited Jan 15, 2015 10:02AM in Database Tuning (MOSC) 3 commentsAnswered

hi!

I read a lot regarding commit enhacements in 10g and also 11g and everything seems clear to me. But on my databases I can't understand the results of this test script, where I compare the different types of commit:

/*
CREATE TABLE COMMIT_TEST
(
  ID           NUMBER(10),
  DESCRIPTION  VARCHAR2(50 CHAR)
)
TABLESPACE USERS
NOCOMPRESS ;


CREATE UNIQUE INDEX COMMIT_TEST_PK ON COMMIT_TEST
(ID)
TABLESPACE USERS;

ALTER TABLE COMMIT_TEST ADD (
  CONSTRAINT COMMIT_TEST_PK
  PRIMARY KEY
  (ID)
  USING INDEX COMMIT_TEST_PK
  ENABLE VALIDATE);
*/

SET SERVEROUTPUT ON

DECLARE
  PROCEDURE do_loop (p_type  IN  VARCHAR2) AS
    l_start  NUMBER;
    l_loops  NUMBER := 2000;

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center