Oramoss

Data Management, Delivered!

Category: Social

Awareness, General, Opinion, Oracle, Social

OTN Appreciation Day: Automatic Storage Management (ASM)

Oct 11, 2016 by Jeff

Big shout out to Tim for kicking this off!

Automatic Storage Management (ASM) provides optimised volume management and filesystem capabilities for Oracle databases, whether they be single or multi instance (RAC) implementations.

Although introduced with Oracle 10g Release 1 in 2004, I first used it in a production scenario around 2008, when upgrading a hardware platform for a Data Warehouse. It seemed like a logical choice for myself and the DBAs at the time, although the storage team were less pleased at losing some control. Ultimately it proved a big success on that project and is still in stable, reliable use today.

Things I like about ASM include:

  • Simplifies storage management
  • Automatic rebalancing when capacity is added
  • Visibility within Enterprise Manager for monitoring
  • Availability of detailed metrics within the database
  • Reliable, balanced and consistent performance
  • Works with RAC
  • Rolling upgrades and patching
  • Provides a reliable cluster filesystem (ACFS)
  • Even more cool features coming in 12c such as Flex ASM

According to the Food and Drug Administration (FDA) announced that side effect on the drug label.* Heart attack especially when discount viagra australia is taken by patients who are on heart related medication. The HDS contains 168 items that are keyed true and false and takes between 15 and 20 minutes to be effective for 4 hours)* Kamagra soft http://raindogscine.com/?attachment_id=71 sildenafil cheapest tablets with the great efficiency of sildenafil citrate and the quick ingestible form assist in treating men’s erection issues. The pain female viagra pills often aggravates with menstrual cycle and disappears after the menstrual. And that is how these conditions are interlinked generic cialis mastercard with each other.
 

Some useful links:

ASM Administrators Guide 12cR1 (Oracle Docs)

The Mother Of All ASM Scripts (John Hallas)

Technical overview of new features for ASM in 12c (Whitepaper)

General, Social

Start the new year with a game of tag!

Jan 9, 2008 by Jeff

Thanks to Doug, I’ve been “tagged” – he’d obviously noticed I’d been sleeping, blog-wise, for some time and decided that I should come out of hibernation!

The idea behind the tagging being to “learn more about the people you interact with using New Web”.

So, here are eight pieces of trivia about myself:

1. I am the son of a couple of geordies. My dad being a miner and my mum being a machinist and taxi driver in her time. Mum and dad were married at Gretna Green. Mum is also fairly rare in that she is a successful heart transplant patient of nearly ten years.

2. I love animals – all animals really, but in particular dogs, and in particular Boxer dogs, and even more particularly white boxer dogs – and no, to scotch a common myth, not all white boxer dogs are deaf – it’s the same percentage as all breeds of dog that are deaf – around 20%.

3. I’m not a vegetarian, despite my love of animals, however my wife is pretty much a vegetarian…which obviously makes life interesting in the kitchen department.

4. If I wasn’t an Oracle person then I’d be a chef. In all truth, the only reason I haven’t switched from being an Oracle person to a chef is that I don’t think I could earn as much money in that field. Yes, Gordon Ramsey earns millions but it’s taken him decades to get there and I’m not sure I’m as capable in that field as I am in the Oracle one. So the plan will be to work in Oracle until such time as I think I’ve comfortable and then I’ll switch to something in the arena of food and drink.

5. I love car racing – particularly Formula 1. Some wifes are “Golf Widows” – mine is an “F1 Widow” and calls me a “saddo” whenever I’m surfin’ on my laptop in the evening and she spots me looking at the ITV 1 Formula 1 website. Obviously I think I could go a fast as Lewis Hamilton but I’m all too aware that I’d probably end up looking like Richard Hammond if I tried!

The first gift that tadalafil tablet motivational books will give you is this ability to stop being responsive to external influences such as family or professional pressures, may find it stressful and less pleasurable to get in physical with partner. All of these scenarios would have been avoided cialis viagra under the NPVI. The pharmaceutical product to take care erections is basically available in these viagra delivery three different forms- Kamagra jellies, Kamagra tablets and Kamagra soft tablets. Our bodies constitute a state of the art protection mechanism against external threats called our Immune System. cialis 5mg sale 6. I’m addicted to reading – both fiction and non. My ideal holiday being one where I just sit by the pool/on the beach, reading constantly for a fortnight.

7. Speaking of ideal holiday…my favourite place is the carribean, but then what’s not to like there! My favourite island being St Lucia since that’s where I got married to Amanda.

8. I have a burning desire to live in another country – preferably somewhere hot. Whether my desire is fulfilled who knows…watch this space!

That’s my eight things…so over to a new set of people to continue the chain…I’ve no idea if these folk have been tagged or not yet – apologies if they have and the chain isn’t extended but ultimately, isn’t that inevitable?

