There’s a somewhat sour discussion going on based attached to the video at https://www.youtube.com/watch?v=jZW-uLb52xk
Whether you agree or disagree with the video or the comments, or (sadly) the animosity in them, it does lead to an interesting bit of investigation when it comes to data types with arbitrary precision, which was stumbled upon by a friend at work.
Let’s start with a simple comparison between two dates. In this case, I’ve just (more...)
In general it is known that Function-Based Indexes (FBIs) can no longer be used by the optimizer if the expression contains literals and CURSOR_SHARING = FORCE / SIMILAR (deprecated) turns those literals into bind variables. Jonathan Lewis described the issue quite a while ago here
in detail.In a recent OTN thread
this issue was raised again, but to my surprise when I played around with a test case that mimicked the OP's problem query (more...)
Sorry for the long title!
I had a question during my session about “advanced RAC programming features” during the last Paris Oracle Meetup about the MAA connection string. I showed an example taken from the Appication Continuity White Paper (http://www.oracle.com/technetwork/database/options/clustering/application-continuity-wp-12c-1966213.pdf). Someone from the audience asked me if I had experienced any problems with it, such as very slow connection timeouts. I haven’t, but wanted to double-check anyway. This is a (more...)
EMCLI is not certified or supported on Mac OS X, but I wondered if it is possible to run on my new macbook. I searched metalink, googled and couldn’t found any useful information. I thought it should be easy because EMCLI is a java application certified to run almost all enterprise operating systems including HP-UX, AIX, Linux, Windows, Solaris, and we all remember “write once, run everywhere” slogan of Java. Unfortunately it wasn’t as easy (more...)
In this post, we’re going to perform a push button refresh of an Oracle Database, Application Express (APEX) installation, and Tomcat webserver.
“But Oracle Alchemist,” you’re probably thinking, “we know about that. You’ve told us about how Delphix can provision and refresh data.” And yes, you’d be right. But I wasn’t done yet.
We’re going to perform a refresh of an Oracle Database, APEX installation, and Tomcat running in Amazon Web Services, replicated from (more...)
Recently I came across “ORA-00353: log corruption near block change time” error.
Errors in file /oracle/app/diag/rdbms/test/test/trace/test_ms00_54284.trc (incident=1490189):
ORA-00353: log corruption near block change time
ORA-00353: log corruption near block 4631374 change 263470473806052 time 04/16/2015 06:53:16
ORA-00312: online log 43 thread 3: '+REDO02/test/onlinelog/group_43.258.875922665'
ORA-00312: online log 43 thread 3: '+REDO01/test/onlinelog/group_43.258.875922633'
Incident details in: /oracle/app/diag/rdbms/test/test/incident/incdir_1490189/test_ms00_54284_i1490189.trc
Thu Apr 16 08:14:42 2015
Sweep [inc]: completed
Thu Apr 16 08:14:55 2015
LOGMINER: WARNING: error (more...)
This book touches a myriad of new features of oracle database 12c relevant to DBA’s, developers and architects. It starts with new features as well as step by step detailed instructions of installation along with relevant screenshots followed by an introduction to EM Express. Next chapter covers new features related to upgrading to Oracle Database 12c and various methods to perform the upgrade. All the subsequent chapters explore a whole lot of new (more...)
If you have multiple MySQL slaves or complex topology, its difficult to remember what slaves are replicating from which master.
We can go to slave servers and check “show slave status” which list master host, but if we want to find out other way, we have can run “show slave hosts” from master.
This will list down all the slaves that are getting replicated from this master.
Only problem I faced was, “show slave (more...)
I’ve run into a few customers recently who have had problems with their ASM rebalance operations running too slowly. Surprisingly, there were some simple concepts being overlooked – and once these were understood, the rebalance times were dramatically improved. For that reason, I’m documenting the solutions here… I hope that somebody, somewhere benefits…
1. Don’t Overbalance
Every time you run an ALTER DISKGROUP <NAME> REBALANCE operation you initiate a large amount of I/O workload as (more...)
<.. The tech15 committee and my role
<…. Who plans the Tech15 content
The call for Papers for UKOUG Tech15 has gone out. This is how most of the content for a large conference is sourced, by asking the community to submit abstracts for consideration. With smaller conferences and user group meetings the organisers can often get enough talks by
hassling asking people they know.
Firstly, I would encourage anyone who has considered talking at (more...)
One very useful aspect of Golden Gate is to allow the manipulation of data between the source and the destinations.
One recent problem that I encountered was to alter the data differently for inserts than for updates. This was caused by the receiving system needing to have some default data in columns which may or may not be supplied by the insert or update statements. This is slightly more complex than first imagined:
I recently applied system patch 20132450 to my 22.214.171.124.0 installation on a 2 node RAC system on Oracle Linux 7.1. While ensuring that OPatch is the latest version available I came across an interesting command line option in opatchauto. It is called “-generateSteps”.
[oracle@rac12sby1 ~]$ $ORACLE_HOME/OPatch/opatchauto apply -help
OPatch Automation Tool
Copyright (c) 2015, Oracle Corporation. All rights reserved.
Apply a System Patch to Oracle Home. User specified the (more...)
I just noticed Neil Chandler‘s blog post about the Call For Papers for UKOUG Tech15.
I’ve just submitted my sessions for this year. It’s in my home town, so life will be easy this year.
UKOUG Tech15 : Call For Papers
was first posted on April 16, 2015 at 3:20 pm.
©2012 "The ORACLE-BASE Blog
". Use of this feed is for personal non-commercial use only. If you are not reading (more...)
The #ukoug_tech15 call for papers has gone out, and will be open until midnight on 10th May 2015
Last year was a fabulous event in Liverpool and we hope and expect it to be even better in Birmingham this year.
Full Disclosure: I am chairman of the UKOUG RAC, Cloud, Infrastructure and Availability SIG, and also on the Database stream judging and selection committee for Tech15. I am potentially open to bribes in the (more...)
If you’ve been near oracle-base.com recently you will see things have changed a bit…
The Main Website
For a couple of weeks I’ve been playing with Bootstrap and Font Awesome to make the main body of the website mobile friendly. Last night I got a bit bored so I decided to shift the whole site to the responsive mobile template so it’s a single look and feel regardless of the device.
Less than 5% (more...)
A colleague had a problem with an Oracle 126.96.36.199 database today. It affected the following table:
SQL> desc bepe.sd_national_holiday
Name Null? Type
-------------------------- -------- ------------------
SD_NATIONAL_HOLIDAY_ID NOT NULL NUMBER(15)
CREATED_BY NOT NULL VARCHAR2(100)
CREATION_DATE NOT NULL TIMESTAMP(6)
ACTIVITY_BY NOT NULL VARCHAR2(100)
ACTIVITY_DATE NOT NULL TIMESTAMP(6)
TCN NOT NULL NUMBER
The table was empty:
SQL> select count(*) from bepe.sd_national_holiday
Some time ago I pulled off the apocryphal “from 2 hours to 10 seconds” trick for a client using a technique that is conceptually very simple but, like my example from last week, falls outside the pattern of generic SQL. The problem (with some camouflage) is as follows: we have a data set with 8 “type” attributes which are all mandatory columns. We have a “types” table with the same 8 columns together with two more columns (more...)
It’s been a while since my last post but I was really busy working on a number of projects.
The purpose of this post is to highlight an issue I had while building a standby database. The environment we had – three 188.8.131.52 databases at host A (primary) and same were restored from backup on another host B (standby), both hosts were running Linux. It’s important to mention that both hosts were (more...)
An interesting mathematics based question from a Singapore high school exam has been doing the internet rounds in the past few days. Considering it’s aimed at high school students, it’s a tricky one and obviously designed to filter out the better students, in a country with a very good reputation for churning out mathematically gifted […]
Golden Gate 12 has some excellent commands to keep your log files in check, plus one glaring omission (scheduled for a future enhancement)
Each extract, datapump and replicat will be writing to report (.rpt) and discard (.dsc) files in the dirrpt directory (if you aren’t specifying a discard file, you should. They are very useful for troubleshooting)
If your system is up for a long time, these files are going to get large. (more...)