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.
Partition by Expression
-
Oracle 26.1 now allows using an *Expression* in the Partitioning Clause.
In earlier releases, you could do this with a Virtual Column defined in the
ta...
Acum 2 ore
Niciun comentariu:
Trimiteți un comentariu