Friday, January 26, 2007

UKOUG Oracle on Windows SIG

The next meeting of the UKOUG Oracle on Windows SIG will take place in the London area (venue to be confirmed) on Thursday, 22nd March.

At present we are working on putting the Agenda together so if anybody has a presentation or short talk they would like to give at this event then please let me know.

Below are a few notes made at previous meetings showing the subjects that delegates would like to see covered:

Performance Issues
- Windows settings (especially when migrating from windows 2000 to 2003)
- Looking at tuning apps on Oracle on Windows.

Differences between ‘upgrade’ and ‘migration’ on Windows platforms.

Windows Performance Manager
- How to use
- How to review logs

Which free tools are available
- How to use them

10g Installations
- Grid control
- Specifically on machines already running 9i, 8i

Differences between 32bit and 64 bit

MTS on windows (highly concurrent systems)

Tips and Tricks
- ‘Safe’ upgrades on windows
- What can go wrong and what to avoid

Configuration tips for Oracle on Windows
- Both Oracle DB’s and OS
- Windows tips for UNIX DBA’s

- Oradim
- Oracle Services
- Registry Settings
- Services for UNIX stuff on a Windows environment.


Backups and the Registry
- How to do it
- What to restore (virtual server stuff)

Interdependency of services
- Start/Stop routines, order in which to do it

Tuning Instance to use Very Large Memory
- eg 20GB RAM on server, instance won’t use more than 3GB

Documentation for Oracle 9i on Win 2003
- Not much on Metalink, docs mainly cover 8i on NT

Presentations by Oracle support reps
- Q & A sessions

Security on the Windows OS
- Best practise
- Hints and tips
- Access to Win DB

Oracle on Windows clustering (not RAC)

Different versions of Oracle on same server
- eg 8i, 9i and 10g
- compatibility

Hands on sessions
- Virtual Server

NAS/SAN issues
- Configuring NAS drives
- Environments
- Settings

DBMS and apps topics

Job scheduling/automating tasks

As usual, we have more delegates asking to see presentations than we have offering to give them. :-)
So, if you have anything you would like to share, whether it be a 45 minute presentation, or a shorter 'hints and tips' session then drop me a line.

Wednesday, January 17, 2007

Keyword Fun

I use StatCounter to monitor visitors to my Blog, and I have recently been using it to analyse the search terms people are using to arrive here.

As I’m busy planning some future articles on BI and DW tools and some more beginners guides, I thought it would be useful to see what people are searching for to make sure I can provide it if possible.

Most of it is pretty standard stuff, people searching for ‘Oracle Newbie’ or ‘Oracle Beginner’ that sort of thing. Some even go as far as searching for ‘Everything I need to know about Oracle’.

I’ve also had quite a few hits from people searching for information and resources for the OCP exams including the rather ambitious ‘What all subjects does the OCA exam include’ and ‘Oracle OCA answers’.

Then there are the more random searches, some not even Oracle related, such as ‘Speed Awareness Workshop Northamptonshire’ or the ‘Make my afternoon’ search which both ended up here!

But the reason I felt I needed to share this, was going through the stats and discovering that on January 15th, this blog was the Number 1 result for the person who used Google to search for ‘sippy cup for a newbie’.

I'm speechless.

Thursday, January 04, 2007

Better late than never…

A belated Happy New Year to everyone!

2006 was a year of change for me, following my move to SolStonePlus in April. So rather than look back, I want to look forward to 2007 and the things that I’d like to do this year.
(I also thought this might be a good idea after reading Mark’s post and seeing that staff appraisal time is coming up!)

So, some of the things I would like to do in 2007 (in no particular order!) are:

Complete my OCP certification. I passed my OCA exam in 2006, so now I just need to find time to go on the second course and fit in some study time.
Complete the BI Jigsaw. Over the last few months I’ve been looking at various different products in isolation, such as Oracle Warehouse Builder and XML Publisher. What I want to do now is step back and improve my knowledge of the set of BI products as a whole, see how they all fit together and work together to provide different solutions. It’s important for me to have a rounded view of business intelligence as a whole, rather than just becoming an expert on one particular product.
More technical blogging. To help me achieve the above goal, I plan to do a series of blogs based on my learning. Rather than in-depth technical posts on the intricate ‘how to’ stuff, I’d like to start with a series of posts on the products, what they are and what they do. A sort of ‘beginners guide to business intelligence’ if you like. I’ll be looking at things like BI Suite Enterprise Edition – what does it include and how is it different from BI Suite Standard Edition. After the introduction stuff I will then look at delving deeper for the next series of posts.

On a personal level, I tend not to make ‘Resolutions’ every year, but some of the things I will be aiming for in 2007 are:

Be more organised. I have so much clutter at home that I sometimes can’t find something I just had five minutes ago! I had a big sort out over the weekend and have thrown out so much stuff, you know the kinds of things you keep because ‘it may come in handy one day’. We’re still arguing about the box of things I have collected on dives – the stuff I refer to as ‘treasure’ but he has deemed ‘junk’. I’m still winning on this one for the time being….
Get round to launching my new website – it’s been in draft mode for ages now, I just need to get on with it.
The usual stuff – you know, drink less, keep off the cigarettes, get fitter, that sort of thing.

So here’s to a new and improved 2007!