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
1)rollback segment will
not shrink.
Correct, assuming you do not shrink it manually.
2)It will keep growing till
tablespace fills up.
Correct assuming that you have a SQL statement that causes the rollback
segment to grow in such a way and that you have no constraints on the rollback
1.) Correct, except that the DBA can always shrink it manually.
2.) Well, that's true, but a rollback segment w/ optimal set could
conceivably grow to fill the tablespace as well. It depends on the size
of the rollback tablespace and the size(s) of your transaction(s). The
reason that it's
Hi,
A simple rollback segment question. If I do not set a optimal thencan I assume following
1)rollback segment will not shrink.
2)It will keep growing till tablespace fills up.
3)And there will be no 'snapshot too old' errors?
ThanksA Joshi [EMAIL PROTECTED] wrote:
Hi,
One rollback
The datafile for our rollback segments gre huge because of an improper
setting. Even setting optimal and shrink, etc., won't help because the
segments are scattered. Do I have to create a new tablespace? Can I change
the datafile a rollback segment writes to and then take the other offline
datafiles appropriately. Don't go to small or you run
the risk of transactions failing due to unable to extend errors.
Daniel Fink
Michael Milligan wrote:
The datafile for our rollback segments gre huge because of an improper
setting. Even setting optimal and shrink, etc., won't help because
Daniel,
Thank-you very much for your clear answer. Very helpful. When a RBS is taken
off-line, does it transfer the rollback information to another segment?
Thanks,
Mike
-Original Message-
Sent: Monday, December 22, 2003 1:44 PM
To: Multiple recipients of list ORACLE-L
Mike,
When an RBS is taken offline, the undo information is not transfered to another
segment, hence the need to perform these actions at a quiet time. When an rbs
is taken offline, all transactions currently using the rbs are allowed to
complete (either commit or rollback). As these transactions
to
another
segment, hence the need to perform these actions at a quiet time. When an
rbs
is taken offline, all transactions currently using the rbs are allowed to
complete (either commit or rollback). As these transactions are processing,
the
status of the segment is 'Pending Offline'. Once the tx
Hi all
I am getting ORA-01555 in my database and the solution is to create
huge rollback segments but my doubt is how to calculate the size of this
huge rollback segments . Now I have 24 G of space in rollback segment
tablespace .But still i am getting the error.The
A single block can only be 'owned' by one transaction
at a time, but when a transaction commits, it may put
its last undo block into that segment's 'free pool' list if there
is a lot of free space left in the block so that it can be made
available for new transactions . (Gaja Vaidyanatha quoted
Yes Jonathan:
I think that 400 byte concept came from one of the TPC benchmarks during
Oracle 7 (or ORacle 6) days where the average undo size for a transcation
was around 380+ bytes. So they had rounded that to 400 bytes and a maximum
of 5 blocks will be linked to the freelist in the undo
IIRC, a segment will not wrap into an extent that has an active transaction
in it, but rather allocate a new extent. So the answer is...it depends.
Daniel Fink
A Joshi wrote:
Hi,
One rollback segment can be used by multiple transactions/processes
but what about the extents? Is it safe
: ** can two processes use the
same rollback extent
[EMAIL PROTECTED]
ity.com
Hi,
One rollback segment can be used by multiple transactions/processes but what about the extents? Is it safe to assume that only one transaction/process can use one extent? What is a good way to size the extent for warehousing tasks? Or guess the rollback generated and size needed.
Thank You
of list ORACLE-L
Sent: Wednesday, December 03, 2003 9:09
AM
Subject: ** can two processes use the
same rollback extent
Hi,
One rollback segment can be used by multiple
transactions/processes but what about the extents? Is it safe to assume that
only one
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
to reduce the chance of
a 1555.
Daniel Fink
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
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
throughout the tablespace, preventing
me from resizing the datafile.
Thanks,
Mike
-Original Message-
Sent: Monday, November 17, 2003 2:44 PM
To: Multiple recipients of list ORACLE-L
Michael Milligan wrote:
I have a client where rollback segments were set up RBS01-RBS05, all in a
tablespace
of
a 1555.
Daniel Fink
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
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
PROTECTED]
cc:
Subject:no rollback ??
There is one log running process in db here and I waiting for it to finish since last 3 hours. when I see sql_address in v$session for this session and then find sql in v$sqlarea its a update statement . But then there is no entry in v$transaction
Maybe your rollback is done in background, because
a session crashed orwas killed?
Tanel.
- Original Message -
From:
AK
To: Multiple recipients of list ORACLE-L
Sent: Tuesday, August 26, 2003 1:49
AM
Subject: no rollback ??
There is one log running process
disabled parallel rollback
(fast_start_parallel_rollback parameter IIRC).
Tanel.
- Original Message -
From:
AK
To: Multiple recipients of list ORACLE-L
Sent: Tuesday, August 26, 2003 1:49
AM
Subject: no rollback ??
There is one log running process in db here and I
There is one log running process in db here and I
waiting for it to finish since last 3 hours. when I see sql_address in v$session
for this session and then find sql in v$sqlarea its a update statement . But
then there is no entry in v$transaction . How'z it possible that there no
rollback
I use manual managed undo tablespace but there are some system named rollback
segments on that
tablespace ( I did not created them ) and they can not be dropped.
What are they , how can I drop them.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: [EMAIL
where a.usn = b.usn;
--- [EMAIL PROTECTED] wrote:
I use manual managed undo tablespace but there are some system named rollback
segments on that
tablespace ( I did not created them ) and they can not be dropped.
What are they , how can I drop them.
--
Please see the official ORACLE-L
The scenario you describe is not consistent with manual undo. Was the database
created/started with automatic undo and you have switched to manual?
[EMAIL PROTECTED] wrote:
I use manual managed undo tablespace but there are some system named rollback
segments on that
tablespace ( I did
segment_name, tablespace_name from dba_rollback_segs;
SQL select a.usn, a.name, b.status
2 from v$rollname a,
3 v$rollstat b
4 where a.usn = b.usn;
--- [EMAIL PROTECTED] wrote:
I use manual managed undo tablespace but there are some system named rollback
segments
PROTECTED] wrote:
I use manual managed undo tablespace but there are some system named rollback
segments on that
tablespace ( I did not created them ) and they can not be dropped.
What are they , how can I drop them.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author
If you are now running in manual undo mode and have created rollback segments, you can
remove the undo segments. Verify that the segments are offline and you are not using
them. Then drop the undo tablespace. This is the only way to get rid of them.
[EMAIL PROTECTED] wrote:
yes . What should
were created in an undo tablespace titled RBS.
To remove system managed undo segments (_SYSSMUn$) one must drop the undo tablespace
itself.
But, in your case, you will first have to:
1. Create a new, normal tablespace, say, rollback_ts, to hold new rollback segments
(do not create
it using
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
Can anyone point me to an article or white paper that goes into detail on
this. When I RTFM, it just says use Undo TBS, don't worrry about it and all
your problems will be solved.
We are upgrading from Oracle8 to 9i and currently have Rollback segments in
4 tablespaces spread over 4 disks
Which database version are you using? as long as I know, at
least on Oracle 8.0.6 you can not specify which rollback segment a particular
transaction should use. We disable all rollback segments and only enable those
which we know won't make big updates / deletes crash.
-Mensaje
set
transaction use rollback segment only works if it's the first statement in
your transaction, an easy way to make sure this is the case is to issue a commit
directly before issuing this statement.
I
believe this has been a feature of Oracle since way back in version 7 (Correct
me
Yes you are right, sorry but I made a mistake, since we are
using Baan IVc4 which works against Oracle we have no means to interfere with
its transactions when they are commited to Oracle and we can not modify them so
that it uses a specific rollback segment, so the only way for us to do
I
think that's probably the case with most third party applications, if developers
haven't coded their apps to use a large rollback segment for certain
transactions (which I find is the case with most developers ;-) ) then the only
option is to turn off all but the large rollback seg
party applications, if
developers haven't coded their apps to use a large rollback segment for
certain transactions (which I find is the case with most developers ;-) )
then the only option is to turn off all but the large rollback seg.
Cheers
Lee
-Original Message-
Sent: 16 July 2003 11:19
Hi Friends,
I have 150Gb database with 30 rollback segs with optimal settings!! for normal operations no problems!! But we are doing massive updates for some ofbig tables!! So we are using vb programs and connecting to the database thru odbc dsn. My first question is how to set transaction use
Ave !
Is there any reason not to
keep maxextents always unlimited :) Extentsize should
be reasonable of
course.
Br.
Jorma
-Original Message-From: ext venkat Rama
[mailto:[EMAIL PROTECTED]Sent: 16 July, 2003 07:34To:
Multiple recipients of list ORACLE-LSubject: Rollback
Segs
Hi
can anyone please help?
errors like below when any of the redo or rollback raw LVs are created using stripe:
CREATE TABLESPACE RBS DATAFILE '/dev/vgrbs/rrbs01.dbf' SIZE 8000M REUSE AUTOEXTEND OFF
MINIMUM EXTENT 512K DEFAULT STORAGE ( INITIAL 512K NEXT 512K MINEXTENTS 8 MAXEXTENTS
UNLIMITED
blocks will not be reused as often. This could
cause space management problems if there is not enough space in the tablespace or
other processes are causing rollback segments to shrink.
The short version is that frequent commits = additional housekeeping (impact
can't be known exactly until
related to rollback.
I said I was not aware of this and would look into it but I had never heard
of this before and couldn't find any information on this so of course I'm
sending mail to the list. Both items sound bogus to me. I've really never
heard where committing more frequently on a load would
From the docs : Many active transactions can write concurrently to a single
rollback segment--even the same extent of a rollback segment; however, each
data block in a rollback segment's extent can contain information for only
a single transaction.
1) Now, when oracle writes to the last extent
Rajesh:
I am not sure which document you are referring here. If that documentation
says more than one transaction can not use a rollback segment data block
means, I would say the documentation is incorrect in this case. But this
can not happen concurrently. IT can happen serially.
Each rollback
Thanks KG, for your reply. Well, it whets my appetite for more.
This surprises me. All the documentation I have read so far tells me that
multiple transactions cannot be write to the same rollback segment data
block.
My first question was basically well, if many transactions can write
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
to
this was an RMAN backup and DBMS_STATS.GATHER_TABLE_STATS(...) which was being run on
the same schema being backed up via the user level export. There was no other end user
access to the schema data. Since exp got the error I assume it was reading from the
rollback segments but why? I'm
HELP...
Has anyone encountered rollback problems while running dbms_stats?
-Original Message-
Sent: Thursday, May 29, 2003 10:15 AM
To: Multiple recipients of list ORACLE-L
Oh yeah, for the export consistent=N
-Original Message-
Sent: Thursday, May 29, 2003 9:14 AM
To: '[EMAIL
backup and
DBMS_STATS.GATHER_TABLE_STATS(...) which was being run on the same
schema being backed up via the user level export. There was no other end
user access to the schema data. Since exp got the error I assume it was
reading from the rollback segments but why? I'm suspecting dbms_stats.
We
Steve,
You may have to dig a little further...
What happened to those table(s) in that schema prior to starting the export? Heavy
DML, may be?
This could be a case of 'delayed block cleanout'. Export triggered the cleanout and
wanted to
access the rollback segments.
If no table data
be?
This could be a case of 'delayed block cleanout'. Export triggered the cleanout and
wanted to
access the rollback segments.
If no table data was modified after export started reading that table, then there is
no need to
read RBS info (except for the DBC case, IMO).
- Kirti
--- Orr, Steve [EMAIL
to
this was an RMAN backup and DBMS_STATS.GATHER_TABLE_STATS(...) which was being run on
the same schema being backed up via the user level export. There was no other end user
access to the schema data. Since exp got the error I assume it was reading from the
rollback segments but why? I'm suspecting
alter rollback segment XXX storage (optimal null);
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
The educated person is not the person
who can answer the questions, but the
person who can question the answers -- T. Schick Jr
One-day tutorials:
http://www.jlcomp.demon.co.uk
Hey all,
Fighting with a lot of ORA-1555s lately on 8.1.7.4 on HP/UX. Most of them
are now coming from long-running Business Objects (B.O.) queries against our
OLTP DB. I think I need to recreate the RBS tablespace (currently 1MB
extents in LMT), but until I can get time to do that, I'd like to
Jesse, Rich wrote:
Hey all,
Fighting with a lot of ORA-1555s lately on 8.1.7.4 on HP/UX. Most of them
are now coming from long-running Business Objects (B.O.) queries against our
OLTP DB. I think I need to recreate the RBS tablespace (currently 1MB
extents in LMT), but until I can get
. Create a new rollback tablespace. You can do this quickly. Ask the
report users to hold off running reports for a few minutes, then offline the
current rollback tablespace. It won't go off until all current transactions
complete.
3. Modify the application. In my experience, actions #1 and #2
Rich,
The overcommiting is a definite suspect and is worth
looking into. ALso, do you by chance have OPTIMAL set
on your rollback segments? If so, I'd suggest you
remove the OPTIMAL clause and try again. In my
experience, I have had my share of hassles with
OPTIMAL. Even when it was sized
In general, you don't need to do this in
recent versions of Oracle. Oracle knows
that all the data in the tablespace MUST
have been committed before the tablespace
was switched to read-only (you can only
switch a tablspace to readonly when there
are no active transactions that started before
-Original Message-
Sent: Friday, April 04, 2003 12:54 PM
To: Multiple recipients of list ORACLE-L
Rich,
The overcommiting is a definite suspect and is worth
looking into. ALso, do you by chance have OPTIMAL set
on your rollback segments? If so, I'd suggest you
remove the OPTIMAL clause
Yes, your assumption is right. Create new rollback
segments without the OPTIMAL clause, bring them
online, take the old ones offline, blow the old ones
away, document the new ones in your init.ora, remove
the old ones from your init.ora. See whether this
solves your problem. My guess is that you
-ONLY.
Due to whatever reason (I could not gather whether
there (were/were not) any long-running queries), the
clean out did not occur on some of the objects, and
this caused the ORA-1555, as his current query was
trying to build a read-consistent image from the
rollback segment and could not find
Sometimes the extents should be larger (fewer larger extents, then many
small extents).
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Saturday, April 05, 2003 1:30 AM
Yes, your assumption is right. Create new rollback
segments without
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
.
-Original Message-
Sent: Monday, March 10, 2003 5:39 PM
To: Multiple recipients of list ORACLE-L
Did any of the rollback segment storage parameters (i.e. INITIAL, NEXT,
PCTINCREASE, MINEXTENTS, MAXEXTENTS, OPTIMAL) or the number of rollback
segments change between 8.0.5 and 8.1.7? Changes
years since I tested an 8.0.x db, but I do
not recall seeing any changes in rollback segments from 7.3 to 8.1.
Have you converted from Dictionary to Locally managed RBS
tablespaces? When you upgraded, did you change any of the settings, like
OPTIMAL, for the rollback segments? Were
Evening;
Has anyone noticed any difference on the way Oracle uses Rollback Segments
on 8.1.7.4 versus 8.0.5 ??
Ever since upgrading to 8.1.7.4 from 8.0.5 on our Solaris servers we have
noticed more SNAPSHOT TOO OLD errors than we used to.
Are there any suggestions as to rollback tuning
Kevin,
The ORA-01555 errors are almost certainly symptoms, not the actual
problem. It has been a few years since I tested an 8.0.x db, but I do
not recall seeing any changes in rollback segments from 7.3 to 8.1.
Have you converted from Dictionary to Locally managed RBS
tablespaces? When
Did any of the rollback segment storage parameters (i.e. INITIAL, NEXT,
PCTINCREASE, MINEXTENTS, MAXEXTENTS, OPTIMAL) or the number of rollback
segments change between 8.0.5 and 8.1.7? Changes to any of these variables
could impact the space available for storing inactive undo blocks for
read
Hi to all,
Thanks for the comments, but none of them worked for me,
I tried putting a comment in the init.ora file to the rollback segments line
to recreate the controlfile. No success.
I did get a message telling me that there was a 'MISSING000' datafile in
$ORACLE_HOME/dbs, and tried to do
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
David
This query will show sessions using rollback segments:
select s.username, s.sid, rn.name, rs.extents
,rs.status, t.used_ublk, t.used_urec
,do.object_name
fromv$transaction t
,v$session s
,v
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"
Shuan - If you go to
http://www.google.com/search?hl=en
http://www.google.com/search?hl=enie=ISO-8859-1q=max_rollback_segments
ie=ISO-8859-1q=max_rollback_segments
you can find a lot of information on this parameter. Oracle needs to
allocate a finite amount of memory to manage rollback segments
=max_rollback_segments
ie=ISO-8859-1q=max_rollback_segments
you can find a lot of information on this parameter. Oracle needs to
allocate a finite amount of memory to manage rollback segments, so there
must be a upper boundary somewhere. Unfortunately, you've hit it and must
bounce your instance to change
is mixed up.
I can mount the database, but can't open it because rollback datafiles (and
filesystem) where lost in the crash. Had to rebuild the filesystem, but I'm
not able to rebuild the controlfile due to datafiles errors on the rollback
tablespaces.
I tried, with no success, to rebuild
where lost, and
control file is mixed up. I can mount the database, but
can't open it because rollback datafiles (and filesystem)
where lost in the crash. Had to rebuild the filesystem,
but I'm not able to rebuild the controlfile due to
datafiles errors on the rollback tablespaces.
I tried
where lost, and control file is mixed up.
I can mount the database, but can't open it because rollback datafiles (and
filesystem) where lost in the crash. Had to rebuild the filesystem, but I'm
not able to rebuild the controlfile due to datafiles errors on the rollback
tablespaces.
I tried
want the database looking for them.
3) Startup mount the database.
4) alter database datafile fill_in_the_file_name offline drop;
5) repeat 4 as mant times as necessary;
6) alter database open;
7) create rollback segment sys1 tablespace system;
8) alter rollback segment sys1
1 - 100 of 607 matches
Mail list logo