OraFAQ Forum: Performance Tuning » Logwriter processes

Home » RDBMS Server » Performance Tuning » Logwriter processes (Hp Unix,11.3)

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

Logwriter processes [message #463615]

Fri, 02 July 2010 04:03

sekar52
Messages: 141
Registered: May 2010
Location: Mumbai

Senior Member

I want to if its possible to have multiple LGWR processes for a single database.If its possible how does the multiple processes write from redo log buffer to online redo log file.

Report message to a moderator

Re: Logwriter processes [message #463618 is a reply to message #463615]

Fri, 02 July 2010 04:15

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

Senior Member
Account Moderator

Yes and no.
You can have several log writers for a single database but only one per instance.

Regards
Michel

[Updated on: Fri, 02 July 2010 04:16]

Report message to a moderator

Re: Logwriter processes [message #463620 is a reply to message #463618]

Fri, 02 July 2010 04:25

sekar52
Messages: 141
Registered: May 2010
Location: Mumbai

Senior Member

Suppose the logwriter process is very slow to write data to redo log files any way to solve this?

Report message to a moderator

Re: Logwriter processes [message #463622 is a reply to message #463620]

Fri, 02 July 2010 04:32

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

Senior Member
Account Moderator

Buy faster disks or reserved some disk for it alone.
The problem is not in LGWR which has few works to do, it is almost all the time in underlying io subsystem.

Regards
Michel

Report message to a moderator

Previous Topic:	parition of table
Next Topic:	need to know about shared pool sizing

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 06:58:11 CST 2024