Tag: Technical Blog

How EBS Concurrent Processing Should Run on Oracle RAC

Concurrent Processing in one of the most resources consuming Oracle e-Business Suite component. It is important to ensure a proper performance management of that components. Oracle Real Application Clusters provides Scalability and High Availability. Applications running on RAC should support certain configuration options to leverage RAC benefits. This blog posts describes possible concurrent processing configuration options and highlights EBS today’s limitations. It provides a possible solution and explains what benefits it could introduce to organizations running both EBS and RAC today.

Read More >

About MySQL 5.6

I am very excited and thrilled to use the latest release of MySQL 5.6 in production. This is probably the most notable and innovative release from many years, if not ever. I this post I take a detailed look at what is new in MySQL 5.6 and why I think its the best version of MySQL to date

Read More >

DBD::Oracle 1.57_00 Is On Its Way to CPAN

DBD::Oracle version 1.57_00 is on its way to CPAN. This release is small, but should make some Win32 users happy:

Read More >

How to Troubleshoot OEM 12c Cloud Control Auto-Discovery

OEM 12c Cloud Control looks daily for new targets, placing them in a queue for admin promotion to managed objects. Details and troubleshooting info follow.

Read More >

REGEXP_REPLACE: Auto-Translate SQL Literals to Bind Vars

In this post I show you how to get SQL strings transformed in a way that resembles the result of cursor_sharing.

Read More >

Pythian Appearances at RMOUG in Denver CO

As usual, the who’s-who of the Oracle tech space will be assembling in Denver the week of February 11 for the Rock Mountain Oracle Users’ Group. A plethora of Pythian employees with be speaking as will we also have a booth in the vendor hall. Please drop by and say “hi”. See the full detail of who is presenting and when.

Read More >

The Easy Way of Finding Similar SQL Statements

As we all know proper use of bind variables in SQL statements is a must to make transaction processing applications scalable. So how do we find the queries that don’t use bind variables and have to be parsed each time they are executed? There is number of ways, but this article is all about the most effective way I know. If you have a better one – let me know please!

Read More >

Are You Switching to BULK_LOGGED Recovery Model? Know Your Risks.

This post should give you some insights into the risk that your databases are in by switching to the bulk-logged recovery model. So, what do you need to do to avoid this risk? Make sure that you run a backup immediately after the transactions you are running under the bulk-logged recovery model complete.

Read More >

AlwaysOn Readable Secondaries: That Extra 14-bytes in Your Record You Didn’t Know About

I describe AlwaysOn Availability Groups as a “database mirroring configuration sitting on top of a Windows Failover Cluster infrastructure.” Why do I say this? It’s because I want SQL Server DBAs to leverage what they already know on features like database mirroring and failover clustering and apply them when dealing with AlwaysOn Availability Groups.

Read More >

Hadoop FAQ – Getting Started

Hadoop

Following my “Building Integrated DWH with Oracle and Hadoop” webinar for IOUG Big Data SIG, I got a bunch of excellent follow up questions. The most frequently asked questions are: What is the minimum I need to do to get started with Hadoop? and How do I load data into Hadoop? Since so many people are interested in the same question, it makes more sense to answer on the blog.

Read More >
Page 10 of 64« First Page...89101112...20...Last Page »