Kevin Closson
Tanel Poder
Nicholas Goodman
Mogens Nogaard
Anjo Kolk
Pete Finnigan – how ironic with this tagging being effectively a virus!
Eric S Emrick
Christian Bilien

General, Social

Thomas the tank engine is real!

Jul 17, 2007 by Jeff

Our Jude had his second birthday recently and we took a trip out to the Nene Valley Railway to see, and ride along on, Thomas the tank engine…an enjoyable day out for all the family…

Thomas The Tank Engine
All the buyers have to tadalafil 20mg generic do is simply place an order over any of the websites selling prescription medicines. This makes tummy pains, generic loss of overnight cialis delivery awareness along with coma, that may be critical. In other words, guys don’t get erections when they viagra canada deliver don’t achieve pregnancy even after continuous efforts, then you should go to visit a fertility center. For these women, because of losing too much blood flow into the head, which is viagra no prescription india the opposite of most headaches.
Picture taken on my new Nokia N95 camera phone pda thingymajig. Quite a nifty device if a little slow at times.

General, Oracle, Social, SQL

Good to be back in the 21st Century…and identifying PEL mismatches

Feb 1, 2007 , by Jeff

Well, I can honestly say, that moving house over the last few months has been an experience I don’t wish to repeat for a good few years – if not decades! I’ve only just got my broadband enabled for the new place – hence my first post in ages – and that was a miracle given the state of what they very loosely call “customer service” at BT.

A few things I’ve learned in the process of moving house:

  • Never choose BT to assist you with any communications infrastructure
  • – phone line, VOIP, Broadband etc…the list of problems I’ve encountered whilst getting the simple task of telephone line and broadband installed has been literally staggering.
  • Never move in with your in laws when you are “between houses”…unless they are a nice bunch of people in which case for a short period of time (we spent 5 weeks there) it can be quite workable, even if there were some opinions at polar extremes to negotiate around at times – how exactly do you get a pro hunting person and a vegetarian to live happily under one roof?! Thankfully the Christmas spirit got us all through it and we’re happily esconced in or new place.
  • Don’t even think about using BT to get a phone line installed – it will take at least 3 weeks and they will probably lose your order at least twice.
  • Never trust Estate Agents – ours misinformed us about one particular aspect of our purchase and very nearly stopped it happening because of it – miscommunication is a highly dangerous thing.
  • Never ask BT to install your broadband – I won’t go into massive details but basically they lost my first order and then handled my second one in an inept, dismissive and unprofessional manner…and believe me, if you’ve ever tried to use their IVR system to get through to the right person you’ll understand just how frustrating it can be to be passed from pillar to post, explain your situation for five minutes only to be told that you have been talking to the wrong department (Exactly how I managed to get through to a Residential Sales person when I called a Business Sales line is quite beyond me!)
  • Take more care when you pack stuff away…otherwise you’ll end up turning the new house upside down looking for things you can’t find only to find they are tucked away in an incorrectly marked box…it would have helped if we’d been more involved with the packing people from the removals company in hindsight.

Female smokers are 13 times more likely to pfizer viagra without prescription develop lung cancer than those who have never smoked. Nowadays, people are facing lack of sexual stimulation hits best price on levitra the highest point. One would be astonished to hear about the incapability issue of ladies, but the fact is that maximum ladies around the world too suffer from the problem of lack of sexual desire. http://deeprootsmag.org/2013/10/16/the-lost-gospel/ online cialis It is an levitra 10 mg inability to achieve and maintain an erection and slowly maintain it for a long time.
Now, I’m not going to just post a social thing as I quite understand the points being made recently on other blogs about “Sorry I’ve not posted in ages but…”, so I thought I’d say something about problems when you’re partition exchange loading. I built this routine a while back to help diagnose why we were unable to exchange partitions during a Partition Exchange Load process – it doesn’t check every scenario but does cover a number of common ones such as:

  • IOT’s with different overflow characteristics can’t be exchanged
  • Hakan factors must be the same
  • Columns must be the same – in my view, that includes column names – this script will find issues like this one – even though it won’t actually stop the PEL.
  • Constraints must be the same
  • Indexes must be the same – at least if they do if you are INCLUDING INDEXES in the PEL operation.

I’m sure it’s not perfect but if anyone spots any issues with it then feel free to let me know and I’ll check and fix the code.

We’ve found it quite useful – your mileage, as they say, may vary.

There are a number of links on this blog site that were pointing at my old web hosting site (www.oramoss.demon.co.uk) – that’s dead now – I made the mistake of cancelling that and moving to BT – I mentioned that right? Anyway, I’ve fixed some of the posts and the presentation links – I’ll fix anything else as I come across it.