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 ?

Report message to a moderator

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: 26766
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

Report message to a moderator

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

Regards
Michel

Report message to a moderator

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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Feb 27 11:12:02 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.