Saturday 22 November 2008

Cheer leading for creative writers

onwards and upwards

After over five varied and enjoyable years working for Siebel (and then Oracle) in Expert Services, I am changing jobs. However, I will continue to work for Oracle as part of the group responsible for 'Social CRM'.

Although this was a internal transfer, my interview process was quite unusual. Instead of being forced to massage my CV into Microsoft Word format and send an email attachment to a faceless recruitment agency, I was able to publish my CV using Google Docs and the whole interview process was conducted by telephone.

A colleague had already thoughtfully pointed my prospective manager to a blog entry that was loosely relevant and he also was keen to review more technical oriented content on my Siebel related blog.

As an aside, you can only imagine the feelings and thoughts that flooded into my brain when my colleague uttered the immortal words: 'Hey Andy, I've given your <prospective new manager> a pointer to a couple of articles on your blog.'

The role will mean a few changes for me:

  • I will now revert to having difficulty explaining to friends and relatives what I actually do.
  • I will probably spend less time in airport lounges and more time with my family. Norma has already expressed grave reservations about this element of my career change.
  • My manager will be in a different continent and timezone.
  • I will be contributing to a corporate blog for the first time which will necessitate a slight shift in subject matter, terminology and slightly less of my dry, cynical, off the wall, British sense of humour although I do intend to maintain this personal blog.

I am currently tidying up a few loose ends in Expert Services and embarking on a emotional, sell-out, European farewell tour to all my favourite Siebel customers so I won't actually be starting my new role until mid-October but it will be an exciting change for me and I'm really looking forward to it.

UKOUG agenda

Monday 3 December Get up very early and drive to Birmingham. 09:40-10:30 '30 years at Oracle' - Tom Kyte. I own a couple of Kyte's excellent books and various sources report he is an excellent speaker. 10:40-11:00 Visit a few stands. A quick game of 'spot the colleague' and ask 27 different companies 'How can XYZ help me grow my business ?' 11:15-12:00 'Siebel Keynote' - David Mills. Possible sales and marketing fluff alert. Need to sit at the back adjacent to an aisle to allow a potential rapid escape to 'Oracle RAC versus Oracle Data Guard - which should I use for Disaster Recovery and which should I use for High Availability ?'. 12:25-13:20 'Under the Covers of Oracle BI Suite Enterprise Edition Plus' - Mick Bull/Lisa Dobson. I would like to learn more about Oracle's Business Intelligence tools. Plus I have an innate weakness for presentations titled 'Under The Covers...' 13:15-14:15 'TimesTen: Anatomy of an In-Memory Database' - Chris Jenkins (Oracle). Curious to hear more about this technology. 14:15-15:15 'Remote Hand Held SFA solutions need housekeeping - Ian Keleher/Nicola Burrows (Gallaher). A verbose and hardly compelling title but I have worked with this customer so I might get a mention on the Credits slide. 15:20-16:25 'Oracle 10g: RAC Tuning Tips' - Joel Goodman 16:45-17:30 'Siebel Marketing and Marketing Analytics' - Ben Wales 17:35-18:35 '11g new features for DBAs' - Tom Kyte. This has better be worth it. I am missing 'Siebel Networking', free beer and prawn volavons for this ! Back to hotel to dump marketing literature, USB memory sticks and complimentary gifts from Quest Software. Shower, brush teeth, apply deodorant and slip into something more comfortable. Head over to the Pitcher and Piano to gatecrash the Oracle bloggers meetup.

membership form for BAAG

I own up. It's a fair cop. It is 27 years and 5 months since my last confession. Since then, I have sinned, Holy Father. In fact, I have committed an absolutely heinous crime. Please forgive me for I have submitted multiple random guesses. May the high priests (and priestesses) of the BAAG movement, please have mercy on my wretched soul. Recently, I have been guilty of supporting and even proposing a multitude of 'any guesses', all of which were proposed as possible solutions to solve a critical system problem on a production system:
  1. I failed to cough and splutter in an effort to stifle my laughter when a manager suggested that 500 European users adopted shift working to clear the backlog.
  2. I didn't shout down a ludicrous proposal to reboot the Siebel Enterprise every 4 hours in order to maintain some level of service.
  3. I wrote on a whiteboard that consideration should be given to reinstating the previous version of the application even though this in itself was risky, time-consuming and unlikely to address the root cause.
  4. I even proposed patching to Oracle 10.2.0.3 with no supporting evidence whatsoever.
  5. I shuffled nervously and blushed when the customer asked 'Who do we escalate to when you fail to fix this problem ?'
  6. I watched in silence as the SAN man was stood against a wall and pelted with questions as senior management all pointed fingers in his direction.
  7. I failed to stand up for righteousness and technical purity as runaway, rogue sessions were maliciously and arbitrarily terminated by an Oracle DBA.
  8. I failed to suggest running a trivial SQL to determine index fragmentation and stood by as 74 indexes were needlessly reorganised.
  9. I watched helplessly as a systems administrator claimed the problem was 'definitely in the underlying disk I/O subsystem' simply because 8,000 operations a second were being performed.
  10. I failed to raise my eyes skywards and embark on a spontaneous two hour training session with a DBA who claimed the 'buffer cache hit ratio was fine' and the problems only started once users were allowed onto the system.
