Re: 10g R2 running e-Business Suite R12

From: <>
Date: Fri, 5 Dec 2008 07:19:18 -0800 (PST)
Message-ID: <>

On Dec 4, 9:34 pm, Greg <> wrote:
> Hello,
> We have a 10g R2 RAC db which houses our e-Business Suite R12.
> We have a tablespace which seems to be growing at an alarming rate.
> Considering how many transactional users I have.
> Does anyone know what kinds of data are being stored in the
> APPS_TS_TX_DATA tablespace?
> Thanks
> Greg

According to the doc in the Oracle Applications Tablespace Model that particular tablespace houses "Transaction Tables (tables that contain transactional data)". In addition, ALL Oracle Applications product schemas use that tablespace as their default tablespace. The FND_ENV_CONTEXT table seems to grow fast in our environment. I truncate it periodically since it doesn't appear to contain anything worth using/saving.


    Eugene Pokopac (ORACLE DBA - GSFC - Tucker, GA) Received on Fri Dec 05 2008 - 09:19:18 CST

Original text of this message