Home » RDBMS Server » Server Administration » dbwr
dbwr [message #403911] Tue, 19 May 2009 09:12 Go to next message
IT Guru
Messages: 59
Registered: January 2007
Member
1) what is formula between no of cup , no cpu group & dbwr
if i have 2XE CPU how many dbwr process I can configure.

2) if DBWR = 4
& if i give parallel 8 in select or insert query will it of any help



3) & if more than 1 dbwr is configure , i can not configure io salve. Right ?
Re: dbwr [message #403914 is a reply to message #403911] Tue, 19 May 2009 09:20 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
IT Guru wrote on Tue, 19 May 2009 07:12
1) what is formula between no of cup , no cpu group & dbwr
if i have 2XE CPU how many dbwr process I can configure.

2) if DBWR = 4
& if i give parallel 8 in select or insert query will it of any help



3) & if more than 1 dbwr is configure , i can not configure io salve. Right ?


42
Re: dbwr [message #403932 is a reply to message #403911] Tue, 19 May 2009 10:21 Go to previous message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You are completly wrong.
Please read Database Concepts and Peformances and Tuning Guide.

Regards
Michel
Previous Topic: ORA-24324: service handle not initialized ORA-01041: internal error. hostdef extension doesn't exist
Next Topic: Datafile Deleted But not getting any error
Goto Forum:
  


Current Time: Thu Dec 08 12:26:14 CST 2016

Total time taken to generate the page: 0.21312 seconds