Skip to content

Neil Chandler's DB Blog

    • About Neil
    • Consultancy Services
    • Presentations
    • SQL Scripts
    • Video Tutorials
      • Why Has My Plan Changed. Top 7 Plan Stability Pitfalls and How To Avoid Them!
      • Oracle Database Stats – the easy way!
      • Oracle Database Statistics – When It’s Harder
      • Histograms Are Evil like Chocolate is Evil
      • Oracle Execution Plan Changes
      • Using JSON in Oracle
    • MASH Program
  • UKOUG

    UKOUG Conference 2012 Agenda Online

    Published by

    chandlerdba

    on

    2012-09-18

    Today the UK’s big Oracle User event has just lifted its skirts to show off its new frilly agenda, which can be found here. I have been a member of the UKOUG for well over a decade, and a Special Interest Group (SIG) Deputy Chairman for the last 5 or…

    Continue reading →: UKOUG Conference 2012 Agenda Online
  • Prevarication

    Outside Interests – not work!

    Published by

    chandlerdba

    on

    2012-08-15

    So, what do you do that isn’t work. Sure, you work hard in the office. You might even do work when you get home at night on your own “lab” setup – VM’s make that so easy these days. Even an old desktop can spin up a couple of VM’s…

    Continue reading →: Outside Interests – not work!
  • Uncategorized

    The Fear of Presenting

    Published by

    chandlerdba

    on

    2012-07-12

    I am deputy chairman of the UK Oracle User Group: Availability, Infrastructure and Management  (AIM) SIG. We arrange several groups per year where we look to get speakers to present on all manner of subject in relation to the remit of the SIG: Exadata, RAC, Partitioning, Grid Control, Managing DBA’s,…

    Continue reading →: The Fear of Presenting
  • Uncategorized

    Complex Passwords

    Published by

    chandlerdba

    on

    2012-06-22

    Increasing numbers of Yahoo mail passwords appear to have been compromised; I don’t use Yahoo [although in a historically stupid move, I have multiple email addresses from multiple providers including hotmail, gmail, my ISP and my own domain ]. Anyway, I have been getting an increasing number of spam emails…

    Continue reading →: Complex Passwords
  • Administration, Backups, Datapump, Problem Solving

    Problem solving with DBMS_DATAPUMP

    Published by

    chandlerdba

    on

    2012-04-04

    Yesterday I had a problem… I noticed that one of our overnight jobs was failing. The job in question is an ad-hoc tidy-up job, ran as needed when a performance metric for a specific query indicates that we’re going to be in trouble soon. So, what was the problem? I…

    Continue reading →: Problem solving with DBMS_DATAPUMP
  • Prevarication

    Oh my God, it’s full of stars

    Published by

    chandlerdba

    on

    2012-03-30

    About 1,000,000,000 of them in this amazing composite photograph of the Milky Way. Taking 10 years to make and using 2 telescopes (to get a view from North and South hemispheres) it combines the UKIDSS/GPS sky survey acquired by the UK Infrared Telescope in Hawaii with the VVV survey data…

    Continue reading →: Oh my God, it’s full of stars
  • Management

    Why ITIL CAB’s do not work as expected

    Published by

    chandlerdba

    on

    2012-03-29

    ITIL (Information Technology Infrastructure Library) does work. It works very well and is becoming more and more widely adopted, but does not always work the way that management thinks it works. The basic premise of ITIL is to put structure and process around the business of running IT. It is…

    Continue reading →: Why ITIL CAB’s do not work as expected
  • Administration, Management, Programming

    Exposing the Oracle Alert Log to SQL

    Published by

    chandlerdba

    on

    2012-03-26

    I’ve been spending some time working in Apex recently, building a small app to draw together the monitoring of application and infrastructure components into a single easy-to-visualise tool. As part of that, I wanted to be able to read and report on the alert log. Traditionally, that would have meant…

    Continue reading →: Exposing the Oracle Alert Log to SQL
  • Administration, Unix

    DROP DATABASE command

    Published by

    chandlerdba

    on

    2012-02-14

    I have been DBA-ing for a while now, and I today I used a “new” command which I have never used in the previous 20+ years I have worked with Oracle: DROP DATABASE. It’s amazing what you miss sometimes! So, what does it do? As the name implies, it drops…

    Continue reading →: DROP DATABASE command
  • Migration, Performance and Tuning, Problem Solving, SAN

    SAN Migration: When modern SANs “Fail”

    Published by

    chandlerdba

    on

    2012-01-13

    … or at least, when they don’t behave like you were expecting them to. I recently performed a major migration of a dozen missions critical Oracle and SQL Server systems from a pair of old EMC CX700’s to 2 brand new shiny HP XP 20000’s. This blog post is intended…

    Continue reading →: SAN Migration: When modern SANs “Fail”
  • Management, Problem Solving, Programming

    SYSTIMESTAMP INTERVAL Processing

    Published by

    chandlerdba

    on

    2011-12-12

    …or how to calculate dates in Oracle. This is just a quick post to try to encourage the use of the INTERVAL function when adjusting (sys)timestamps (or dates). I thought this would be better expressed through a quick script with comments to show how using the traditional Oracle method of…

    Continue reading →: SYSTIMESTAMP INTERVAL Processing
  • UKOUG

    UKOUG 2011

    Published by

    chandlerdba

    on

    2011-12-07

    Well, I’m back at work today missing the excellent final day of the UKOUG 2011 (@UKOUG  #UKOUG2011), but frankly I’m worn out. After watching some of the most fantastic presentations by the likes of Doug Burns, Jonathan Lewis, Greg Rahn, Tanel Poder and many others**, my brain is full. I…

    Continue reading →: UKOUG 2011
  • Management, Recruitment

    Industry Experience

    Published by

    chandlerdba

    on

    2011-12-01

    I don’t get it. Why do so many jobs and contracts seem to insist upon having experience in a particular industry when, in the overwhelming majority of cases, the specific industry in which we work has no bearing upon the nature of our work. I have worked across many industries,…

    Continue reading →: Industry Experience
  • Problem Solving, Programming

    Implicit Conversion Errors

    Published by

    chandlerdba

    on

    2011-11-28

    Summary: Implicit conversion is bad. It can lead to error, sorting issues, inability to use indexes and cardinality calculation problems causing performance issues. And it can be very hard to spot! A while ago, I failed over a database (as planned) to it’s Dataguard copy, and of course everything worked…

    Continue reading →: Implicit Conversion Errors
  • Performance and Tuning, Problem Solving

    The 10046 trace. Largely useless, isn’t it?

    Published by

    chandlerdba

    on

    2011-11-22

    The other night I was sat in the pub with some like-minded individuals discussing the relative merits of the 10046 trace (we Rock! in the pub, dudes!) and somebody asked me how often I has actually used it in anger? A well-respected DBA / Architect maintained it was a pretty…

    Continue reading →: The 10046 trace. Largely useless, isn’t it?
Previous Page Next Page
MASH Program Logo
Help for Public Speaking

subscribe

  • Mail

Recent posts

  • Fundamental Security Part Ten – Patching

    Fundamental Security Part Ten – Patching

  • What’s the SQL_ID?

    What’s the SQL_ID?

  • “Status” columns in Oracle

    “Status” columns in Oracle

  • Performance Report – REPORT_PERFHUB

    Performance Report – REPORT_PERFHUB

  • Performance: Clustering Data

    Performance: Clustering Data

  • Performance: Index Clustering Factor

    Performance: Index Clustering Factor

Create a website or blog at WordPress.com

Loading Comments...
  • Subscribe Subscribed
    Neil Chandler's DB Blog
    Join 134 other subscribers

    Have a WordPress.com account? Log in now.

  • Neil Chandler's DB Blog
    View site in Reader
    Manage subscriptionsSign upLog in
    Report this content
    Collapse this bar

Notifications