RE: Alter system switch logfile hang

Probably a bit late, but ...  

Make sure that the archiver is actually running - and you have enough disk space to archive into !  

Dougie  

-----Original Message-----
From: DBA Deepak [mailto:oracle.tutorials_at_gmail.com] Sent: Tuesday, November 08, 2005 6:34 PM To: oracle-l_at_freelists.org
Subject: Alter system switch logfile hang

Hi All,  

The alter system switch logfile hangs in my database.  

> The archive destination is valid and having all the necessary permissions.
> v$session_wait has long waits on "switch logfile command".
 

What might be the reason, what else should I check for?

-- 
Regards,

Deepak
Oracle DBA 

--
http://www.freelists.org/webpage/oracle-l