Groups | Search | Server Info | Login | Register

Groups > comp.databases.oracle.server > #9283

Re: Rollback Segments in use by a session?

Show all headers | 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