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.

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.


Received on Thu Jan 24 2013 - 05:57:37 CET

Original text of this message