Don’t forget Oracle Midlands Event #17 next week!
I don’t know about you, but I would like to know what Oracle have been up to. There has been very little in the way of publicity from them recently…
If you live near, please show your support for the event and come along. It’s free thanks to the sponsorship by RedStackTech.
Oracle Midlands : Event #17
was first posted on September 22, 2016 at 7:41 am.
I started the day by meeting up with a bunch of people at the Dbvisit breakfast. This has become a regular event over the last few years. Followers of the blog know I like the Dbvisit folks and they tend to attract people I find fun and interesting. After food, loads of coffee and interesting conversation, it was time to head across to the conference.
I bumped into Liron and Zohar at the OTN lounge and walked over with them to watch Connor (more...)
We had question in the OpenWorld panel about why queries on date columns are “always slow”. Well….they aren’t but here’s a common cause of that misconception.
Let’s create a table as a copy of DBA_OBJECTS, and index the CREATED column (which is a date).
SQL> create table t as
2 select *
3 from dba_objects;
SQL> create index t_ix on t ( created );
The problems start when (more...)
for a while now. It is an amazing plugin to create all kind of customized business solutions. But before I show you how I have used Raphaël I tell you how I came to the technology and what happened in the last few years. (more...)
I didn’t have a lot of time to blog during OOW16, so here is the summary of the last 4 days here. On the sessions side I didn’t go to a lot of them (as expected). I managed to miss my friends sessions (Zohar Elkayam and Ami Aharonivich) I did go to an ODA hands … Continue reading OOW16
Today an application team had a problem with a production system and they wanted the database restored to a point a couple of days ago. It is a configuration management system and they figured they could lose any changes . Their call.
I did all the good things
- Checked we had a change in place
- Blacked out primary and standby in OEM
- Checked flashback was on –
select flashback_on from v$database;
One of the questions we see being asked reasonably frequently is how to allow read only access to someone who wants to view database performance issues, using tools such as Real Time ADDM, ASH Analytics and so on. This is generally asked for someone like an application developer, who can use this information to identify performance issues in Production and then fix the root cause in their Development environments.
Well, that’s a reasonable question to (more...)
Yes, it is still alive. Version 3.1.1 of Mumbai is available for download.
Mumbai served me well over the last months, so there were no updates for quite some time. However, it’s time to do at least some compatibilty fixes, especially in regards to 12c.
So here is the first shot which fixes some of the major compatibilty problems. I expect that there are more things to fix (and extend) regarding 12c and RAC (more...)
Last week I described a method to make the tooltip on information more accessible to the end user.
Here is how you could make the same information available to touchscreen users.1)
First step, as before
, is to define the HTML Expression of the column to include the title
In this case I also stored my row identifier as an extra data- attribute
<span title="#RECENT_NOTE#" data-key="#ROW_KEY#">#MY_COLUMN#</span>2a)
Create a dynamic action on click (more...)
Within this blog post I will show you how to configure the Oracle Reports 12c jobStatusRepository against an Oracle Database.
Within Oracle Reports 12c a major change is, that within the jobStatusRepository configuration, we have now to use an entry in the Credential Store Facility (CSF).
At first create in your target database for the Reports Server Queue a user:
create user rwadmin identified by "Oracle12c" default tablespace users quota unlimited on users;
grant create (more...)
The Oracle NANVL function is useful when working with number values. Learn what it does and how to use it in this article. Purpose of the Oracle NANVL Function The NANVL function is used to return a different value if the specified value is NaN (not a number). It’s useful for floating-point numbers such as […]
Approximate Query Processing appears to be a major feature of Oracle Database 12c Release 2 SQL. In 12cR1 patchset 2 (188.8.131.52), we saw one approximate query function appear – APPROX_COUNT_DISTINCT to use instead of COUNT(DISTINCT). In 12.2 there are several APPROX functions introduced: APPROX_COUNT_DISTINCT_DETAIL APPROX_COUNT_DISTINCT_AGG TO_APPROX_COUNT_DISTINCT APPROX_MEDIAN APPROX_PERCENTILE APPROX_PERCENTILE_DETAIL APPROX_PERCENTILE_AGG TO_APPROX_PERCENTILE According to Oracle […]
I spent a bit of time with Liron Amitzi today brainstorming ideas about user group meetups and putting him in touch with a potential sponsor.
Since his move to Vancouver, Liron’s been involved with the user group there and he was asking for ideas about how to help promote it. I don’t claim to know much about this stuff, but I do see what others like Pythian, Oracle Midlands and RedStackTech (#ClubOracle) have done (more...)
Day 2 started a little late for me. I was up early, but I logged in to work and had to do a few things. Once I had got through that I headed down to the conference…
On the way there I bumped into Ronald Bradford and we hit the exhibition hall together. We stopped by the SolarWinds stand and noticed a “Deploy Faster” sticker. Part of the promotion for the Girls Who Code Foundation. If you see one, take (more...)
My latest Oracle Press "Oracle Database Cloud Cookbook" being sold at Oracle Open World this week. Grab a copy.
Today I stumbled across a strange error when I tried to run orachk on a customer’s system: $ ./orachk Enter ORACLE_HOME for PRODDB : /opt/oracle/product/rdbms/12.1.0 Could not login to PRODDB using /opt/oracle/product/rdbms/12.1.0. Try again (3 attempts remaining) Enter ORACLE_HOME for PRODDB : a.s.f... A quick internet search revealed nothing useful, so I checked MOS. Document […]
Just a stupid error. Posting it so that someone else googling for the same thing can get a clue.
An ASM instance running with default parameters (no pfile, no spfile). Updated spfile for the instance with asmcmd spset command and bounced crs. After reboot also, it still wasn’t using spfile. Got puzzled and checked GPnP settings again. All looked good. Then in alert log came across this
ERROR: SPFile in diskgroup <> does not match (more...)
One of those things SQL developers are frequently looking at is the generation of rows: having a query return records that do not really exist. For example to generate test data or to produce records for all days in a month. Tom Kyte usually selects from data dictionary views. Various tricks make the rounds, for example based on CONNECT BY or CUBE or UNPIVOT. This blog article by Natalka Roshak (2015) compares various row generation (more...)