R12 EBS - SYSTEM TABLESPACE is Dict Managed and Increase in size to 20GB..
From: Sheldon Quinny <sheldonquinny_at_gmail.com>
Date: Thu, 24 Jan 2013 07:57:37 +0300
Message-ID: <CAPfA+9N-WO4uTCisjQ+CugmRad-O39rrtMZTxqw15_W_qY4DHQ_at_mail.gmail.com>
Hi all,
I have a client take over and was going thru thier R12EBS systems.
Date: Thu, 24 Jan 2013 07:57:37 +0300
Message-ID: <CAPfA+9N-WO4uTCisjQ+CugmRad-O39rrtMZTxqw15_W_qY4DHQ_at_mail.gmail.com>
Hi all,
I have a client take over and was going thru thier R12EBS systems.
What I notice is that the system table space is Dictionary Manged has been increasing to a size of 20 Gb with more then merry data files added to it.
I just wanted to know , what would be your advice/ suggestions as to how to handle this situation.
The R12 EBS has been a fresh install past last year and it not any upgrade or so.
So I wanted to know if this is normal to have the system tablespace in to dict managed, which I find it weird as to how did they manage to get this into dict managed in the first place.
Please let me know , what should I be looking at before taking this handover.
Thanks
Sheldon.
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Jan 24 2013 - 05:57:37 CET