On 9/20/06, goran bogdanovic <goran00@xxxxxxxxx> wrote:
Hi,
The inittrans should correspond to your max active concurrent dml sessions on that table
goran
On 9/20/06, BN < bnsarma@xxxxxxxxx> wrote: > > > > On 9/19/06, Christian Antognini <Christian.Antognini@xxxxxxxxxxxx > > wrote: > > > > > > > > > I was thinking of INITRANS , is there a way to track that from > > > v$lock, > > > I remember once Steve Adams answering some body looking at v$lock > > > looking at Request Column, not sure though > > > > Hi > > > > Here an example of sessions waiting for a transaction slot: > > > > SQL> SELECT event FROM v$session_wait WHERE sid = 12; > > > > EVENT > > ----------- > > enqueue > > > > SQL> SELECT type, id1, id2, lmode, request FROM v$lock WHERE sid = 12; > > > > > > TY ID1 ID2 LMODE REQUEST > > -- ---------- ---------- ---------- ---------- > > TM 34522 0 3 0 > > TX 393247 9877 0 4 > > > > As you can see the request mode is S (4). > > > > > > HTH > > Chris > > -- > > //www.freelists.org/webpage/oracle-l > > > > > > > Greetings, > > Yes I saw Request=4 for quite a few sessions. I ahve Identified the > Tables that needs INITRANS Bump. Is there a way to figureout how much > should I bump for each table in question > > -- > Regards & Thanks > BN >
Greetings
Yes, I understand, is there a view in the Datadictionary to check how much each table has reached, other than tracking/sampling v$lock or v$transaction
-- Regards & Thanks BN
