Not able to disable SMCO background process
I want to disable the new background process SMCO introduced to Oracle 11g. I set the init parameter _ENABLE_SPACE_PREALLOCATION=0 as shown in the note below but I still see the process up. I have bounced the database after setting this parameter in init.ora file. Did anyone have this issue as well?
SMCO (Space Management Coordinator) For Autoextend On Datafiles And How To Disable/Enable [ID 743773.1]
Thanks
Tejal