http://www.pythian.com/news/27201/oracle-database-appliance-storage-performance-part-1/
http://www.nocoug.org/Journal/NoCOUG_Journal_201202.pdf
To summarize, you can expect ODA to deliver easily 3000 IOPS whether read or write with average IO response time up to 10ms and almost double that if you can afford average random IO response time to raise up to 20 ms.
We can also conclude that write activity has minimal impact on throughout as you would expect from a non-RAID5 system
ODA it’s configured to present disks as JBOD so that ASM is in charge of mirroring and striping.
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