Tag: Oracle

Log Buffer #151: A Carnival of the Vanities for DBAs

Welcome to the 151st edition of Log Buffer, the weekly review of database blogs.

Read More >

Scalable Internet Architectures

My old friend and collaborator Theo Schlossnagle at OmniTI posted his slides from his Scalable Internet Architectures talk at VelocityConf 2009. The slides are brilliant even without seeing Theo talk and I highly recommend the time it takes to flip through them, for anyone who is interested in systems performance. If anyone took an mp3 of this talk I’m dying to hear it, please let me know. Here’s the slide deck. Let me know your thoughts.

Read More >

Installing Oracle 11gR1 on Ubuntu 9.04 Jaunty Jackalope

Welcome, readers! It’s time for another update to our series of posts on installing Oracle on Ubuntu Linux. In this edition, we’ll be installing Oracle 11g R1 on Ubuntu 9.04, both 32-bit. This time, I’ve used VirtualBox to run a virtual machine (VM) to perform our work.

Read More >

Sydney Oracle Meetup #7 – Advanced Queuing in E-Business Suite

We will start with an overview of the AQ technology in Oracle database – what it is and what it let you do. Then we will see how it’s used in Oracle E-Business Suite and how to manage it. Our speakers for the evening are your fellow SOM members – Jurijs Velikanovs and Warwick Sands. TBC.

Read More >

Oracle Open World — Public Voting is Open

No doubt you want to cast you first vote for my abstract — Developing Plug-ins for Oracle Enterprise Manager by example :) This presentation starts with an introduction of Enterprise Manager’s Extensibility features and walks the audience through the basics of creating a new plug-in. This session will also demonstrate some proven plug-in development steps based on the experience gained from developing MySQL management plug-in. Session includes a demo of the plug-in development scenarios. After this presentation, attendees will be able to design and develop management plug-ins for their own applications. Login to Oracle Mix and vote now. At the time of writing, my session is on the very top — help to keep it there! ;-)

Read More >

Pythian Video: Oracle RAC – VIP Configuration Mistakes

The first videocast was quite popular — it has more than 300 views in couple weeks and considering no Hollywood stars were starring in that video and there were no nude scenes, I think it’s fair to say that this format was very much welcomed by the audience. Today, I’m posting the follow up session on VIP’s (Virtual IP’s) with Oracle RAC. What I demonstrate today is a typical configuration mistake for a RAC databases created with Database Configuration Assistant (DBCA) and what’s the result of such omission.

Read More >

Hey, I’m an Oracle ACE Director Now!

I’ve been just sending the abstracts for UKOUG 2009 Conference before the extended deadline is over and realized that I hadn’t spread those exciting news. Actually, the news spread via Twitter before I saw the official confirmation in my inbox. Well, I guess the blog post title says it all. It’s a pleasure to join this program and get engaged in its activities.

Read More >

Announcing Sydney Oracle Meetup #6 – Storage for Oracle Databases

This meetup will be focused on storage technologies for Oracle database. It looks like a short presentation on Oracle Automatic Storage Management is in order – quite a few people are missing the concepts of the Oracle flagman storage storage solution and it’s useful to understand the approach whether you use it now or not.

Read More >

Turn Off db_cache_advice To Avoid Latch Contention Bugs

A couple of weeks ago, we noticed some timeouts in some of our standard Oracle RDBMS health check scripts on a new instance. At first the timeouts were infrequent, but over the course of a week started to grow in frequencey until the point where none of the checks were finishing in the allowed timeframe. We ran an AWR report, and tucked far down in the “Latch Activity” section, a colleague noticed this…

Read More >

Oracle: Limiting Query Runtime Without Killing the Session

Resource Manager not only allows one to define how much CPU a certain user or group gets, it also lets one switch into lower priority groups and kill a query while leaving the session running. It is like running a SELECT statement in sqlplus, and pressing ctrl-c. The session is still alive, yet the query is canceled. Sure, the Resource Manager is documented by Oracle, but when I started to test this feature, I came across a few very interesting things that are not as well documented, and that’s what prompted me to write this post

Read More >
Page 91 of 147« First Page...10...8990919293...100...Last Page »