In my last post, I had presumed there is a bug since I discovered an empty clusterware alert log in its conventional location i.e. $ORACLE_HOME/log/<hostname>in 188.8.131.52 standard cluster.
[grid@host01 ~]$ crsctl query crs activeversion; Oracle Clusterware active version on the cluster is [184.108.40.206.0] [root@host01 host01]# ls -l /u01/app/12.1.0/grid/log/host01/alerthost01.log -rw-rw-r– 1 grid oinstall 0 Jun 15 14:10 /u01/app/12.1.0/grid/log/host01/alerthost01. (more...)
I registered myself for Oracle OpenWorld and I have my hotel reserved and my flights ticketed.
I think it has been over 12 years – probably more like 15 years – since I went to OpenWorld. I went at least once between December 1994 and November 2003 when I still lived in Florida and was working on Oracle databases. But since I moved from Florida I do not believe that I have been to the conference. (more...)
Post itself is divided into two parts:
- Oracle Linux installation (points 1 to 12)
- Vagrant box configuration (points 13 to 16)
Part 1 – Oracle Linux installation
1. Create a new Virtual Machine - machine name will be used later to create Vagrant (more...)
Can you make your SQL code easier to understand without adding comments. Can it be self-documenting ? Can you do your bit to make sure your code is easily comprehended by the next person who has to maintain your code ? Yes you can. Learn how at my next quick tip at https://youtu.be/bfaFT9doqCg
Is this a license to never add comments in and around your SQL code ? Of course not. There’s a great (more...)
RAM is the new disk, at least in the In-Memory computing world.
No, I am not talking about Flash here, but Random Access Memory – RAM as in SDRAM. I’m by far not the first one to say it. Jim Gray wrote this in 2006: “Tape is dead, disk is tape, flash is disk, RAM locality is king” (presentation)
Also, I’m not going to talk about how RAM is faster than disk (everybody knows that), (more...)
So you get a call at the weekend.....
"we need you to run some data update against our database to complete a migration task"
This is the final task in a very long process and one that has taken months to verify all the steps and complete.
Problem 1 is that this is SQL Server (and i'm no SQL Server expert)
(before you oracle guys stop reading, don't this is useful for you too)
Here are links to the presentations for the OTN Latin America Tour 2015.
Sometimes you do what you have to do. So here I confess doing something I usually avoid: forcing an Execution Plan (which is not the same as using a more conventional method for Plan stability).
This is a case on 220.127.116.11.0 base release where the application vendor sets the optimizer to 9i, and tweaks other CBO parameters in questionable ways, then some queries produce suboptimal plans (as expected); and you are (more...)
RMOUG’s Quarterly education workshop was a great event today and I appreciate everyone who came out and those who spent time with their family and their user community doing fun geeky stuff.
There were a few things I promised folks, including access to my family coding slides so anyone can do this at home. Even though I’ve included the GPIO with breadboard configuration and code in the slides, please, PLEASE consider getting the Pibrella board (more...)
Sun of database technologies is shining through the cloud technology. Oracle, SQL Server, MySQL and various other databases are bringing forth some nifty offerings and this Log Buffer Edition covers some of them.
It’s interesting to watch the CBO evolving and see how an enhancement in one piece of code doesn’t necessarily echo through to all the other places it seems to fit. Here’s an example of an enhancement that spoiled (or, rather, made slightly more complicated) a little demonstration I had been running for about the last 15 years – but (in a fashion akin to another partitioning limitation) doesn’t always work in exactly the way (more...)
Yesterday i had an email from a developer asking me this:
"We're running an extract report and when we run it in plsql developer we get rows back immediately, however when we do a full extract of the entire dataset to a file it takes 2 hours - what's going on? "
(with the subtle hint of course that it is a database issue ant not something they've done wrong).
I first explained that getting (more...)
Mongostat is a nifty tool which comes out of the box with Mongodb which provides wealth of information in a nicely and familiar formatted way. If you have used vmstat, iostat etc on Linux; Mongostat should seem very familiar.
Originally published Jan 2013
Red Gate have asked me to write a few articles for their Oracle site, so I’ve sent them a short series on “traditional” compression in Oracle – which means I won’t be mentioning Exadata hybrid columnar compression (HCC a.k.a. EHCC). There will be five articles, published at the rate of one per week starting Tuesday (15th Jan). I’ll be supplying links for them as they are published.
Richard Foote did a series of informative posts on Index Compression which concludes that there is whole lot of positives about index compression, and very little negatives. But obviously one critical thing is choosing the right number of leading columns to compress. Is it just “take a guess?” . Luckily, Oracle has taken the guesswork out of it.
The ANALYZE command on an index can let you find the optimial compression count. (more...)
If you head on over to http://docs.oracle.com/en/database/ you’ll be both amazed and dismayed by the volume of documentation you can find about the database. If you’re a seasoned Oracle professional, then you probably dont think twice about finding PIVOT examples in Chapter 18 of the Data Warehousing guide
But for the novice, whether it be DBA or Developer, it can be a bit overwhelming. One resource that you might find a (more...)