RE: Sizing the rollback segments

Not off the top of my head, but here is a query that will help you see
who is using what segment:)

SELECT s.sid, s.username, s.program,
t.used_ublk, t.used_urec,t.used_ublk,c.segment_name,c.tablespace_name
FROM v$session s, v$transaction t , dba_rollback_segs c
WHERE s.taddr = t.addr
and t.xidusn = c.segment_id
;

BTW, the UNDO is a lot easier in the long run.

-----Original Message-----
From: Benbart
[mailto:oracledba-ezmlmshield-x30288047.[Email address protected]
Sent: Wednesday, April 27, 2005 6:57 PM
To: LazyDBA Discussion
Subject: Sizing the rollback segments

Hi all,
I am getting ORA-01555 errors on my rollback segments. I know the
usual practice is to resize the rollback segments which in most cases is
to increase the size of your rollback segments. Am not using UNDO
tablespaces and there is no plan to start using one, don't ask
why. While I can increase the size of the rollback segment, I
want to know if anyone have any SQL or scripts that I can use to make a
more intelligent or smart assessment of how large should I resize
my rollback segment to?
Any advise will be greatly appreciated, thanks ...
 

--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html

Oracle LazyDBA home page