Database Administration (MOSC)

MOSC Banner

lgwr blocking other sessions waiting for log file sync

edited Apr 30, 2010 4:29AM in Database Administration (MOSC) 4 commentsAnswered
For  lgwr blocking other sessions waiting for log file sync
Seeking for an advise on implementing :

alter system set "_high_priority_processes"='LMS*|LGWR|PMON' scope=spfile;

Is there any drawback for that ? Is it advisable to do it even when CPU priority is not confirmed as the real issue ?

Thanks,
Dina

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center