Oracle VM Consulting
view counter

Database Feed

Oracle Database, Oracle 10g, Oracle 11g, Oracle XE, Oracle RAC, Oracle Instant Client, Oracle Data Guard and Oracle Exadata resources, news, and support articles.


I’ve been on holiday, walking in the Lake District, for a few days, so you haven’t seen much from me for a while (apart from a couple of post-dated items).

Now that I’m back I’ve got several hundred email messages, a couple of jobs, and a load of writing to catch up on, so you’re still not going to see much output. However, I have a of odds and ends that I’ve filed for later use, and I started tidying this list up a few weeks ago, so I thought I’d share the tidy bit with you – just to make sure you have some interesting reading over the next few days.

HP Service Manager and HP UCMDB Integration

HP Universal Configuration Management Database (HP uCMDB) software stores, controls, and manages software and infrastructure components along with associated relationships and dependencies. Integration between HP Service Manager (HPSM) and HP uCMDB enables to exchange Configuration Items (CIs) information between uCMDB and HPSM as uCMDB provides infrastructure visibility which shows how components are related for consistent and reliable delivery of IT and Business Services.

Difference between Select Any Dictionary and Select_Catalog_Role

When you want to give a user the privilege to select from data dictionary and dynamic performance views such as V$DATAFILE, you have two options:

grant select any dictionary to ;
grant select_catalog_role to ;

Diving into Databases

By dbi services, we are a few poeples passionate by diving.We take this opportunity to let you dive into the two databases lakes Oracle and SQL server and see their similarities and differences. For this first level of diving (named ODD), we will not going too deep and not have narcosis or
databases toxicity.As always, we'll start with a short briefing to present the environment and the different themes.Have a nice dive !

Systemstate Dump warning

Whilst investigating the latest of our many library cache contention problems on 11.2, I made the fatal mistake of relying on my previous experience combined with a standard Oracle Support note describing how to diagnose such problems.

OT: Norway

Having had one of my best conference experiences ever this year in the company of many good Norwegians, this weeks news saddened me and it must have come as a hell of a shock to the country as a whole, not just those involved. Their horror is difficult to imagine.

I really don't have adequate words, frankly.

At the same time, it inspired me to hear ...

Who Manages the Exadata Machine?

For organizations that just procured an Exadata machine, one of the big questions is bound to be about the group supporting it. Who should it be - the DBAs, Sys Admins, Network Admins, or some blend of multiple teams?

Watch and Wait

Over the last 6 months I’ve become aware of two (new to me) commands that have been very useful: watch and wait. If you are not already familiar with them then I recommend you have a read, have a play and wait patiently for the first opportunity to use them.

There is no point in quoting the man pages here, so I’ll just give quick examples.


In its simplest form: watch

For example:

‘log file sync’ and ‘log file parallel write’ – part 2

I mentioned at the very end of part 1 that ‘log file parallel write’ wait times are in fact unlikely to be close to ‘log file sync’ wait times.  There have been many questions and blog entries on this topic over the years.  One common starting point seems to be Metalink article 34592.1.  Another good article is this one:

‘Log file sync’ and ‘log file parallel write’ – part 1

This is the first part of a three part blog about LGWR. If you want a thorough understanding of LGWR, ‘log file sync’, and ‘log file parallel write’ read on. If you are an Oak Table member you might want to skip to the more advanced topics in parts 2 and 3 (unless you want to point out errors and omissions of course :-) ).

view counter