On 9/20/06, goran bogdanovic <goran00_at_gmail.com> wrote:
>
> Hi,
>
> The inittrans should correspond to your max active concurrent dml sessions
> on that table
>
> goran
>
>
> On 9/20/06, BN < bnsarma_at_gmail.com> wrote:
> >
> >
> >
> > On 9/19/06, Christian Antognini <Christian.Antognini_at_trivadis.com >
> > 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
> > > --
> > > http://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
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Sep 20 2006 - 09:14:53 CDT
