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.
WAIT Clause for DMLs in 26.2
-
Oracle 26ai 26.2 now introduces the WAIT (and NOWAIT) Clause for INSERT /
UPDATE / DELETE / MERGE DMLs. We have had a WAIT Clause for SELECT FOR
UPDATE...
Acum o săptămână
Niciun comentariu:
Trimiteți un comentariu