My only defence is that all of the above 'any guesses' created enough of a diversionary smokescreen to buy me enough time, alone in a darkened room, to analyze multiple Statspack reports, reproduce the majority of the problems in SQL*Plus and then prove the behaviour was improved when statistics on empty tables were dropped and two additional indexes created. This lucky 'guess' miraculously restored performance and stability. So you see, 'any guess' is not always such a bad strategy, after all.

go faster stripes

This Bluehost powered blog is now FastCGI enabled. You may find the site faster but, then again, hyperlinks may return completely random articles. You will probably struggle to tell the difference. Which reminds me of a funny story... I am currently working in the North East on an 'escalation'. An 'escalation' is characterised by frequent, lengthy conference calls with bi-hourly status updates, the phrases 'high-profile', 'alternative technical solutions', 'severe degradation', 'impacting the bottom line', 'CIO visibility', 'options for the weekend' and the perennial favourite: 'any progress yet ?' Thus far I have managed to resist the temptation to reply: 'No. Sorry. No progress yet because I have been in meetings and conference calls since I arrived onsite and I haven't even been offered a coffee yet, let alone actually touched a keyboard.' Anyway, I digress. All of these factors combine for a relatively stressful working environment. This lunchtime, during a scheduled outage of 15 minutes to stop and restart Oracle to change a static 9i parameter (optimizer_index_cost_adj from 1 to 10 for the technically minded), three highly skilled, overpaid technical people and a project manager were overseeing this vital, complicated and potentially life saving modification. The application servers were shutdown so those pesky users could no longer use the system. We looked wistfully at a AIX 'topas' screen showing 'CPU: 0%, User: 0%, System: 0%, Disk 0%, Wait: 0%' and took a screenshot for posterity. We paused to savour the moment. There was a brief moment of quiet contemplation and tranquility. Then the DBA piped up: 'Shall we wait for 1 minute ?' The DBA then fired up Enterprise Manager. We all doubled checked the password credentials and the target database. We held an impromptu video conference call to get approval to press the 'Login' button. We doubled checked that password for SYS was secure, non-intuitive and, err, different for the DEV, TEST, UAT, STAGE, QA, TRAIN and PRODUCTION environments. Of course, it was. What sort of organisation responsible for Oracle outsourcing would do anything different ? The moment had finally arrived. Hours of detailed analysis. Hours of pouring over Statspack Level 7 reports and query plans. Hours of talking to the mysterious 'SAN Man'. Hours of scouring SupportWeb and Metalink. Hours of investigating helpful (but ultimately unhelpful) suggestions from people who should not have been involved. Hours of going deep down into dark rat holes. Hours of early starts, late finishes, no coffee and plenty of red herrings. The time had finally come to change the parameter. We stand, poised, on the verge of greatness. I broke the tense silence: 'OK. The Oracle parameter we need to change governs the behaviour of the Oracle optimizer. We are seeing an expensive 'INDEX FULL SCAN' on the customer table which generates million of logical I/O's, physical disk reads and brings the database server to its knees. We are trying to encourage Oracle to use 'INDEX RANGE SCAN' on the driving, intersection table instead which is 300 times more efficient.' 'We are unable to add hints. We are unable to modify the SQL generated by the black box so we are going to change a key Oracle setting for CBO. I have the Change Control in my hands. We are actually going to change an Oracle parameter.' A hush descends. The DBA observes another minute silence and expectantly clicks 'Instance - Configuration'. With a little prompting, he clicks 'SPFile' instead of 'Running'. I continue: 'The parameter we are about to change is called 'Go' 'Underscore' 'Faster'. The DBA then scrolls down to the 'G' section. There is a period of a superlative 3 second silence followed by 'Sorry - what did you say: 'Go' 'Underscore' 'Fas...' followed by three people (poor project manager) laughing uncontrollably. The door opens: 'Any progress yet ?'

June spawned a monster

Graham started a technical blog and Andy used the Drupal theme on his new WordPress blog. I felt left out so I decided to start a technical blog on Drupal with a WordPress theme.
Page:  1 2 3 … 5 Next →