OraFAQ Forum: Server Administration » High number of commits per day --> Big data files

Home » RDBMS Server » Server Administration » High number of commits per day --> Big data files

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

High number of commits per day --> Big data files [message #62336]

Thu, 15 July 2004 02:45

Joan Padilla i Salom
Messages: 5
Registered: January 2002

Junior Member

Hi,

I've a problem with our database server, we've a DELL server with 1 GHz dual procesor and 2 GB of RAM.

The problem is that we've big data files per day "30 -- 50 GB". Herewith an example of our activity:

day��num. min of commits/h��num. max of commits/h Average/h

7/7�� 111.98��3345.7�� 2074.20

7/8��150.35��3195.44�� 2062.24

7/9�� 53.53��3272.46��2009.80��

The question is, Could we somehow reduce our number of commir per day?, we have a Intranet with a 3-Tiers architecture and some Access applications. Our Intranet makes a lot a commits because is a transactional system that use DCOM components with ADO.

�

Thanks a lot in advance

Report message to a moderator

Previous Topic:	Record unique id for "select * from v$logmnr_contents"
Next Topic:	New Temp tablespace

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Apr 28 11:36:55 CDT 2025