Home » RDBMS Server » Server Administration » redo log contetnion & disk sort
redo log contetnion & disk sort [message #61950] Sat, 12 June 2004 13:15 Go to next message
rajitha
Messages: 19
Registered: July 2002
Junior Member
how to reduce redo log contention and disk sort
i increased the log_buffer for redo log contetnion but the contention still there
how to eliminate both redo log contention and disk sort.

Report message to a moderator

Re: redo log contetnion & disk sort [message #61957 is a reply to message #61950] Mon, 14 June 2004 03:02 Go to previous message
Sanjay
Messages: 236
Registered: July 2000
Senior Member
Have u tried by increasing db_block_buffers, sometimes by increasing shared pool size also works.

Report message to a moderator

Previous Topic: problem with dbms_job executing
Next Topic: Database Administration
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 14:19:03 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.