If you want to make your redo logs faster, you can put them on this device .
The speed is about 4GB/s with the latency around 0.5 microseconds
 Module ArxCis-NV DRAM with 2 GB capacity can be purchased for $ 300.
http://www.vikingtechnology.com/arxcis-nv
http://pcper.com/news/General-Tech/How-about-battery-free-RAMdrive-Viking-ArxCis-NV-writes-flash-if-it-loses-power
Get Oracle Partition High Values as VARCHAR2 types instead of LONG in
Oracle 19c and earlier
-
Here’s a little PL/SQL function create_partition_high_value_func.sql that
allows you to write SQL queries against data dictionary for partition
maintenan...
Acum o săptămână
Niciun comentariu:
Trimiteți un comentariu