PVSCSI Controllers and Queue Depth – ASM SAME and Oracle Workloads

The previous blog post ’ PVSCSI Controllers and Queue Depth – Accelerating performance for Oracle Workloads’ purpose was to raise awareness of the importance of using PVSCSI adapters with adequate Queue Depth settings for an Oracle workload.

 

This blog focuses on the implementation of Oracle SAME (Stripe and Mirror everything) technology using Oracle ASM along with using multiple VMware PVSCSI controllers with queue depth for PVSCSI controllers and VMDK’s set to maximum to achieve maximum performance for Oracle workloads.

 

 

 

 

This blog

  • Is not meant to be any kind of performance study or bake off any sort
  • contains results that I got in my lab running a load generator SLOB against my workload, which will be way different than any real-world customer workload, your mileage may vary
  • remember, any performance data is a result of the combination of hardware configuration, software configuration, test methodology, test tool, and workload profile used in the testing. 

 

 

Continue reading

Posted in Oracle, VMware Hybrid Cloud | Comments Off on PVSCSI Controllers and Queue Depth – ASM SAME and Oracle Workloads

PVSCSI Controllers and Queue Depth – Accelerating performance for Oracle Workloads

For readers who are familiar with the Asterix and Obelix series, the magic potion refers to the potion brewed by Getafix, that gives the Gaulish warriors superhuman strength.

 

 

 

 

 

One of VMware’s magic portion for Oracle workloads is the ‘Paravirtualized SCSI Controllers a.k.a PVSCSI Controllers’ which is accelerates workloads performance on a VMware vSphere Platform.

This blog is meant to raise awareness of the importance of using PVSCSI adapters with adequate Queue Depth settings for an Oracle workload.

This blog

  • Is not meant to be a deep dive on PVSCSI and Queue Depth constructs
  • contains results that I got in my lab running a load generator SLOB against my workload, which will be way different than any real-world customer workload , your mileage may vary

Remember, any performance data is a result of the combination of hardware configuration, software configuration, test methodology, test tool, and workload profile used in the testing.

 

 

Continue reading

Posted in Oracle, VMware Hybrid Cloud | Comments Off on PVSCSI Controllers and Queue Depth – Accelerating performance for Oracle Workloads

VMworld 2020 – Breakout Sessions , Expert Round Tables and Demos focused on Business Critical Applications (BCA)

Join us at VMworld 2020 to learn how Business Critical Apps benefit from our latest platforms  

 

 

 

 

VMworld 2020 will be a global online event starting September 29 – October 1, 2020. While the program will be adapted to fit the new digital format, VMworld will still be the place to learn about innovative new technology solutions, hear perspectives from VMware executives, dive into educational and technical content, and engage with experts across the industry ecosystem.

 

Continue reading

Posted in Oracle, VMware Hybrid Cloud | Comments Off on VMworld 2020 – Breakout Sessions , Expert Round Tables and Demos focused on Business Critical Applications (BCA)

To NUMA or not to NUMA – Oracle workloads and NUMA

 

 

To NUMA or not to NUMA – that’s the question that comes up when considering Oracle workloads and NUMA.

 

This blog

  • Is not meant to be a deep dive on ESXi NUMA constructs
  • Is not meant to be by any way, any final recommendation, whether to enable NUMA at the database level or not
  • contains results that I got in my lab running a load generator SLOB against my workload, which will be way different than any real-world customer workload
  • is meant to raise awareness of the importance to test one’s database workload with / without Oracle NUMA and then make an informed decision whether to enable Oracle NUMA or not

 

Remember, any performance data is a result of the combination of hardware configuration, software configuration, test methodology, test tool, and workload profile used in the testing. 

The blog assumes that the reader is familiar with the ESXi NUMA constructs. This blog focuses on the use cases around testing Oracle workloads with and without NUMA using a load generator SLOB.

 

 

Continue reading

Posted in Oracle, VMware Hybrid Cloud | Comments Off on To NUMA or not to NUMA – Oracle workloads and NUMA

On Demand hot extend non-clustered Oracle Disks online without downtime – Hot Extend Disks

 

 

The first blog focused on how to Scale up CPU and Memory by hot adding CPU and Memory on the fly to an Oracle workload which can be found here.

This 2nd blog in the on-demand Scale up series focused on how to Hot Add / Hot Remove vmdk’s to / from a VM running an Oracle workload without any application downtime which can be found here.

