RE: Alter system switch logfile hang

From: Dougie McGibbon <DMcGibbon@xxxxxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
Date: Wed, 9 Nov 2005 10:08:21 +1300

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@xxxxxxxxx] 
Sent: Tuesday, November 08, 2005 6:34 PM
To: oracle-l@xxxxxxxxxxxxx
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

RE: Alter system switch logfile hang

Other related posts: