Hi,
I came around a situation which was quiet interesting as well as frustating.
I have a database with trunc log on checkpoint enabled.
Its log got filled up
there is nothing in syslogshold
all the commands running are AWAITING COMMANDS.
Now how should I free up the logsegment.