Tag: Oracle

Log Buffer #306, A Carnival of the Vanities for DBAs

Bloggers are striving hard to up their game. They are writing, editing, formatting, trimming, enhancing their blogs to offer maximum value. This Log Bufer Edition #306 cherishes these efforts.

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 >

Log Buffer #304, A Carnival of the Vanities for DBAs

When it comes to the information and its management, nothing compliments information than the databases. This Log Buffer Edition #304 covers the latest and greatest database technologies related to Oracle, SQL Server and MySQL.

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 >

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 >

Log Buffer #303, A Carnival of the Vanities for DBAs

Sky’s the limit for the database bloggers. They are producing awesome rants in Oracle, fabulous ramblings in MySQL, and fantastic views in SQL Server, and this Log Buffer Edition, very proudly covers all that in Log Buffer #303. Enjoy.

Read More >

Set Up Exadata for Cloud Control 12.1.0.2

I recently helped setup an Exadata X2-8 Database Machine with the latest version of OEM Cloud Countrol (12.1.0.2). A few documents do exist for this process. However I found a few inconsistencies and problems; I think the existing documents I found were written on older versions of OEM and older versions of the tools. I’m publishing my final procedure here with hopes that it helps you, but as always please cross-reference this with the appropriate documentation before doing anything in your own environment.

Read More >

Log Buffer #302, A Carnival of the Vanities for DBAs

There is no great joys for the bloggers to mark the holiday season with some blistering and lightweight blog posts. This Log Buffer Edition in Log Buffer #302 shares that mirth and presents you with another medley of blogs.

Read More >

DBD::Oracle v1.54 on Its Way to CPAN

DBD::Oracle v1.54 is on its way to CPAN. In this iteration, no new feature, but a large amount of bug fixes.

Read More >
Page 21 of 141« First Page...10...1920212223...30...Last Page »