Oracle

EM CLI with Scripting Option in EM12cR3

The new release of #EM12c came with advanced EM CLI, providing interactive and script modes to enhance the standard command line functionality. EM CLI includes Jython interpreter and all verbs presented as functions, which allows the use of verb arguments as parameters. Managing several thousand targets in one of Pythian’s client environments and having different…

SQL for Pattern Matching in Oracle 12c

Oracle 12c is out! And with it, a myriad of new features that we’ll be learning and playing with in the months and years to come. Paraphrasing Iggy Fernandez’s blog: “So many Oracle manuals, so little time…” The new features abound, and we need to cherry pick some interesting ones to delve into. There are…

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

Nelson Mandela, The Madiba, said: ” There is nothing like returning to a place that remains unchanged to find the ways in which you yourself have altered.” Bloggers return to their blogs to experience the same charming thing, and database bloggers are no different. Enjoy this edition of Log Buffer.

Duplicate Database from Active Database — Just Works!

My friend Øyvind Isene suggested that I store a DUPLICATE RMAN script that works in a safe place in this tweet. @yvelik Me too, then I store the script in a safe place :-) Duplicate jobs reminds me how important it is to practice restore. — Øyvind Isene (@OyvindIsene) July 1, 2013 I couldn’t find a…

Amazon Elastic Load Balancer with Oracle E-Business Suite

This blog post outlines a couple of issues we faced in our Oracle E-Business consulting group when configuring Amazon Elastic Load Balancer with Oracle E-Business Suite 11i. The current IT industry trend is to virtualize all servers, and Oracle E-Business Suite servers are no exception. Among current cloud operators, Amazon Cloud infrastructure is a favorite…

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

Just like the new car model excites the car enthusiasts, the new version of the database products fascinates the database professionals. A plethora of blog posts sprung up as the new versions of databases are released. Oracle, SQL Server, and MySQL now have new things to offer. This Log Buffer shares that excitement and anticipation.

How to Install Oracle 12c RAC: A Step-by-Step Guide

Okay, back to school folks, back to school :). As with any new product, our long learning journey starts with an installation on a sandbox environment. To get you up to speed with Oracle 12c RAC and let you focus on important stuff (e.g. features research), I have put together detailed step-by-step installation instructions. You…

Why Upgrade to Oracle 12c

Oracle 12c: Making the Impossible, Possible?

Pythian’s Oracle team has had the opportunity over this last year to explore, test, and assess every aspect of Oracle’s latest database release. Oracle 12c, and we have to say, it’s very impressive. See our top 5 reasons to upgrade and share your reasons.

Do You Know If Your Database Is Slow?

The time to respond There was a question at Pythian a while ago on how to monitor Oracle database instance performance and alert if there is significant degradation. That got me thinking, while there are different approaches that different DBAs would take to interactively measure current instance performance, here we would need something simple. It…

Page 13 of 139« First...1112131415...203040...Last »