Re: Seemingly simple question
- From: rjamya <rjamya@xxxxxxxxx>
- To: racdba@xxxxxxxxxxxxx
- Date: Tue, 2 Aug 2005 15:12:57 -0400
Okay couple of updates, ran into the dba he told me that thay use OCI
drivers and also fixed the problem by chanding MCPD to 99.
All I coulds ay was "huh ?"
Raj
On 7/28/05, rjamya <rjamya@xxxxxxxxx> wrote:
>
> mcpd is default of 700. User action initiates a insert followed by select
> and commit happens after insert. This action is user initiated so commit
> frequency is varied. The only thing a bit odd is "db_cache_size is set to
> 2147483648, block size is 8k". But since the consulting company installed
> the db (by an expert) we can't really touch it.
>
> I'll check on thick/thin drivers and report back. This is all on aix 5.2,
> 9205, middletier is sun boxes running jboss (I think)
>
> Cheers
> Raj
>
> On 7/28/05, Anand Rao <panandrao@xxxxxxxxx> wrote:
> >
> > What is the value used for max_commit_propogation_delay? when and how
> > are you commiting? what is the Commit frequency?
> >
> > Java uses some funny transaction mechanisms which can be misleading.
> > simply put, you don't know what the heck it does. Do you use JDBC Thin
> > or Thick drivers?
> >
> > OTN has quite a few whitepapers on Java App development techniques and
> > some are also applicable to RAC and also on usage of JDBC drivers. I
> > think, if it is Apache, you will have to use Thin drivers...but my
> > knowledge of Java isn't any good...so, you need to do a good check.
> >
> > can you mention the platform and version where RAC database is
> > installed?
> >
> >
--
------------------------------
select standard_disclaimer from company_requirements where category =
'MANDATORY';
Other related posts: