Re: R12 EBS - SYSTEM TABLESPACE is Dict Managed and Increase in size to 20GB..

From: Sheldon Q <sheldonquinny_at_gmail.com>
Date: Thu, 24 Jan 2013 09:47:11 +0000
Message-ID: 50489072-1359020848-cardhu_decombobulator_blackberry.rim.net-1024903373-_at_b26.c18.bise7.blackberry>

Hi Philip,
Thanks for the info.
But as ur experience does this look normal to you or the system is been goofedup. And would be more of a headache in the future.

------Original Message------
From: Philip Jones
To: sheldonquinny_at_gmail.com
Cc: Oracle-L Freelists
Subject: Re: R12 EBS - SYSTEM TABLESPACE is Dict Managed and Increase in size to 20GB.. Sent: 24 Jan 2013 12:43

Hi,

I'd start by querying DBA_EXTENTS to find out what's taking up so much space in the tablespace.

Thanks,

Phil

On 24 Jan 2013, at 04:57, Sheldon Quinny <sheldonquinny_at_gmail.com> wrote:

> 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.
>
>
>

Sent via BlackBerry® from Batelco--
http://www.freelists.org/webpage/oracle-l Received on Thu Jan 24 2013 - 10:47:11 CET