Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2002
    Location
    Ireland
    Posts
    181

    Unanswered: what rollback segment a session is using

    Hi,

    I was wondering if was possible to find out what rollback segment is being use by a session.
    I have set the transaction to use a particular one but would like to confirm.

    Thanks for any help,
    Breen.

  2. #2
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    REM
    REM Users in rollback segments
    REM
    column rr heading 'RB Segment' format a18
    column us heading 'Username' format a15
    column os heading 'OS User' format a10
    column te heading 'Terminal' format a10
    select R.Name rr,
    NVL(S.Username,'no transaction') us,
    S.Osuser os,
    S.Terminal te
    from V$LOCK L, V$SESSION S, V$ROLLNAME R
    where L.Sid = S.Sid(+)
    and TRUNC(L.Id1/65536) = R.USN
    and L.Type = 'TX'
    and L.Lmode = 6
    order by R.Name
    /


    HTH
    Gregg

  3. #3
    Join Date
    Mar 2002
    Location
    Ireland
    Posts
    181
    Thanks for your help greg.
    Rgs,
    Breen.

  4. #4
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    Glad I could help

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •