Posts Categorized: Technical Blog

RIP Flash-based My Oracle Support

The end is nigh for Adobe Flash at My Oracle Support. The first step will happen during this weekend’s planned maintenance of My Oracle support, when all of MOS will be down for 5 hours starting at midnight eastern, Saturday January 28. Once it comes back up, the unadvertised non-Flash supporthtml.oracle.com will come up as a quasi-user acceptance test of the new application, while the flash-based support.oracle.com stays as-is.

Gearing up for RMOUG Training Days 2012

The 2012 edition of RMOUG Training Days in Denver less than a month away, running February 15 and 16 at the Colorado Convention Center in Denver. . It’s not too late to register, and it’s a pretty nice excuse to get to the Rockies in ski season. I’ll be doing two presentations, and am polishing up whitepapers and presentations for the submission deadline tomorrow

R12.2 online patching – What are the hidden costs?

I attended a great presentation at UKOUG 2011, “Oracle E-business Suite’s use of edition-based redefinition for online patching,” delivered by Bryn Llewellyn from Oracle. The presentation provided thorough insight on how EBR works and how E-Business Suite will be able to use it for online patching. It answered many questions, but raised a few more questions and concerns. I’ll try to summarize in this post the main concerns I’ve been thinking about after attending this presentation.

A Web Log Analyzer Called DuckFeet

DuckFeet’s guts are SQLicious, and built as DBIx::Class classes, sprinkled with wonderfully tooth-decaying DBIx::Class::Candy on top. In the repo, it’s all under the DuckFeet::Schema namespace. For the time being, there is only a handful of tables (hits, uris, referers, agents and hosts), but it should be easily extendable to add any type of information we might desire to throw in, but it should be easily extendable to add any type of information we might desire to throw in.

Oracle Instance Memory Usage

How much memory does my Oracle instance use? How much memory do my database connections use? These are questions that can help with capacity planning of your server’s Physical and Virtual memory. There are several write ups out there on the web that attempt to address these questions. From what I could gather from them, there is only one truly good way to tell exactly how much memory is currently in use by an oracle instance, as well as the average memory usage for oracle dedicated connection processes. I explain it here.

Once again about innodb-concurrency-tickets

I had to refresh my knowledge on how InnoDB threads queue works the other day when debugging activity spikes on one of the customer’s production system and while I had general idea about InnoDB kernel and queue, thread concurrency and queue join delays I didn’t have a complete model of how InnoDB concurrency control works. So I started from manual…

Page 18 of 55« First...10...1617181920...304050...Last »