X-Received: by 2002:a0c:beca:0:b0:689:7d9a:9acf with SMTP id f10-20020a0cbeca000000b006897d9a9acfmr242560qvj.13.1706600679757; Mon, 29 Jan 2024 23:44:39 -0800 (PST)
X-Received: by 2002:a0c:bec1:0:b0:681:7708:3f20 with SMTP id f1-20020a0cbec1000000b0068177083f20mr115218qvj.7.1706600679504; Mon, 29 Jan 2024 23:44:39 -0800 (PST)
Path: csiph.com!news.mixmin.net!proxad.net!feeder1-2.proxad.net!209.85.160.216.MISMATCH!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.databases.oracle.server
Date: Mon, 29 Jan 2024 23:44:39 -0800 (PST)
In-Reply-To: <6ghl64$lic$1@reader1.reader.news.ozemail.net>#1/1>
Injection-Info: google-groups.googlegroups.com; posting-host=102.222.61.25; posting-account=GD-33goAAABB9BbEC4_fOcUuhTIH8yWz
NNTP-Posting-Host: 102.222.61.25
References: <01bd62fb$5ffbe920$2207030a@sahmad-pc.mfa.com> <6ghl64$lic$1@reader1.reader.news.ozemail.net>#1/1>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <1699f675-be01-4a2f-b1b6-10e9ff2b0b64n@googlegroups.com>
Subject: Re: Rollback Segments in use by a session?
From: Gatjiek Kuach <gatjiekkuachlul@gmail.com>
Injection-Date: Tue, 30 Jan 2024 07:44:39 +0000
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Xref: csiph.com comp.databases.oracle.server:9283

On Thursday, April 9, 1998 at 9:00:00=E2=80=AFAM UTC+2, Doug Carter wrote:
> Hi Saad,
> >Is there a way to find out what rollback segments
> >are being used by a session
> This is not exactly what you want - but the logic
> should be enough to point you in the right direction.
> The following displays session and rbs segment
> details for sessions with locks in a rollback
> segment.
> select l.sid,
> l.type,
> s.username,
> r.owner,
> r.segment_name,
> l.lmode,
> l.request,
> l.id1,
> l.id2
> from dba_rollback_segs r, v$lock l, v$session s
> where s.sid =3D l.sid
> and trunc (l.id1(+)/65536) =3D r.segment_id
> /
> I don't have a database handy - but you might
> be able to use v$resource as a source for id1.
> Cheers
> Doug Carter
> Database Administrator
> TUI Consulting
Dear Doug Carter,

I am Gatjiek Kuach, I am South Sudanese working with Telecommunication comp=
any as Oracle Database Administrator, I have been given task by my boss to =
always  "Display database sessions using rollback segments" I have been try=
ing many queries from different guys, it didn't work, but your script help =
me a lot with result that I mostly need.=20

Thank so much for devoting your time with that script.
Respectfully,
Gatjiek Kuach
Database Administrator
Digitel Telecom.