I arrived at the Gresham Hotel, registered and went straight down to the first session of the day…
First up was Maria Colgan presenting, “What to Expect from Oracle Database 12c”, a quick romp through the cool features in Oracle 12c (12.1 and 12.2). The room was full so I had to listen form the corridor, with my head occasionally popping round the door to see the screen. Maria’s sessions are always great (more...)
There is something about early starts that get me so nervous I can’t sleep properly. As a result I was awake before my 05:00 alarm, which gave me plenty of time to get ready. That was good because I hadn’t packed up laptop bag, which was also acting as my overnight bag.
The taxi ride to the airport was pretty standard, but I did have a conversation about Roza Bal in Kashmir.
I only had hand (more...)
A question came up on the OTN database forum a little while ago about a very simple query that was taking different execution paths on two databases with the same table and index definitions and similar data. In one database the plan used the “index full scan (min/max)” operation while the other database used a brute force “index fast full scan” operation.
In most circumstances the starting point to address a question like this is (more...)
In moving some more code from an 11gR2 database to a 12cR2 database, I found another change where a piece of code that works in 11gR2 doesn’t compile in 12cR2.
In this instance a view was being created with a projected date column which used the ANSI DATE syntax. Here is a simplified test script:
CREATE OR REPLACE VIEW test1 AS
SELECT date '0000-01-01' date_col
DROP VIEW test
CREATE OR REPLACE (more...)
The best part of playing poker is misreading the hand and won.
Well, today this applied to help troubleshoot a Goldengate issue.
Granted it might not be the root cause but it did solve the issue for the time being.
1. Goldengate version 10.4
2. mgr process started with uid vs username
$ id -a
uid=19208(ggsuser) gid=1601(dba) groups=1601(dba)
$ ps -ef|grep ./mgr
19208 18576 1 0 16:05 ? 00:00:00 ./mgr
3. dirdat is (more...)
I’m working on upgrading a very buggy unpatched 22.214.171.124 Oracle database to a fully patched 126.96.36.199 version. I’m using Delphix to support the upgrade and it has been a big help so far. This is on the HP-UX 11.31 Itanium platform.
The great thing about using Delphix to support an upgrade is that my very first pass through the upgrade scripts was with a full-sized clone of production. In (more...)
Since its release in 10gR1, Oracle have consistently added neat functionality to the “new” scheduler with every database release. Yes, I still call it the new scheduler and you would be surprised how many people still insist on using DBMS_JOB rather than switching to DBMS_SCHEDULER.
Oracle Database 12c Release 2 (12.2) is no exception to this pattern, as once again we have some new stuff to play with.
When I open Oracle documentation to look for something, people usually raise their eyebrows (almost as they do when I open sqlplus). Most of them simply say: “What do you need the documentation for? Just open google and search”. Even though googling stuff usually works, I actually like the documentation (in some aspects at least). … Continue reading Working with Oracle Documentation
One of the difficulties with trouble-shooting is that’s it very easy to overlook, or forget to go hunting for, the little details that turn a puzzle into a simple problem. Here’s an example showing how you can read a bit of an AWR report and think you’ve found an unpleasant anomaly. I’ve created a little model and taken a couple of AWR snapshots a few seconds apart so the numbers involved are going to be (more...)
MobaXterm 10.2 has just been released.
The downloads and changelog are in the usual places.
The previous version (10.0) was pulled as it was getting false positives with some AV software. I’m glad to report this one doesn’t get flagged and installs fine!
was first posted on March 21, 2017 at 11:36 am.
©2012 "The ORACLE-BASE Blog
". Use of this feed is for personal (more...)
Four years ago I wrote about a little volunteer project that my partner did. A small association that provided outdoor experiences and facilities for kids with physical impairments needed a system to record member and volunteer details, plus a few other bits and pieces. We built an Apex solution running on XE. This week, they became part of a larger government initiative, and thus their Apex application was no longer needed and (more...)
I did not know this.
Is there a way to control Auto_Purge Frequency done by the MMON ? (Doc ID 1446242.1)
The automatic purge cycle is designed as follows.
(1) The first actual purge action will be 2 days after instance startup time
(2) The next automatic purge actions following this first purge is done once every 7 days
If you like to purge more often, then it will need to be done manually.
Die neue DOAG Webseite ist Online.
$ egrep -n '^Corrupt block relative dba| ^Reread of blocknum' alert.log| tail -50
124974:Corrupt block relative dba: 0x04c7d3be (file 12, block 312452)
124983:Reread of blocknum=312452, file=+DATA/db/datafile/db_data03.329.456465464. found valid data
124974|124983 are line number from alert.log
On reread found valid data, there is no need to proceed further since block has been validated to be . Typically, this occurs when there is a fractured block.
If you have doubts:
RMAN> backup validate check (more...)
While at Delphix, we did a lot of storage benchmarking. The I/O response times of Delphix depends, as one would logically imagine, heavily on the underlying disks. Sure Delphix can cache a lot ( with 1 TB of ram and 3x compression that’s 3TB and that 3TB can be shared by 10 or a 100 copies being the equivalent to 30TB or 300TB of databases) but really there will always be important I/O coming (more...)