Oracle Midlands : Event #17

Don’t forget Oracle Midlands Event #17 next week!

om17

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.

Cheers

Tim…


Oracle Midlands : Event #17 was first posted on September 22, 2016 at 7:41 am.
©2012 (more...)

Oracle OpenWorld 2016 : Wednesday – Day 3

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...)

Oracle Database 12.2 New Features (Part I) – Application Express

As you know, Oracle Open World 2016 conferences continue at San Francisco (September 18-22, 2016).

At keynote Session, Larry Ellison (CTO of Oracle Corporation) annoucemented the Oracle Database Exadata Express Cloud Service on new database version 12.2. Here is released cloud documentation

There have very interesting little guide for new features of Oracle Database 12c Release 2.
Why littel , because it is not all features of Oracle Database 12c Release 2, have more interesting (more...)

The simple fix to date queries

We had question in the OpenWorld panel about why queries on date columns are “always slow”.  Well….they aren’t Smile 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;

Table created.

SQL>
SQL> create index t_ix on t ( created );

Index created.

The problems start when (more...)

Creating interactive graphics in APEX with Raphaël (RaphaelJS)

Some of you may know of my personal interest for SVG interaction in APEX applications. I have been working with a JavaScript library called "Raphaël" (RaphaelJS, raphael.js or just raphael) 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...)

OOW16

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

Flashback database – dont forget the standby

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;

Read Only Users and Database Performance

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...)

Mumbai version 3.1.1 available

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...)

Oracle Open World 2016 from a PeopleSofter point of view: Tuesday 20th

We are now at full steam in what regards PeopleSoft at Oracle Open World. As my jet lag gets better (today I woke up at 4.30am, quite an achievement), so does the announcements at the PeopleSoft specific sessions.

The day started with a general keynote facilitated by Safra Catz and Thomas Kurian. I have found the second part most interesting as it went deeper into the announcements made last Sunday by Larry Ellison. Compared (more...)

Show report tooltip as notification

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 tag.
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...)

Configure jobStatusRepository in Oracle Reports 12c

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...)

Oracle NANVL Function with Examples

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 in 12c Release 2

Approximate Query Processing appears to be a major feature of Oracle Database 12c Release 2 SQL. In 12cR1 patchset 2 (12.1.0.2), 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 […]

Community : Discussing the Meetup Format

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 PythianOracle Midlands and RedStackTech (#ClubOracle) have done (more...)

Oracle OpenWorld 2016 : Tuesday – Day 2

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...)

Oracle Open World

My latest Oracle Press "Oracle Database Cloud Cookbook" being sold at Oracle Open World this week. Grab a copy.





orachk “Could not login to (SID)”

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 […]

ERROR: SPFile in diskgroup does not match the specified spfile

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...)

Next Step in Row generation in Oracle Database 12c SQL using JSON_TABLE

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...)