Tuesday, July 22, 2008

CURSOR_SPACE_FOR_TIME to be deprecated in future releases

According to a recently published metalink note (565424.1) the parameter "CURSOR_SPACE_FOR_TIME" is going to be deprecated starting release onwards. In fact Oracle's next patch set release for 10g - will also de-support this parameter. We will have to remove this parameter whenever these 2 patch sets - for 10g and for 11g are released and we decided to migrate. CURSOR_SPACE_FOR_TIME was introduced to reduce latch contention; This parameter may no longer be required with introduction of cursor mutexes hence Oracle has decided to deprecate this in future releases.

No comments: