This Log buffer edition covers Oracle, SQL Server and MySQL blog posts about new features, tips, tricks and best practices.
Oracle:
- Traditionally, assigning specific processes to a certain set of CPUs has been done by using processor sets (and resource pools). This is quite useful, but it requires the hard partitioning of processors in the system. That means, we can’t restrict process A to run on CPUs 1,2,3 and process B to run on CPUs 3,4,5, because these partitions overlap.
- Parallel_Degree_Limit, Parallel_Max_Degree, Maximum DOP? Confused?
- JDeveloper 12c – ORA-01882: time zone region not found
- Using a Parallel Gateway without a Merge in OBPM
- Secure multi-threaded live migration for kernel zones
SQL Server:
- How to Unlock Your Team’s Creative Power with SQL Prompt and a VCS
- In-Memory OLTP – Common Workload Patterns and Migration Considerations
- The Poster of the Plethora of PowerShell Pitfalls
- Temporarily Change SQL Server Log Shipping Database to Read Only
- Monitoring Availability Groups with Redgate SQL Monitor
MySQL:
- Introducing MySQL Performance Analyzer
- MySQL 5.7.8 – Now featuring super_read_only and disabled_storage_engines
- Become a MySQL DBA – Webinar series: Which High Availability Solution?
- How to obtain the MySQL version from an FRM file
- MySQL Enterprise Audit: Parsing Audit Information From Log Files, Inserting Into MySQL Table
Learn more about Pythian’s expertise in Oracle , SQL Server & MySQL, as well as the author Fahd Mirza.
No comments