I nipped out to the local supermarket this lunch time to get stuff. I use one of those self-use barcode scanners to log all the goods I put in my basket (apart from the bottle of whisky I was stealing). I then go to the payment machine, scan the “finish shopping” barcode and try to pay. I can’t pay.
I can’t pay as I bought some paracetamol (note to US readers, you know it as (more...)
A Book on Oracle 12c New features for administrators
It’s our pleasure to announce the availability of our first book – OCP 12c upgrade 1Z0-060 Exam Guide
The book covers the new features of the Oracle Database 12c for the DBAs from the OCP 12c upgrade exam standpoint. Book is available WW in kindle format as well as paperback.
Link to Amazon.com (more...)
How to Configure Extract on Standalone Active Data Guard System if Primary is RAC Multipe Nodes (Doc ID 1962336.1)
Configuring Classic Capture in Oracle Active Data Guard Only Mode
Quick and dirty post from what I just learned.
Who said you can’t teach old dogs new tricks!
$ dgmgrl / "show database hawka"
DGMGRL for Linux: Version 22.214.171.124.0 - 64bit Production
Copyright (c) 2000, 2009, Oracle. All rights reserved.
Welcome to DGMGRL, type "help" for information.
Database - hawka
Intended State: TRANSPORT-ON
$ dgmgrl / "show database hawkb"
DGMGRL for (more...)
I stumbled upon a convenient way to rename a pluggable database:
SQL> alter system enable restricted session;
SQL> alter database rename global_name to test12.home.com;
SQL> alter session set container=cdb$root;
SQL> select name from v$pdbs;
In other words, to rename a pluggable database, one only needs to rename its global name. Cute!
Oracle Open World was one of my biggest aspirations for a very long time. Ever since I become a junior DBA I’ve heard of this conference but never thought I’d actually get to speak there.
For the last 3 or 4 years, I’ve been submitting my papers to the Open World CfP – and was never accepted.
Last year, I started to make my appearances at the different user groups meetup in the EMEA region. (more...)
For the last few months I’ve been presenting a lot in various venues. I presented in Oracle Open World, HROUG conference in Croatia, DOAG in Germany, Oracle Week in Israel (3 day long presentations!), MySQL User Group in Israel and in some more private conferences and private events. I was also accepted to IOUG collaborate in Las Vegas in April and I’m planning to give some Webinars soon.
I believe that educating and sharing (more...)
My new Notebook is there! Will spend a couple of hours to do the setup. The specs are quite promising:
Intel Core i7-6700 | 4 Cores | 8 Threads | 3,4 – 4,0GHz
32GB SO-DIMM DDR4 RAM 2400MHz Crucial Ballistix Sport LT
6 TB SSD Storage:
1TB m.2 Crucial MX300
1TB m.2 Crucial MX300
2TB Seagate FireCuda | 5400U/Min | 7mm
2TB Seagate FireCuda | 5400U/Min | 7mm
Okay it did (more...)
While playing with Oracle 12.2 Database on the Oracle Cloud, I noticed that SQL*Plus has a new feature which would be very useful for all DBAs. Now SQL*Plus can keep history of the commands executed, and let you see and run these commands from the history. Its usage and functionality is very similar to Unix history tool, but do not think that pressing the UP arrow will return to previous commands
The history feature (more...)
Similar to last year, I had a presentation on a day I wasn’t attending, so I used my “lunch break” to drive in, present and drive back to work. I did get to see a bunch of people while I was waiting for my session to start, including my dad and wife.
My session was called “Put your feet up and have a REST. Take a tour of JSON support in the Oracle database. (more...)
Many people are using DBMS_STATS to gather optimizer statistics. This package has many different options, and I wanted to tell you about one option for disabling automatic statistics gathering. When we need to disable the automatic statistics gathering we usually do one of the following: Disable the job itself (using DBMS_AUTO_TASK_ADMIN). This completely disables the job so no … Continue reading Did You Know #17 – DBMS_STATS
After my Masterclass on indexes at the UKOUG Tech2016 conference this morning I got into a conversation about creating extended stats on a table. I had pointed out in the masterclass that each time you dropped an index you really ought to be prepared to create a set of extended stats (specifically a column group) on the list of columns that had defined the index just in case the optimizer had been using the distinct_keys (more...)
WordPress 4.7 “Vaughan” has been released.
The headline features from my perspective are:
- RESTful web services, so you can do stuff outside the main admin interface.
- The new “Twenty Seventeen” theme.
There are lots of other features, but they all seem a bit like fluff to me.
I’ve done the upgrade on five installations and it worked fine on all of them. By the time you read this you may have gone through the auto-update (more...)
Mark Rittman has been publishing his podcast series (Drill to Detail) for a while now and I sat down with him at UKOUG Tech 2016 conference to discuss Gluent and its place in the new world with him.
This podcast episode is about 49 minutes and it explains the reasons why I decided to go on to build Gluent a couple of years ago and where I see the enterprise data world going in (more...)
Oracle first introduced Advanced Compression for Indexes in 12.1 as I’ve discussed here a number of times. With Oracle Database 12c Release 2, you can now use Index Advanced Compression “High” to further (and potentially dramatically) improve the index compression ratio. Instead of simply de-duplicating the index entries within an index leaf block, High Index […]
I got a bit of a late start to the day. I had a some work stuff I had to do before setting off for the conference and it dragged on a bit longer than I expected.
My plan for the day was to go to sessions about stuff I don’t do for my job. I could dress that up as something strategic, but the reality is I’m now totally conferenced out. It’s been a (more...)
This year I decided to come to Birmingham a little early for UKOUG Tech16, coming up on the Saturday. I drove up to Lichfield (15 miles North of Brum – which explains the touch of Brummie in my accent) in the morning to see my mum. Once we had discussed her various ailments and prejudices for a few hours and I’d unblocked her vacuum cleaner I set off into Birmingham to get to Jury’s hotel (more...)
There is a very interesting paper about the way of direction of the Exadata Database Machine.
Thanks a lot Günther Stürner.
While writing the previous two posts about GTTs and Smart Scan, I stumbled across an interesting observation. When I started putting my thoughts to (virtual) paper, I thought it was going to be a short post. Well, it wasn’t to be, again. Anyway, you might find this interesting.
If you read the previous posts this code example I used to populate the GTT might look familiar:
insert /*+ append */ into gtt select (more...)
I attempt to export a table with 76,000 rows using a relatively standard datapump command
expdp schemas=ODI_TEMP cluster=y directory=MCB content=ALL dumpfile=OEC_%U.dmp include=table:"IN('ORDM_ERROR_COUNTS')" parallel=8 logfile=OEC.log
It fails with a fatal error and also produces a warning
Connected to: Oracle Database 11g Enterprise Edition Release 126.96.36.199.0 – 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management and OLAP options
Starting “ODI_TEMP”.”SYS_EXPORT_SCHEMA_03″: odi_temp/******** schemas=ODI_TEMP cluster=y directory=MCB content=ALL dumpfile=OEC_%U.dmp (more...)