Re: Oracle Applications 11i System Tablespace
Date: Thu, 13 Mar 2008 07:07:15 -0500
We run 220.127.116.11 with 10.1.0.5 with a locally managed system tablespace. If I recall correctly there was a step to convert in the transition from 11.5.7to 18.104.22.168. We don't seem to have the performance issues or the log file sync problems. Is the conversion to the locally managed tablespace the only change that was made? Have you traced any of the processes?
On Wed, Mar 12, 2008 at 1:21 PM, Haroon A. Qureshi < haroon_a_qureshi_at_yahoo.com> wrote:
> Oracle has always stated, to my knowledge, that for an Oracle Applications
> instance, the system tablespace needs to be dictionary managed while the
> non-system tablespaces can be locally managed. i just assumed it was
> because of how some of the modules intereacted with the system tablespace,
> and didn't put much thought into it.
> this week one of the DBAs here had converted the system tablespace to
> locally managed in our development instances. since then, we have had
> perfomance issues and have been seeing a lot of "log file sync" waits
> during some of the conversion processes.
> the question is, why does the system tablespace need to be dictionary
> managed for an 11i instance? and in turn, what issues would we see by
> converting to locally managed for the system tablespace and why? i opened
> an SR with support asking these questions but they have no explicit
> answer. just that it needs to be.
> does anyone have any thoughts on this? we are running 22.214.171.124 on a
> 10.2.0.2 database with an ASM filesystem.
> thanks in advance