Welcome to dbFreaks.com!
FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

10g R2 running e-Business Suite R12

  
   Database Help (Home) -> Oracle -> Server RSS
Next:  What can cause SQL 2000 to stop responding for a ..  
Author Message
Greg

External


Since: Dec 01, 2008
Posts: 2



(Msg. 1) Posted: Thu Dec 04, 2008 6:34 pm
Post subject: 10g R2 running e-Business Suite R12
Archived from groups: comp>databases>oracle>server (more info?)
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

 >> Stay informed about: 10g R2 running e-Business Suite R12 
Back to top
Login to vote
empete2000

External


Since: Jan 19, 2005
Posts: 14



(Msg. 2) Posted: Fri Dec 05, 2008 5:25 am
Post subject: Re: 10g R2 running e-Business Suite R12 [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
On Dec 4, 8:34 pm, Greg <Greg.Ho....DeleteThis@gmail.com> 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

Why not query dba_segments and determine the object names and types
contained in the tablespace?

Pete's

 >> Stay informed about: 10g R2 running e-Business Suite R12 
Back to top
Login to vote
epokopac

External


Since: Feb 08, 2008
Posts: 6



(Msg. 3) Posted: Fri Dec 05, 2008 7:19 am
Post subject: Re: 10g R2 running e-Business Suite R12 [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
On Dec 4, 9:34 pm, Greg <Greg.Ho....RemoveThis@gmail.com> 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.

Regards,

Eugene Pokopac (ORACLE DBA - GSFC - Tucker, GA)
 >> Stay informed about: 10g R2 running e-Business Suite R12 
Back to top
Login to vote
Display posts from previous:   
   Database Help (Home) -> Oracle -> Server All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]