OraFAQ Forum: Performance Tuning » commit

Home » RDBMS Server » Performance Tuning » commit_write in 10g (Oracle 10g, AIX)

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

commit_write in 10g [message #584698]

Thu, 16 May 2013 17:58

TRaj
Messages: 82
Registered: September 2006

Member

Hi,

How to set commit_write parameter to 'BATCH' in another session.

Thanks.

Report message to a moderator

Re: commit_write in 10g [message #584699 is a reply to message #584698]

Thu, 16 May 2013 18:05

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

When all else fails, Read The Fine Manual

http://docs.oracle.com/cd/E11882_01/server.112/e25513/initparams034.htm#REFRN10260

"The COMMIT_WRITE parameter is deprecated. It is retained for backward compatibility only. It is replaced by the COMMIT_LOGGING and COMMIT_WAIT parameters."

Report message to a moderator

Re: commit_write in 10g [message #584700 is a reply to message #584699]

Thu, 16 May 2013 18:25

TRaj
Messages: 82
Registered: September 2006

Member

Hi Blackswan,

we are using 10g and it's been deprecated in 11g.

I was asking whether it's possible to set in other session(s) like how we do for sql trace in another session using dbms_system.

Thanks.

Report message to a moderator

Re: commit_write in 10g [message #584706 is a reply to message #584698]

Fri, 17 May 2013 00:51

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

It is not possible (hopefully).

Regards
Michel

Report message to a moderator

Previous Topic:	db cache advice 10g
Next Topic:	enable row movement - ok, but why internally this thing is needed

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 21 16:08:54 CST 2024