CURSOR_SPACE_FOR_TIME Has Been Deprecated [ID 565424.1]
CURSOR_SPACE_FOR_TIME has been deprecated in 10.2.0.5 and 11.1.0.7.
CURSOR_SPACE_FOR_TIME was originally introduced to try and help reduce latch contention by keeping cursors in memory in the SGA rather than allowing their data to be flushed from the shared pool. Such latch contention is avoided in current releases by the use of cursor mutexes and so this parameter is no longer relevant.
Note:
This alert is to warn that CURSOR_SPACE_FOR_TIME will be deprecated in these Patch Sets.
Systems running with CURSOR_SPACE_FOR_TIME = TRUE may encounter some rare scenarios which can lead to logical data corruption.
Woraround:
Customers currently using CURSOR_SPACE_FOR_TIME=TRUE are advised to change the setting to FALSE (the default), or at least assess the impact of such a change prior to applying the 10.2.0.5 or 11.1.0.7 Patch Set.
Testing the Silk Platform in 2024: Achieving 20 GiB/s I/O Throughput in a
Single Cloud VM
-
Hands-on technical analysis of a novel data platform for high-performance
block I/O in the cloud, tested by Tanel Poder, a database consultant and a
long-t...
Acum o săptămână
Niciun comentariu:
Trimiteți un comentariu