Re: find whether "set transaction use rollback segment" command is used

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Thu, 6 Jun 2002 23:26:48 +1000
Message-ID: <tyJL8.6417$Hj3.21133@newsfeeds.bigpond.com>

Look in v$transaction

Richard
"Joe Philip" <joephilip2002_at_comcast.net> wrote in message news:WqJL8.144440$%o.13683645_at_bin3.nnrp.aus1.giganews.com...
> Is there a way I can find from the database whether the "set transaction
use
> rollback segment" is used in any of our transactions. I am finding a lot
of
> contention on one of our rollback segments. (There are 5 rollback
segmenets
> for this database.)
>
>
Received on Thu Jun 06 2002 - 08:26:48 CDT

This message: [ Message body ]
Next message: Thomas Kyte: "Re: intermittent commit on insert ?"
Previous message: Telemachus: "Re: Where is tkprof on Oracle 901"
In reply to: Joe Philip: "find whether "set transaction use rollback segment" command is used"
Next in thread: Niall Litchfield: "Re: find whether "set transaction use rollback segment" command is used"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US