Home » RDBMS Server » Server Administration » maxtrans and enqueue (10.2.0.1,RHEL 4)
maxtrans and enqueue [message #325865] Mon, 09 June 2008 05:07 Go to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
Session 1:

SQL>create table tab1(col1 number,col2 varchar2(20))
    initrans 1 maxtrans 1
SQL> /

Table created.

SQL> declare
  2  i number;
  3  begin
  4  for i in 1..10000 loop
  5  insert into tab1 values(i,'value');
  6  end loop;
  7  commit;
  8  end;
  9  /

PL/SQL procedure successfully completed.

SQL> update tab1 set col2='updated' where col1=1;

1 row updated.

Session 2:

SQL> update tab1 set col2='updated' where col1=2;

1 row updated.

Why Session 2 command is executed?

Since i have set maxtrans to 1, it should hang.
Re: maxtrans and enqueue [message #325867 is a reply to message #325865] Mon, 09 June 2008 05:13 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Because MAXTRANS is ignored in 10.2 and always set to the maximum.

Regards
Michel
Re: maxtrans and enqueue [message #325871 is a reply to message #325865] Mon, 09 June 2008 05:18 Go to previous message
varu123
Messages: 754
Registered: October 2007
Senior Member
Ok, i didn't know that and was testing 9i basics.
Previous Topic: archiver process
Next Topic: OracleJobSchedule[sid]" Service and OEM scheduled job ?
Goto Forum:
  


Current Time: Fri Nov 29 21:45:23 CST 2024