This blog focuses on the OS and Oracle database steps to be taken once non-clustered vmdk(s) are hot extended while an Oracle database using ASM is running. Current restriction of shared vmdk’s using the multi-writer attribute is that Hot extend virtual disk is disallowed as per KB 1034165 & KB 2121181

 

 

 

Continue reading

Posted in Oracle, VMware Hybrid Cloud | Comments Off on On Demand hot extend non-clustered Oracle Disks online without downtime – Hot Extend Disks

On Demand Scaling up / Scaling down Storage resources for Oracle production workloads – Hot Add / Hot Remove non-clustered Disks

 

 

The first blog focused on how to Scale up CPU and Memory by hot adding CPU and Memory on the fly to an Oracle workload which can be found here.

This blog is the 2nd blog of the on-demand Scale up series which focuses on how to Hot Add / Hot Remove vmdk’s to / from a VM running an Oracle workload without any application downtime.

This blog will not focus on the actual steps how to Hot Add / Hot Remove vmdk(s) / rdm(s) to / from the Oracle Database VM. 

This blog will focus only on the OS and Oracle database steps to be taken once non-clustered vmdk(s) are added or removed from a VM while the database is running.

 

 

Continue reading

Posted in Oracle, VMware Hybrid Cloud | Comments Off on On Demand Scaling up / Scaling down Storage resources for Oracle production workloads – Hot Add / Hot Remove non-clustered Disks

VMware and Oracle together – A brave World – Oracle Cloud Days, 2020

 

 

The announcement on Sept 16th, 2019 by Larry Ellison, CEO Oracle Corporation at the Oracle Open World 2019 keynote heralded a new era in the VMware Oracle partnership, centerpiece of this relationship being a new service that will be offered by Oracle called Oracle Cloud VMware Solution.

This service will enable customers to run VMware Cloud Foundation on Oracle’s Generation 2 Cloud infrastructure. But equally important for the thousands of customers running Oracle software on VMware today in their data centers, Oracle and VMware have entered into a new mutual support agreement for currently supported Oracle products running on VMware environments.

More details can be found here

 

Further on Oct 9th, 2019, the 2nd part of this strategic alliance culminated in a new agreement for enhanced support for Oracle products running on VMware Environments running on Oracle Supported Computing Environments. Oracle Corporation has now changed its landmark Metalink/MyOracleSupport.com note 249212.1 describing that mutual support.  

More details can be found here

 

 

Continue reading

Posted in Oracle, VMware Hybrid Cloud | Comments Off on VMware and Oracle together – A brave World – Oracle Cloud Days, 2020

VMware and Rocky Mountain Oracle User Group (RMOUG) – Training Days, Feb 18th, 2020

 

 

 

RMOUG is one of the largest Oracle User groups in North America.  The RMOUG’s Training Days is the premier (and largest) grass-roots Oracle user training event in the U.S., offering an incredible variety of technical and functional educational sessions over three days from world-renowned experts.

https://rmoug.org/training/

 

Continue reading

Posted in Oracle, VMware Hybrid Cloud | Comments Off on VMware and Rocky Mountain Oracle User Group (RMOUG) – Training Days, Feb 18th, 2020

VMware and DOAG German Oracle User Group – January 23th – 24th, 2020

 

 

 

 

The DOAG German Oracle User Group was founded in 1988. Since then, DOAG has been the network of the German-speaking Oracle community, encouraging the exchange of knowledge on Oracle’s products and helping users to meet their daily challenges.

 

https://community.oracle.com/groups/doag

 

 

Continue reading

Posted in Oracle, VMware Hybrid Cloud | Comments Off on VMware and DOAG German Oracle User Group – January 23th – 24th, 2020

Oracle RAC storage migration from non-vSAN to vSAN 6.7 P01 – Through Thick to Thin

Storage migration of an Oracle RAC from non-vSAN Storage to vSAN 6.7 P01 – No remediation required for shared disks anymore
 

 

This blog is a follow up of the previous blog post “Oracle RAC on vSAN 6.7 P01 – No more Eager Zero Thick requirement for shared vmdk’s”.

This blog describes the steps to storage vMotion an Oracle RAC cluster with shared EZT vmdk’s from a non-vSAN (FC / NAS / iSCSI ) storage to a vSAN 6.7 P01 storage and highlights the fact that apart from putting the multi-writer attribute back on the shared vmdk’s , there is no need for any further reconfiguration of the shared vmdk’s.

 

 

Continue reading

Posted in Oracle, VMware Hybrid Cloud | Comments Off on Oracle RAC storage migration from non-vSAN to vSAN 6.7 P01 – Through Thick to Thin