Re: Rollback Segments in use by a session?

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> (permalink)
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

Show key headers only | View raw

On Thursday, April 9, 1998 at 9:00:00 AM 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 = l.sid
> and trunc (l.id1(+)/65536) = 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 company as Oracle Database Administrator, I have been given task by my boss to always  "Display database sessions using rollback segments" I have been trying many queries from different guys, it didn't work, but your script help me a lot with result that I mostly need. 

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

Back to comp.databases.oracle.server | Previous | Next | Find similar

Thread

Re: Rollback Segments in use by a session? Gatjiek Kuach <gatjiekkuachlul@gmail.com> - 2024-01-29 23:44 -0800

csiph-web