I/O Block Size (> 3 MB) Best Practice on EMC AFA/HFA and Linux (Physical and Virtual)

We have a problem on our Oracle Database servers which are hosting by Oracle Linux servers, when Oracle Databases putting to Maximum Availability protection mode, some workloads impacts performance whole database ecosystem. The workloads are related to some tasks which performed from by application servers and the tasks needs huge read/write I/O on storage arrays. We are using DELL EMC Unity/Unity XT (All Flash/Hybrid Flash) family in most of projects. I did lots of searches and found nothing at first step. I had only one clue, I/O block size was very large during performing tasks by database servers.

Windows Updates Remotely: Download and Install via PSWindowsUpdate PowerShell Module

PSWindowsUpdate

Operating system is the core of any system and we have to keep operating system update cause of preventing performance issues, unplanned downtime and fix security vulnerabilities. Windows (client and servers) has a standard terminology for receiving updates monthly and most of organizations using Windows Server Update Services to applying updates of multiple servers/client. Updates would be downloaded and installed on multiple servers/clients automatically but service downtime is always the biggest concern but another concern is installing updates on multiple machines and rebooting systems during planned downtime. PowerShell and WinRM would help us when they come as PSWindowsUpdate PowerShell module!

CPU Core Limit in Oracle Database: Best Solution for Dummies

When you have no right sizing, when you have no control what be happened on database and when you didn't any optimization, limiting using resources by database or any other system will necessary to help server to keep working without hang. Oracle Database be able to use all processing resources on a server and other process will be dead or hang if they couldn't receive enough time for processing. CPU is the most important component and resource on any computer system, so if you want to stable system then the needed resources should be measured by right sizing or limiting some processes to delivering minimal resources to other processes.

Major Update For DELL EMC Unity/Unity XT OE (5.2.0.0.5.173)

Dell EMC Unity XT

EMC has released new OE (5.2.0.0.5.173) for Unity/Unity XT storage array family with new major changes. The new release also contains lots of resolved issues for different components. The biggest changes are "Data Reduction and Advanced Deduplication" can now be enabled for hybrid storage pools and also dynamic pools will be expanded faster than before.