This Log Buffer Edition covers some more Oracle, SQL Server and MySQL blog posts from across the world.
Oracle:
- Should I monitor the MGMTDB database?
- Connecting MAF Applications to Mobile Cloud Service
- JRE 6, 7, and 8 now certified with EBS 11i, 12.1, and 12.2
- The database writer copies data blocks from the buffer cache onto disk. The db_writer_processes initialization parameter determines how many processes will do this task. Its default value is 1 or cpu_count / 8, whichever is greater. I found an Oracle 9 database on a Tru64 server with cpu_count set to 1
- How To Install Latest Verisign G5 Root Certificates
SQL Server:
- Dynamic Pivot, Passing Temp Table Variables to Dynamic SQL
- Oracle offers a results cache in the database (from 11.2 onwards) and in PL/SQL (again, from 11.2 onwards) which can greatly reduce execution time of repeated statements when insert/update/delete activity is not heavy.
- Maintaining a grouped running MAX (or MIN)
- Harnessing SQL Server Metadata- Disabling and Rebuilding Indexes
- Optimizing Your Query Plans with the SQL Server 2014 Cardinality Estimator
MySQL:
- ClusterControl Tips & Tricks: Updating your MySQL Configuration
- Become a MySQL DBA blog series – Optimizer Hints for faster query execution
- Loading Arbitary XML documents into MySQL tables with p_load_xml
- Use MySQL and Perl to automatically find, follow and unfollow twitter users
- Great Advice on Monitoring Amazon RDS For MySQL From Datadog
Learn more about Pythian’s expertise in Oracle , SQL Server & MySQL.
No comments