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 …

This Log Buffer edition works it way through some of the coolest blog posts from Oracle, SQL Server and MySQL of the past week.

Oracle:

• What if I’m a developer or QA person using a copy of production database to do my work. What if my copy of production is now out of date and I want to refresh my data with the data as it is on production.
• Direct path and buffered reads again.
• Copy Data Management for Oracle Database with EMC AppSync and XtremIO.
• Little things worth knowing: automatic …

This Log Buffer Edition covers some blog posts of Oracle, SQL Server and MySQL from this past week.

Oracle:

• Oracle Utilities Application Framework V4.3.0.1.0 includes a new help engine and changes to the organization of help.
• Very simple oracle package for HTTPS and HTTP.
• Tim spotted a problem with the PDB Logging Clause.
• How to Pass Arguments to OS Shell Script from Oracle Database.

SQL Server:

• How efficient is your covered …

Docker has been consuming my life in the last few weeks. I have half a dozen projects in progress that use containers in some fashion, including my Visualizing MySQL’s Performance Schema project.

Since I prefer to work from a Mac laptop, I have to utilize a Linux Virtual Machine (VM) which runs the Docker daemon. Luckily, Docker Machine makes this a very simple process.

However, interacting both with Docker and Docker Machine does introduce some additional commands that I would rather simplify for the repeatable use-cases I’ve come across. With BASH aliases, this is not a problem.

Is My Docker Environment Setup?

When …

This Log Buffer Edition finds and publishes blog posts from Oracle, SQL Server and MySQL.

Oracle:

• SCRIPT execution errors when creating a DBaaS instance with local and cloud backups.
• Designing Surrogate vs Natural Keys with Oracle SQL Developer.
• EBS General Ledger – Accounting Hub Reporting Cloud Service.
• Oracle Database Standard Edition 2 is available.
• Disable “Build After Save at …

Last week, I was pleased to present at Percona Live Amsterdam 2015 regarding the importance of Performance Schema and how to begin approaching visualizing the data that is available to diagnose performance issues and fine tune your MySQL environment. You can download the slides from the Percona Live conference page.

The session highlighted using the ELK (Elasticsearch+Logstash+Kibana) stack to assist visualizing event data, in addition to graphite+graphana to visualize time-series data.

As many people who attend conferences are aware, the availability of internet access is sketchy at best. To combat this, the visualization stack that I created was strictly local utilizing Docker, specifically the Docker Toolbox.

The docker-compose.yml …

My job is almost completely reliant upon my ability to perform work in lab of virtual machines. Almost every action plan I write is tested locally. When I need to troubleshoot an issue for a client one of the most common first steps I’ll perform is attempting to recreate the issue in a virtual environment so I can work on it there without the risk of impacting client data.

I believe that having a place to test and grow your skills is an absolute necessity for anyone working in the IT field today regardless of your specialization, even if you’re an IT generalist. But every now and then I hear about individuals who have issues with their virtual machines or with the virtual environment provided by their employer, so I figured this was a good time to share my method of creating a virtual lab. More specifically, one that allows you to do virtual work on a commodity laptop, one that won’t break down if you lose connectivity, one that …

This Log Buffer Edition dives deep into the ocean of blogosphere and surfaces with some cool blog posts from Oracle, SQL Server and MySQL.

Oracle:

• Lets Talk DB Perth
• The Fundamental Challenge of Computer System Performance
• Index Advanced Compression: Multi-Column Index
• Middleware Diagnostics Advisor (MDA) Setup
• Most people are now aware that in 12c, a …

This Log Buffer Edition carries on with the weekly culling of blog posts from Oracle, SQL Server and MySQL.

Oracle:

Most people are now aware that in 12c, a VARCHAR2 has been extended from a maximum size of 4000 to 32767 bytes.

FDMEE is offered as the full-featured successor to Oracle Hyperion Financial Data Quality Management ERP Integration Adapter for Oracle Applications (ERP Integrator) and Oracle Hyperion Financial Data Quality Management (FDM).

Cybersecurity is Hot! In fact, so is the weather here in California at this moment.

How do you monitor …

This Log Buffer Edition covers some nifty blog posts from Oracle, SQL Server and MySQL.

Oracle:

• Real Application Testing report On Premise vs. Oracle Public Cloud
• Foreign Keys and Library Cache Locks
• IN/EXISTS bugs by Jonathan Lewis.
• Creating a trace file from EM12c is quite easy and doesn’t require a DBA offering up the world to allow a developer or support person to perform this action.
• Oracle …