Today Database restarted automatically and now after restarting not able to execute any query.
Checked and observed that in database lots of 16MB Chunks are available. Total 16MB X 20,000
(This issue now known to me and planning to do every night CTAS to avoid such scenario).
However, wondering that Total Disk Utilization is approx 400GB, but system is IOSTAT is showing last 3 hours 3000 tps (100 MB/sec).
infolog is not showing any useful information.
Now i am clueless when system will be available.
Please let us know if any option is available to restart Database and first do CTAS to avoid such dead lock condition.