Search

Top 60 Oracle Blogs

Recent comments

January 2016

YouTube : 6 Months and 1000 Subscribers!

That’s right, it’s been a touch over 6 months and my YouTube channel has just hit the 1000 subscriber mark. :)

This YouTube experience has been quite odd. My plan was to try and upload a video every weekday for the first 2 months, and I came pretty close to hitting that target. Once I had got a bit of content on the channel, I was inevitably going to kick back a little. After all, there is the website, the blog, life and that annoyance they call work to consider. I think a realistic target is to aim for is 1-2 videos a week.

Top Executions SQL Monitoring style reports in SQLd360

I think SQL Monitoring is an amazing tool when it comes to SQL Tuning but I often find that for one reason or another the report is almost never around for post-mortem investigation.
Historical SQL Monitoring reports have been introduced in 12c but still the decision to collect or no the report for the SQL ID we are interested in depends on several factors we have no control on after the issue happened </p />
</p></div>

    	  	<div class=

Indexes and Initrans (Blackstar)

It’s been a very tough week so to help keep my mind off rather sad events, thought I’ll finish off one of my unpublished articles. Initrans is a physical attribute that determines the initial number of concurrent transaction entries allocated within each data block for a given table/index/cluster. Every transaction that updates a block has to acquire an […]

Yes SQL ! the conference Jan 26 & 27 at Oracle

Wow, this is big – a Yes SQL conference !

Finally ! It’s here ! Yes SQL ! the conference!

At Oracle headquarters !

Send me your questions!

Have questions about SQL? about No SQL? about Yes SQL? About how Oracle is faring in the industry with SQL? I’ll be moderating a SQL panel discussion with

  • Andy Mendelsohn (Executive Vice President for Database Server Technologies)
  • George Lumpkin (Vice President, Product Management)
  • Bryn Llewellyn (Distinguished Product Manager)
  • Steven Feuerstein (Developer Advocate)
  • Mohamed Zait (Architect) will explain Oracle’s strategy

Send me your questions – ideally just put them in the comments below – and I’ll ask them in the panel discussion.

Is Oracle Web scale? Is Oracle Web scale? Come ask the panel discussion.

Installing a New Enterprise Manager 13c Environment

As I patiently wait for approvals to post my Oracle Management Cloud blog posts, I thought I would just post on Enterprise Manager 13c and answer questions that have been posed to me via email and comments.

Is there anything new I need to watch for as I install EM13c?

Enterprise Manager Cloud Control 13c : Navigation and “Look and Feel”

o-enterprisemgr-13c-clr-2769481I’ve continued to play around with Cloud Control 13c and I’m generally getting a nice vibe from it.

One of the things I really hated about Grid Control 10g and 11g was the navigation. It felt like you had to click on 50 links to get to the thing you wanted. When Cloud Control 12c came along and had a main menu it was a massive improvement. Even so, it was still a little annoying as the menu was split, with some bits on the left and some bits on the top-right.

em12c-menu

In Cloud Control 13c, these menus have been brought together into the top-right of the screen.

AskTom–help us to help you

On AskTom, obviously you’re are going to be posting code and/or code output.  It’s probably going to be the most vital part of the question’s test case so that we can help you out.

So please dont forget the “” and “” tags around your question. 

Otherwise we get this – it’s all wrapped and very hard to digest.  That’s a sure fire way for us to go “Yup… I might come back to that one later” Smile

image

Graphora

I knew I had to try out Neto’s  Graphora when I saw that it was a docker container to collect Oracle performance data and send it to Graphite. Graphite has been on my radar as I see and hear about more and more companies using it to graph and monitor performance data.  Any graphical Oracle performance tool interests me and recently I’ve been spending some time investigating Docker so having everything rolled up in Graphora sounded perfect.

Introducing stapflame, extended stack profiling using systemtap, perf and flame graphs

There’s been a lot of work in the area of profiling. One of the things I have recently fallen in love with is Brendan Gregg’s flamegraphs. I work mainly on Linux, which means I use perf for generating stack traces. Luca Canali put a lot of effort in generating extended stack profiling methods, including kernel (only) stack traces and CPU state, reading the wait interface via direct SGA reading and kernel stack traces and getting userspace stack traces using libunwind and ptrace plus kernel stack and CPU state. I was inspired by the last method, but wanted more information, like process CPU state including runqueue time.

David Bowie 1947-2016. My Memories.

In mid-April 1979, as a nerdy 13 year old, I sat in my bedroom in Sale, North England listening to the radio when a song called “Boys Keep Swinging” came on by an singer called David Bowie who I never heard of before. I instantly loved it and taped it next time it came on the radio via my […]