Hi,
Can anyone point pros/cons of shrinking a rollback segment ? (other
than performance overheads associated with extent allocation and
reallocation)
Optimal is not set for my rollback segments. Recently I shrunk a
rollback segments which had more than 100 extents allocated
Shrinking of rollback segments may result in ORA-1555s. If you need to shrink
them, do so during a slow time.
Not shrinking rollback segments may result in ORA-1562 unable to extend rbs.
Satav, Pawan wrote:
Hi,
Can anyone point pros/cons of shrinking a rollback segment ? (other
than
I have a client where rollback segments were set up RBS01-RBS05, all in a
tablespace called RBS. The person who set it up set %INCREASE at 50%. Well,
I shrank the segments to themselves down to less than 500MB total from
4.6GB! But in using ALTER DATABASE DATAFILE . . . RESIZE . . . it won't let
Michael Milligan wrote:
I have a client where rollback segments were set up RBS01-RBS05, all in a
tablespace called RBS. The person who set it up set %INCREASE at 50%. Well,
I shrank the segments to themselves down to less than 500MB total from
4.6GB! But in using ALTER DATABASE DATAFILE . .
Micheal,
Could you shrink the rbs even smaller? This should work if the first two
extents of each rbs are in the 'first' blocks of the datafile. If not, the best
solution is to create new smaller ones as you drop the others and then resize.
Regardless of the solution, do this during a slow time
The high water mark for the rollback segments is preventing you from shrinking the files.
Use alter rollback segment SEGMENT_NAME storage ( optimal OPTIMAL_SIZE)
to set an optimal size for the segment, then use 'alter rollback segment SEGMENT_NAME shrink'
to shrink the rollback.
You may want
Thanks for the info.
It's 8.1.7.4, and it's not hard-coded. I changed it from 50% to 0%, but the
damage had been done. Maybe you're just nostalgiac for the good old days of
v6!
I did set an optimal, and used shrink. That worked fine to shrink the
segments, but they are still scattered
Daniel,
Thank you very much. I'll do what you suggested, on both counts. I'll try
shrinking them more first, then create new ones if needed.
Thanks again,
Mike
-Original Message-
Sent: Monday, November 17, 2003 2:49 PM
To: Multiple recipients of list ORACLE-L
Micheal,
Could you
Dear Gurus,
I have a problem loading data from flat file using SQL*Loader. The problem is unable
to extend rollbacksegment. Is there a way to assign BIG rollback segment to SQL*Loader
transaction? If not what is the work around to load huge volume of data without using
TRUNCATE option?
Thanks
[EMAIL PROTECTED] wrote:
Dear Gurus,
I have a problem loading data from flat file using SQL*Loader. The problem is unable
to extend rollbacksegment. Is there a way to assign BIG rollback segment to
SQL*Loader transaction? If not what is the work around to load huge volume of data
PROTECTED] wrote:
I have a problem loading data from flat file using SQL*Loader. The problem is
unable to extend rollbacksegment. Is there a way to assign BIG rollback segment to
SQL*Loader transaction? If not what is the work around to load huge volume of data
without using TRUNCATE
when we were using oracle8i , whe had some process which use set transaction use
rollback segment.
and now we use undo tablespace and we have still same porocesses .
how can set a rollbback segment for process with undo tablepsace
--
Please see the official ORACLE-L FAQ: http
Is there any way to find out created time stamp for a rollback segment
apart from looking into alert.log.
TIA
Kranti
This message is for the designated recipient only and may contain
privileged, proprietary, or otherwise private information. If you have
received it in error, please notify
Is there any way to find out created time stamp for
a rollback segment
apart from looking into alert.log.
TIA
Kranti
If you think of some column in a dictionary table, I don't think so. Auditing is
another solution, besides scanning the alert.log file.
Regards,
Stephane Faroult
Oriole
Hi,
When you create a RBS the creation entry will be there in the alert.log
Senthil.
-Original Message-
[EMAIL PROTECTED]
Sent: Tuesday, June 03, 2003 12:40 PM
To: Multiple recipients of list ORACLE-L
Is there any way to find out created time stamp for a rollback segment
apart from
I have recently found that one temporary rollback
segment in system tablespace is having more then 600 extnets . It looks like
previous dba created this rollback segment at the time of db creation and forgot
to take it offline .
Now how do I find it this rollback segment is being
used
, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Friday, March 14, 2003 3:54 PM
To: Multiple recipients of list ORACLE-L
I have recently found that one temporary rollback segment in system
tablespace is having more then 600 extnets . It looks like previous
You can take the rollback segment offline. It will not impact any currently
running transactions and no new transactions will be assigned to it. Oracle
will not let you drop a rollback segment while there are any active transactions
writing undo to the rollback segment. IIRC, the v
looking for here is the 'XACTS' column to be zero for the rollback segment
you want to take offline.
Once you see it is not in use, shrink it: 'alter rollback segment RBSNAME shrink;'.
Then take it offline. If it is taking up too much space, maybe drop and recreated it
with smaller extent sizes
I am create database on ORACLE 9iR2 and fail on create
rollback segment.
SQL create tablespace rollback_space datafile
2 '/u4/oradata/TRAN/rbs01TRAN.dbf'
size 800M
3 default storage (
4 initial 256k
5 next 256k
6
Mike,
Check the setting for undo_management. It needs to be set to MANUAL.
mike mon wrote:
I am create database on ORACLE 9iR2 and fail on create
rollback segment.
SQL create tablespace rollback_space datafile
2 '/u4/oradata/TRAN/rbs01TRAN.dbf'
size 800M
3
Mike
The only way this would have worked under 8i is if you had already
created a dummy rollback segment in the SYSTEM tablespace. Something
like this should work (before or after the CREATE TABLESPACE
rollback_space)
SQL connect / as sysdba;
SQL CREATE ROLLBACK SEGMENT dummy;
Pete
Title: RE: Create rollback segment under ORACLE 9ir2 failed
I see other people have already answered your question, but would it be presumptuous of me to ask why you are using ROLLBACK segments instead of an UNDO tablespace?
-Original Message-
From: mike mon [mailto:[EMAIL
Mike, et.al,
Mea Culpa. Please ignore my previous post. I failed to properly
context switch from my Automatic Undo mode.
IIRC, as of 7.3, the requirement for a second rollback segment in
SYSTEM was removed, with minor exceptions. I think the one that is
biting you is that a second RBS
And what Pete said does work.
Here is a report from my testing of undo mode switching (AUM - MUM). Rollback
tablespace was already created.
SQL create rollback segment rbs01 tablespace rollback;
create rollback segment rbs01 tablespace rollback
*
ERROR at line 1:
ORA-01552: cannot use system
Title: Which rollback segment is currently active?
Hi,
If you
want to drop one of the the RBS, First you have to check in the application
level. Which user that used the rollback segment.
select
username,name,used_ublk,start_time,sum(waits),sum(gets),sum(waits)*100/sum(gets)from
v
Title: Which rollback segment is currently active?
I have three rollback segments which all show ONLINE. I want to drop one of them but I need to know which one should I drop. How do I find out which one is good to drop?
SVRMGR select segment_name,owner,tablespace_name,status from
Title: Which rollback segment is currently active?
Check
v$rollstat for xact 0.
-Original Message-From: Nguyen, David M
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, February 04, 2003 6:24
PMTo: Multiple recipients of list ORACLE-LSubject: Which
rollback segment is currently
(+)
anddo.object_id = lo.object_id;
If you offline a rollback segment that a transaction is using, Oracle puts
it in offline pending status.
Bigger question: What are you trying to do? Do you feel you have too many
rollback segments? Usually I create a new rollback segment and put it online
before I take
Title: Which rollback segment is currently active?
select rs.usn, xacts
active_transactions, gets, waits, writes, name from v$rollstat rs,
v$rollname rnwhere rs.usn = rn.usn
This
may help...
-Original Message-From: Nguyen, David M
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, February
Dear all DBAs,
i'm using Oracle 8.0.5 on Linux 6.4 kernel
2.2.14.
when i try to place the rollback segment
online,
it show error as below:
SQL ALTER ROLLBACK SEGMENT "RB28"
ONLINE;ALTER ROLLBACK SEGMENT "RB28" ONLINE*ERROR at line
1:ORA-01599: failed to acquire
: Can
not place rollback segment online
Dear all DBAs,
i'm using Oracle 8.0.5 on Linux 6.4 kernel
2.2.14.
when i try to place the rollback segment
online,
it show error as below:
SQL ALTER ROLLBACK SEGMENT "RB28"
ONLINE;ALTER ROLLBACK SEGMENT "RB28"
To: Multiple recipients of list ORACLE-L
Dear all DBAs,
i'm using Oracle 8.0.5 on Linux 6.4 kernel 2.2.14.
when i try to place the rollback segment online,
it show error as below:
SQL ALTER ROLLBACK SEGMENT RB28 ONLINE;
ALTER ROLLBACK SEGMENT RB28 ONLINE
*
ERROR at line 1:
ORA-01599: failed
.
when i try to place the rollback segment online,
it show error as below:
SQL ALTER ROLLBACK SEGMENT RB28 ONLINE;
ALTER ROLLBACK SEGMENT RB28 ONLINE
*
ERROR at line 1:
ORA-01599: failed to acquire rollback segment (28), cache space is full
(currently has (29) entries)
If use oerr ora 1599
Hi
I noticed few of rollback segment in one of Database are having few waits.Is
it necessary to create rollback segment with new size? Can u please some one
send some infor on rollback segment tunning?
Thx
-Seema
_
Add photos
hi, list friends:
I am interested in that
topic:http://www.ioug.org/ioug_s/repository_pkg.doc?v_tech_content_dtl_phy_id=7666
I am also considering whether too large rbs segment size does have adverse
impact on database performance. In my production (OLTP) i configured rbs to be
error message.
First of all, the size or number of extents in a rollback segment does not
affect the performance of SQL statements. Of course, if the size of the
extents is extremely small and the number of extents varies wildly up and
down, then the sheer overhead of extent maintenance might
Hi all
i am trying to execuate one procedure which upadte the table containing 29443 records.
After 2 hours going in loop, procedure returns following error:
SQL exec test
BEGIN test; END;
*
ERROR at line 1:
ORA-01562: failed to extend rollback segment number 2
ORA-01628: max # extents (249
3 options
1. if possible , put a commit in your procedure to reduce load on rollback
segs
2. ask your dba to increase size of rollback segments. Since rollback
segment allocation is random, u may have to drop the smaller rbs segs and
create new larger segs
3. increase the maxextents of existing
Hi all,
Trying here now since have tried to find it online and build the query
myself.
I need to figure out how much space a user/session is using of a rollback
segment.
I got the queries to show which segment the user is attached to but need to
know how much is being used (something like
,
Trying here now since have tried to find it online and build the query
myself.
I need to figure out how much space a user/session is using of a rollback
segment.
I got the queries to show which segment the user is attached to but need to
know how much is being used (something like a fuel gauge
,
t.start_time,
s.sql_address Address,
s.sql_hash_value Sql Hash
FROM sys.v_$session s, sys.v_$transaction t, sys.v_$rollname r
WHERE t.addr = s.taddr AND t.xidusn = r.usn
ORDER BY t.start_time
Try this. It shows the undo blocks used in the rollback segment. Plus
some other variables for query
recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Wed, 23 Oct 2002 09:02:17 -0800
Hi all,
Trying here now since have tried to find it online and build the query
myself.
I need to figure out how much space a user/session is using of a rollback
segment.
I got the queries to show which segment
AND t.xidusn = r.usn
ORDER BY t.start_time
Try this. It shows the undo blocks used in the rollback segment. Plus
some other variables for query usage.
-Original Message-
Sent: Wednesday, October 23, 2002 12:02 PM
To: Multiple recipients of list ORACLE-L
Hi all,
Trying here now since
We have ORACLE 8.1.7.4 running on NT. My questions are:
1. What difference between public rollback segment and private segement?
2. what is benefit on public segment than private segment?
3. does public segment only use on paraller server (RAC)?
Thanks
public rollback segment and private segement?
2. what is benefit on public segment than private segment?
3. does public segment only use on paraller server (RAC)?
Thanks.
_
Choose an Internet access plan right for you -- try MSN
segments is that they are
segments reserved for a particular use or a particular transaction. The only
difference between Public and Private rollback segments is in relation to
the Parallel Server Option. A public rollback segment can be acquired
implicitly by any instance in a parallel server
`Private' rollback segments is that they are
segments reserved for a particular use or a particular transaction. The only
difference between Public and Private rollback segments is in relation to
the Parallel Server Option. A public rollback segment can be acquired
implicitly by any instance
and Private rollback segments is in relation to
the Parallel Server Option. A public rollback segment can be acquired
implicitly by any instance in a parallel server environment. A private
rollback segment must be explicitly acquired by a particular instance using
the rollback_segments parameter
This is my understanding of "private" versus
"public" rollback segments:
Private RBS can be brought online only via
explicit ALTER ROLLBACK SEGMENT xxx ONLINE command.
The "init.ora" parameter ROLLBACK_SEGMENTS is
only a list for the automatic
[mailto:mccdba;hotmail.com]
Sent: Thursday, October 17, 2002 11:19 AM
To: Multiple recipients of list ORACLE-L
Subject: [Q] Public and private rollback segment?
We have ORACLE 8.1.7.4 running on NT. My questions are:
1. What difference between public rollback segment and
private
Comment:
The fact that a PUBLIC rollback segment comes online at startup
without altering the init.ora is a very useful feature.
I am at this moment creating a 40 gig RBS tablespace in an SAP
database, to be used by a single PUBLIC rollback segment.
There are certain utility operations
No, I don't think so.
11:08:27 rsysdevdb.radisys.com - jkstill@dv01 SQL create tablespace
puglic rollback segment jks tablespace rbs;
Rollback segment created.
11:08:47 rsysdevdb.radisys.com - jkstill@dv01 SQL alter rollback segment
jks online;
Rollback segment altered.
11:08:55
tablespace
puglic rollback segment jks tablespace rbs;
Rollback segment created.
11:08:47 rsysdevdb.radisys.com - jkstill@dv01 SQL alter rollback segment
jks online;
Rollback segment altered.
11:08:55 rsysdevdb.radisys.com - jkstill@dv01 SQL c/on/off
1* alter rollback segment jks offline
11:08:58
rollback
segments:
a.. Private RBS can be brought online only via explicit ALTER
ROLLBACK SEGMENT xxx ONLINE command.
a.. The init.ora parameter ROLLBACK_SEGMENTS is only a list for
the automatic execution of ALTER ... ONLINE command at database
instance startup, so it is essentially
Additionally:
'create rollback segment...' defaults to 'private' and the only time when
I needlessly use a keyboard is to send a message like this
one
-Original Message-From: Tim Gorman
[mailto:[EMAIL PROTECTED]]Sent: Thursday, October 17, 2002 1:59
PMTo: Multiple recipients
No, that isn't it. :)
Sherman, Paul R. [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
10/17/2002 12:37 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: RE: [Q] Public and private rollback segment
Hi
My rollback tablespace is highly fragmented.I am thinking to do like
following?
-Create new rollback tablespace rbs1
-Create rollback segments
-Offline all rollback segments from old rollback tablespace (rbs)
-Drop rollback segments from rbs tablespace
-Drop tablespace rbs
-Create RBS
tablespace if you have
rollback segments where the initial and next extent sizes are not
multiples of each other and/or where each rollback segment has a
differently sized initial and next extents that are not multiples of
the extent sizes of the other rollback segments...
otherwise you
Why do you think it is fragmented?
Why do you think it is a problem?
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, October 07, 2002 10:36 AM
Hi
My rollback tablespace is highly fragmented.I am thinking to do like
following?
-Create
Hi gurus,
i have problem with 1 rollbadck seg, but this show active. I check the
transaction and this is not used for any process!!!
who make offline?? force??? and need free the space!!!
@lex
Lic. Alexander Ordóñez Arroyo
Have you checked if someone might be holding space in the rollback segment
you're getting the error for? We had a similar problem two weeks ago which
we resolved by killing the session that was holding the space (oddly, they
weren't holding any locks so I don't know why they were holding RBS
really worried why this
problem has been started all of a sudden.
The rollback segment statistics is showing high number of Waits and wrap.
For few rollback segments wait statistics it is exceeding even 100 which I
have never seen. and now because
Oracle 8.1.6.3 on Sun Solaris 2.6.
The rollback tablespace filled up last night and the rollback segments
became full. I added space to the tablespace and tried shrinking the
rollback segments. They remained full, so I altered them offline and
online. The extents are increasing, but I still
Terry,
Can you see if there are any session(s) (runaway or not) that might be
causing your rollback segments to fill up? Until you can figure out what
sessions are filling up the rollbacks you will be stuck adding more space
until those session(s) end.
Bryan
-Original Message-
Sent:
Terry,
What do you have optimal set to? I believe shrink only shrinks to the optimal size.
Jim
Ball, Terry [EMAIL PROTECTED] wrote:
Oracle 8.1.6.3 on Sun Solaris 2.6.
The rollback tablespace filled up last night and the rollback segments
became full. I added space to the tablespace and
The rollback segment will not shrink if there are active transactions in
the rollback segment i.e xacts 0 in v$rollstat for that rollback segment.
Check out which transaction is using the rollback segments using
v$transaction where XIDUSN = usn from v$rollname. The ses_addr in
v$transaction
Title: RE: Rollback segment shrinks
Terry,
This query will tell you which process is using which rollback segment, maybe
that'll help you backtrack to find out what's going on.
column Oracle UserName FORMAT a15
column RBS Name format a15
select r.name RBS Name, p.spid, l.sid ORACLE PID
) # of Records
from v$locked_object a
, dba_objects b
, dba_rollback_segs c
, v$transaction d
, v$session e
where a.object_id = b.object_id
and a.xidusn = c.segment_id
and a.xidusn = d.xidusn
and a.xidslot = d.xidslot
and d.addr = e.taddr
/
For shrink use
alter rollback segment rollback_segment_name shrink
Title: RE: Rollback segment shrinks
Terry,
This query will tell you which process is using which rollback segment, maybe
that'll help you backtrack to find out what's going on.
column Oracle UserName FORMAT a15
column RBS Name format a15
select r.name RBS Name, p.spid, l.sid ORACLE PID
Hi all,=0D
=0D
How to find out the smallest (minimal) transaction
size from Dictionary vie=
w or base tables =0D
I try to set my OPTIMAL rollback segment base on
smallest transaction size =
to prevent ora-1555. since shrinking rollback
segments may cause ora-1555.=
=0D
=0D
=0D
Thanks =0D
=0D
Dictionary vie=
w or base tables =0D
I try to set my OPTIMAL rollback segment base on
smallest transaction size =
to prevent ora-1555. since shrinking rollback
segments may cause ora-1555.=
=0D
=0D
=0D
Thanks =0D
=0D
Sinardy=0D
--=0D
Smallest ? Are you sure that you do not mean greatest ? Opinions
Hi all,=0D
=0D
How to find out the smallest (minimal) transaction
size from Dictionary vie=
w or base tables =0D
I try to set my OPTIMAL rollback segment base on
smallest transaction size =
to prevent ora-1555. since shrinking rollback
segments may cause ora-1555.=
=0D
=0D
=0D
Thanks =0D
=0D
Thanks man,=0D
=0D
I mean the minimum optimal size base on the maximum
transaction size, So th=
e HWM is the answer ?=0D
=0D
=0D
Sinardy=0D
=0D
Depends. If activity was 'normal', yes (if HWM is about the same for all RS, you can
be fairly confident with the value). If somebody has run a big
Hi Stephane,=0D
=0D
I run the script and I have =0D
=0D
OPTIMAL =3D 5 * ceil(max(v$rollstat.aveactive) / 4
/ sys.ts$.blocksize)* sy=
s.ts$.blocksize / 1024 =0D
=0D
the result is 0 K for my optimal. : )=0D
=0D
regards,=0D
Sinardy=0D
Probably not enough significant activity. It tries to set
I find that not setting OPTIMAL seems to be optimal.
Jared
Sinardy Xing [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
06/02/2002 09:53 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Rollback Segment
Hi all,
How to find out the smallest (minimal) transaction size from Dictionary view or base
tables
I try to set my OPTIMAL rollback segment base on smallest transaction size to prevent
ora-1555. since shrinking rollback segments may cause ora-1555.
Thanks
Sinardy
--
Please see
I figured you were, but I didn't want someone to mistakenly get the idea
that
it somehow made copying legal... :-). In fact, I'm not sure whats going to
happen at this point
RF
Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration
The Cigarette
I'm just joking with you...
-Original Message-
Sent: Thursday, March 28, 2002 4:25 PM
To: Multiple recipients of list ORACLE-L
Does this mean we can freely copy these books now??
Of course not!! :-(
Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database
Hi
I am looking lot of shrinkage in rollback segment.please suggest.
Thx
-Seema
_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Don't specify OPTIMAL parameter for rollback segment.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, March 28, 2002 1:38 PM
Hi
I am looking lot of shrinkage in rollback segment.please suggest
, March 28, 2002 12:38 PM
To: Multiple recipients of list ORACLE-L
Subject: ROLLBACK SEGMENT?
Hi
I am looking lot of shrinkage in rollback segment.please suggest.
Thx
-Seema
_
Get your FREE download of MSN Explorer
Anyone here write books for Coriolis? They are closing up
shop effective today. No more Exam Crams, black books, etc...
RF
Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration
The Cigarette Smoking Man: Anyone who can appease a man's conscience can
(+)
and ud.file# = sg.file#
and ud.block# = sg.block#
and sg.ts# = ts.ts#
/
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Thu, 28 Mar 2002 11:08:20 -0800
Don't specify OPTIMAL parameter for rollback segment.
Igor Neyman, OCP DBA
Thanks for the FYI.
Do you have any details as to why they are closing up shop? I thought there
Exam Cram and Black books were popular
Does this mean we can freely copy these books now??
-Original Message-
Sent: Thursday, March 28, 2002 3:08 PM
To: Multiple recipients of list
Does this mean we can freely copy these books now??
Of course not!! :-(
Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration
The Cigarette Smoking Man: Anyone who can appease a man's conscience can
take his freedom away from him.
-Original
2002 20:59
To: Multiple recipients of list ORACLE-L
Subject: RE: A rollback segment question on minextents
yes, Jonathan Lewis was kind enough to correct me privately on this.
It is indeed only the first block that's used for header information,
the rest of the block is used
-L
Subject: RE: A rollback segment question on minextents
the first extent is used by oracle as the segment header to manage the
transaction information within the rollback segment. The second extent
contains the actual change vectors
--- [EMAIL PROTECTED] wrote:
Hi,
My point
: RE: A rollback segment question on minextents
Oracle recommends the size NEXT=INITIAL.
So if I had 10M initial, then most of the initial beyond the
header info will be wasted? Sure not!
Kumanan
-Original Message-
From: Rachel Carmichael [SMTP:[EMAIL PROTECTED
Actually the rollback segment header in the first extent exists in a single
block, the rest of the first extent, as I understand it, is available for
undo. Thus making INITIAL and NEXT the same should be of no consequence in
this regard.
It is my understanding (and I'm sure I will be corrected
Thanks for the info Robert.
Personally, I usually have more urgent matters to deal with that preclude
worrying about a possible 10meg wasted in a rollback segment. ;)
Jared
Freeman, Robert [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
03/15/02 11:23 AM
Please respond to ORACLE-L
you aren't wrong :)
--- Freeman, Robert [EMAIL PROTECTED] wrote:
Actually the rollback segment header in the first extent exists in a
single
block, the rest of the first extent, as I understand it, is available
for
undo. Thus making INITIAL and NEXT the same should be of no
consequence
: 1029850.6.
It says the first block of the first segment contains header
information.
-Original Message-
From: Kumanan Balasundaram
Sent: 15 March 2002 17:59
To: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'
Subject:RE: A rollback segment question on minextents
Hi,
My point was that it could allocate one more extent as per need. Why the
need to minextents = 2?
Thanks
Kumanan
-Original Message-
From: Stephane Faroult [SMTP:[EMAIL PROTECTED]]
Sent: 07 March 2002 20:54
To: Multiple recipients of list ORACLE-L
Subject: Re: A rollback
the first extent is used by oracle as the segment header to manage the
transaction information within the rollback segment. The second extent
contains the actual change vectors
--- [EMAIL PROTECTED] wrote:
Hi,
My point was that it could allocate one more extent as per need. Why
the
need
Hi,
I was wondering why Oracle force minextents for rollback
segments to be two. Why can't we have minextents zero or
no minextents clause at all.
We can surely set initial extent to be large enough ourselves
and next extent sized accordingly.
Can someone enlighten me on the reason/thought
[EMAIL PROTECTED] wrote:
Hi,
I was wondering why Oracle force minextents for rollback
segments to be two. Why can't we have minextents zero or
no minextents clause at all.
We can surely set initial extent to be large enough ourselves
and next extent sized accordingly.
Can someone
To: Multiple recipients of list ORACLE-L
Subject: RE: Problem with Rollback segment getting locked
Check out Metalink Note ID: 1075644.6
If you DON'T specify the rollback_segments parameter in the
init.ora file...
Oracle calculates the number of [PUBLIC] rollback segments to
bring
segments, they must be specified in
the rollback_segments parameter to be brought online.
-Original Message-
From: Glenn Travis [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 25, 2002 10:18 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Problem with Rollback segment getting
HEAD
META HTTP-EQUIV=Content-Type CONTENT=text/html; charset=iso-8859-1
META NAME=Generator CONTENT=MS Exchange Server version 5.5.2653.12
TITLEProblem with Rollback segment getting locked/TITLE
/HEAD
BODY
PFONT SIZE=2 FACE=ArialHi All,/FONT
/P
PFONT SIZE=2 FACE=Arialnbsp;nbsp; I have about 12
1 - 100 of 236 matches
Mail list logo