Home » RDBMS Server » Performance Tuning » commit_write in 10g (Oracle 10g, AIX)
commit_write in 10g [message #584698] Thu, 16 May 2013 17:58 Go to next message
TRaj
Messages: 82
Registered: September 2006
Member

Hi,

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

Thanks.
Re: commit_write in 10g [message #584699 is a reply to message #584698] Thu, 16 May 2013 18:05 Go to previous messageGo to next message
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."
Re: commit_write in 10g [message #584700 is a reply to message #584699] Thu, 16 May 2013 18:25 Go to previous messageGo to next message
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.
Re: commit_write in 10g [message #584706 is a reply to message #584698] Fri, 17 May 2013 00:51 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It is not possible (hopefully).

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


Current Time: Thu Mar 28 12:17:34 CDT 2024