| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: NonSystem RBS in SYSTEM tablespace?
Hi
About your question to Oracle Group :
Look, the "system" tablepspace is an delicate part of an Oracle Database
because there's the data dictionary on it, so if you put an non-system
rollback segment on it, the performance will going low, very low, and
you'll increase the posibilities to cause an disk file damage. Applications
cannot establish this kind of requirements, the only valid requirement it
could be the size of this rollback segment. So, create this segment in
another tablespace !
Hope this help you.
chrisoc_at_ans.net wrote:
> I'm going to install Remedy ARS with a supporting Oracle database.
> It's a help desk/trouble ticketing application.
>
> In the Remedy ARS docs, there is a sentence asking me to first
> "ensure that a nonsystem rollback segment has been created
> in the system tablespace and brought online. ... also add it
> to your init<SID>.ora file .."
>
> I really don't want to put RBS active segments in the SYSTEM
> tablespace. I like them in their own RBS tablespace.
>
> Has anyone bumped into a similar requirement ... maybe I am
> misreading the instruction. I don't think any application should
> care where the RBSes live, just that they work all right.
>
> In fact our database creation scripts do make an "r0" in SYSTEM
> but they take it off line as soon as 4 others are made, in RBS.
>
> Chris O'Connor
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
>
--
"Smell the Flower While you can"
 |
 |