I had the opportunity to attend Delphix‘s Company Kick Off last week in San Francisco. This was my first time at an event of this nature and it was incredibly successful. As Delphix had just promoted Adam Bowen and me to the Office of CTO, along with promoting Eric Schrock to the CTO position, I was in an enviable position, but not just because of the role (more...)
So you have decided that In-Memory option could be great for you and now you want to implement this option for your critical production database.
But in your code (more...)
So after following my previous notes on installing ASM into Azure, i repeated everything but using premium (SSD) disks and all appeared to be well - until that is i did a data pump load into it and put some stress on the system - then (and this was consistently every time) this happened....
ORA-00354: corrupt redo log block header
ORA-00353: log corruption near block 196020 change 378858 time 02/23/2017 23:54:17
ORA-00312: online log 2 (more...)
One should feel really sorry about anyone who will rely on filtering and making a decision based on bad, bad data. It is going to be a bad decision.
Advanced Index Compression
It doesn’t take a rocket scientist to know that even if you have incredibly stringent controls on user authentication, user authorisation etc, that wont save you if your data on disk is not encrypted. All you need is an errant tape, a missing disk, a misplaced flash stick…and kersplat, someone has a copy of your datafiles from your Oracle database.
Data at rest should be encrypted, but that often meant taking applications offline to (more...)
These instructions show how to create a Centos 7 container on Proxmox running JupyterHub.
Note – the instructions are just a guide and for use on my environment – you may need/wish to adjust for your own environment as necessary.
root@billy:~# pveversion pve-manager/4.4-12/e71b7a74 (running kernel: 4.4.40-1-pve)
The version of the notebook server is 4.4.1 Python 3.4.5 (default, Nov 9 2016, 16:24:59) [GCC 4.8.5 20150623 (Red Hat (more...)
After a lot of searching and testing I have finally decided to put the ageing Andreas09 theme a rest and try a new one. It has been nagging me for years that the representation of the blog is more like the early 2000s than 201x. Or was it late 1990s? Anyway, out with the old, in with the new.
The biggest problem I have with finding suitable templates is a) that I have insufficient talent in the fine (more...)
What do you do when
- you’re an Australian,
- you’re at Oracle Headquarters, 13,000 kms from home
- you bump into someone whilst grabbing a coffee
Well…naturally, you lure them over with a packet of our famous Australian chocolate biscuits, grab a camera and have a chat !
Maria Colgan and I chew the fat over why you should upgrade to Oracle Database 12c (including Release 2)
There are a lot of people and companies starting to push the same old myth regarding the death of the database administrator role in companies. On the Oracle side, it started with release Oracle 7 and now is proposed with the introduction of cloud. Hopefully my post will help ease the mind of those out there with concerns. There are a number of OBVIOUS reasons this is simply (more...)
Obviously nobody could beat Tim to getting the comprehensive installation instructions out first, but here are my notes for installing it on a proxmox container environment which is what I use as my research platform. Some of the calls used are from or based on Tim’s prior 12cR1 installation article – thanks Tim.
NOTE – this post is just a guide and is based on my environment – you will likely need to make changes to (more...)
Yes and now Oracle 12.2 is available (Linux x86_64) for download from OTN.
Let’s start with Installation and Setup ….
In a oracle data guard environment Log Network Server (LNS) process transports the redo from the primary to the standby site. The behavior of LNS process is different from SYNC and ASYNC mode replication. In ASYNC mode transport, LNS read the redo from log buffer and hand over it to the RFS process in the target site. It is not necessary the redo is always available in the buffer cache. If there is not enough (more...)
Since OpenWorld 2016 when we first saw some of the cool features in Oracle Database 12c Release 2, many IT professionals out there have been exploring the release via our various cloud offerings, but if your organization has not yet embraced the cloud, then March 2017 is a great month for you ! Because you can now download the latest and greatest release of our database from the usual downloads page, and run it on (more...)
"The most important reason for going from one place to another is to see what's in between." -- Norton Juster, The Phantom Tollbooth
Recently in an Oracle forum a question resurfaced regarding enabling row movement for tables. The posted question, from five years ago, asked if row movement was safe and if there could be any ‘undesired impact on application data’. The answer to the first part of that question is ‘yes’ (it’s safe (more...)
When sifting through a sql_trace file from Oracle version 12.2, I noticed a new wait event: ‘PGA memory operation’:
WAIT #0x7ff225353470: nam='PGA memory operation' ela= 16 p1=131072 p2=0 p3=0 obj#=484 tim=15648003957
The current documentation has no description for it. Let’s see what V$EVENT_NAME says:
SQL> select event#, name, parameter1, parameter2, parameter3, wait_class 2 from v$event_name where name = 'PGA memory operation'; EVENT# NAME PARAMETER1 PARAMETER2 PARAMETER3 WAIT_CLASS ------ ------------------------------------- ---------- ---------- ---------- --------------- 524 (more...)
No, this isn’t a title for a future Star Wars movie, but our own future, foreseen by me, (as well as many others) from experience, research and discussions everyday.
No, it’s not this dark and menacing…no sith lords.
We know who the main players in the current cloud arena are and how much they hold of the cloud market.
Many are betting that they can make a dent (more...)