Sometimes , an Oracle DB session gets in suspended state due to out of space in the BSM_OMI tablespace.
This is known as “Resumable Space Allocation”.
1. What can cause a DB session to get into suspended state?
2. Are there any best practices for configuring the DB and the BSM_OMI tablespaces in such cases?
3. In which logfile should I find related information about the problem?