| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: convert RBS tablespace from DMT to LMT (Oracle 8173) steps?
This is a multi-part message in MIME format.
--------------0CDA15A5DD9A9EA332E63329 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit
Oracle will not let you drop a rollback segment if there are active transactions using it. However, it will allow you to offline the segment and no new transactions can use it. I don't recall the exact status in v$rollstat, but I think it may say pending offline.
As for the commit across cursors, the minute you commit, your transaction has ended, even if the cursor is still open. When you issue the next statement, you start a new transaction, which should assign you to a new rbs. The one you were using is still offline. Of course, if you online/assign/offline the rbs after each commit, you are reusing the rbs. I have not tested this, so I may be wrong (Thoughts, Kirti?). However, you may step on your own "free segment." Additionally, during the time period of the online/assign/offline, there is a chance that another transaction will be assigned to the rbs.
Daniel
Thomas Day wrote:
>
> How will you make sure that there are no active segments in your current
> rollback segments before you remove the datafiles with the OS? Even after
> you take the rollback segments off-line, Oracle will continue to use them
> as long as they have an active segment.
>
> BTW --- One way to help to avoid the ORA-01555 when you are committing
> across an open cursor is to take the rollback segment that that cursor is
> using off-line. No one else will come in a step on the "free" segment but
> your session will continue to process just fine until you close the cursor.
> At least that's been my experience.
--------------0CDA15A5DD9A9EA332E63329
Content-Type: text/x-vcard; charset=us-ascii;
name="daniel.fink.vcf"
Content-Transfer-Encoding: 7bit Content-Description: Card for Daniel Fink Content-Disposition: attachment;
begin:vcard
n:Fink;Daniel
tel;cell:303.808.3282
tel;work:303.272.3225
x-mozilla-html:TRUE
adr:;;;;;;
version:2.1
email;internet:daniel.fink_at_sun.com
title:DB Services Lead
x-mozilla-cpt:;-4832
fn:Daniel Fink
end:vcard
--------------0CDA15A5DD9A9EA332E63329-- Received on Wed Jul 23 2003 - 13:28:59 CDT
 |
 |