Switch logfile hangs

Hi

When we repeatedly give switch logfile command, DB is hanging after some 7 or 8 successful switches.

But if we give manual checkpoint, log is switching. Then again it is hanging after some 5 or 6 successful runs.



Database version 9.2.0.5
Solaris

log_checkpoint_interval 98000000
log_checkpoint_timeout 3600
log_checkpoints_to_alert TRUE

Thanks

How big is the log file? And what is Checkpoint Interval..?

and define hanging

Logfile size is 200mb, 4 groups of 2 members,
Wait on--- switch logfile command.

Quote:

---

Originally Posted by davey23uk

and define hanging

---

Exactly. Is it taking longer or it never completes? Are you sure the delay is not because data is being written to archive log?

http://www.ixora.com.au/q+a/0012/18102646.htm

Quote:

---

Originally Posted by SANJAY_G

Exactly. Is it taking longer or it never completes? Are you sure the delay is not because data is being written to archive log?

---

It never completes. The wait clearly says "Waiting on log swich command"

No. there is no data being written to the disk. I am manually giving switch log file command.

Thanks

pl see the destination of archive files may be the archive dest is filled up. in archive mode the database hangs till the redo is archived.

Quote:

---

Originally Posted by RayaguruSD

pl see the destination of archive files may be the archive dest is filled up. in archive mode the database hangs till the redo is archived.

---

Read the post first.... Will the manul switch work if the archivelog destionation is full..?

If I give manual checkpoint, the hanging session completes with switch logfile command.