Search

Top 60 Oracle Blogs

Recent comments

September 2015

SANGAM15 – See you there!

I mentioned my Oracle OpenWorld 2015 trip in a previous post. Yesterday evening I picked up my passport with my lovely new India visa in it!

The talks are written. The flights are booked. The hotel is booked. I have a visa. So that’s me sorted for SANGAM15 in November! :)

Row transposition

Here’s a couple of simple examples to get you started with transposing rows to columns. The problem typically presents as:

How do you convert a listing in rows (eg, where people placed in a race), into some output that is across the page ?

For example, given a running race, how do you generate output which looks like this:

| RACE_ID | PLACING1 | PLACING2 | PLACING3 | PLACING4 |

So here’s our source table

BI Publisher Tips and Techniques

A colleague of mine asked recently if we had any best practices for BI Publisher, the latest and greatest reporting tool we use within Enterprise Manager (the old tool, Information Publisher, is of course also still supported but this post is relevant to BI Publisher). As you would well know if you’ve been following my posts or heard me presenting at conferences, best practices is a term I hate, so rather than using that term let’s discuss some tips and techniques that might be relevant to you when using BI Publisher.

Tip #1: Allocate Extra Memory

The amount of required memory for BI Publisher depends on a huge number of factors – complexity of reports, size of datasets being returned, BI Publisher scheduling load, etc. We recommend adding at least 1.5 Gb of RAM for the OMS machine, but you may need as much as 4-5 Gb depending on the factors just mentioned.

We are hiring!

Gluent – where I’m a cofounder & CEO – is hiring awesome developers and (big data) infrastructure specialists in US and UK!

We are still in stealth mode, so won’t be detailing publicly what exactly we are doing ;-)

However, it is evident that the modern data platforms (for example Hadoop) with their scalability, affordability-at-scale and freedom to use many different processing engines on open data formats are turning enterprise IT upside down.

The Fundamental Challenge of Computer System Performance

The fundamental challenge of computer system performance is for your system to have enough power to handle the work you ask it to do. It sounds really simple, but helping people meet this challenge has been the point of my whole career. It has kept me busy for 26 years, and there’s no end in sight.

Capacity and Workload

Our challenge is the relationship between a computer’s capacity and its workload. I think of capacity as an empty box representing a machine’s ability to do work over time. Workload is the work your computer does, in the form of programs that it runs for you, executed over time. Workload is the content that can fill the capacity box.

Index Advanced Compression: Multi-Column Index Part I (There There)

I’ve discussed Index Advanced Compression here a number of times previously. It’s the really cool additional capability introduced to the Advanced Compression Option with 12.1.0.2, that not only makes compressing indexes a much easier exercise but also enables indexes to be compressed more effectively than previously possible. Thought I might look at a multi-column index to highlight just […]

Presenting the Hotsos Symposium Training Day – 10 March 2016 (Heat)

I’ve just accepted an invitation to present the Hotsos Symposium Training Day on 10 March 2016 in sunny Dallas, Texas. In the age of Exadata and In-Memory databases, it’ll be an updated and consolidated version of my Index Internals and Best Practices seminar. With an emphasis on using indexes appropriately to boost performance, it’ll feature […]

WordPress 4.3.1

WordPress 4.3.1 has been released. Downloads and changelogs in the usual places.

Hopefully, by the time you read this your site will have automatically been upgraded and you’ll have nothing to do, except maybe update a few plugins. :)

Recommendations to Address Cloud Performance Issues via EM12c

So I’m going to start this post with an admission-  I don’t have access to a cloud environment to test this out, but I know what I would do first if I experienced slow response time on database creation or cloning via EM12c to the cloud and I would like to at LEAST post what I would do to give others the chance to test it out and see

OTN Tour of Latin America 2015 : It’s a Wrap!

ace-director

I just realised I didn’t write a closing post for the OTN Tour of Latin America 2015, so here goes.

Here are the links to all the posts I wrote during the two weeks that related to the main body of the tour.