Efficient Statistics Maintenance for Partitioned Tables Using Incremental Statistics – Part 3

Normal 0 false false false EN-US X-NONE X-NONE Introduction This post covers how Oracle has improved incremental statistics for partitioned tables in Oracle Database... [Read More]

12cR2 tightens up ORA-01841 for zero year ANSI dates, but not for Oracle SQL syntax

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
FROM dual
/
DROP VIEW test
/

CREATE OR REPLACE  (more...)

The latest in Oracle Partitioning – Part 2: Multi Column List Partitioning

This is the second blog about new partitioning functionality in Oracle Database 12c Release 2, available on-premise for Linux x86-64, Solaris Sparc64, and Solaris x86-64 and for everybody else in the Oracle Cloud . This one will talk about multi column list partitioning, a new partitioning methodology in... [Read More]

Oracle Database 12c Release 2: Analytic Views & SQL Developer

One of the major new features in Oracle Database 12c Release 2 is Analytic Views. An analytic view is a type of view that can be used to easily extend the content of a star schema with aggregated data, measure calculations and descriptive metadata, and to simplify the SQL needed to access data. Analytic views layer a... [Read More]

Updated SQLcl: 2 New Commands, Bug Fixes, and 12cR2 Oh My!

You have a new version of SQLcl to download this morning. Lots and lots of bug fixes – again, thanks everyone in the community for providing feedback so we can make continuous improvements. A few things of note: Two New Commands They do pretty much what you’d expect. FIND and WHICH – hopefully will... [Read More]

Learn How to Effectively Administer Your Oracle WebLogic Server 12c


Oracle WebLogic Server 12c is a part of the Oracle Fusion Middleware 12c line of offerings, which consist of several Oracle products that span content management, integration services, collaboration tools and business intelligence.

Products like Oracle Fusion applications and Oracle SOA rely on Oracle WebLogic Server to run their code.

The Oracle WebLogic Server 12c is easy to install; however, administrators need to know the following:

Online Table Moves and Partitioning in Oracle Database 12c Release 2 (12.2)

A couple of articles have crept out over the last few days that relate to online operations on Oracle Database 12c Release 2 (12.2). Both of them are pretty small in terms of what you have to do, but are pretty awesome in terms of impact, so I’m giving them the official thumbs-up! 🙂

The first one is about moving tables online.

I (more...)

Non-CDB still exists in Oracle Database 12.2.

I received a question from 3 different colleagues in the past week: "Does Oracle Database 12.2 still allow us to create non-CDB databases?" And as I get this question at every customer-facing workshop these days as well before being able to talk about Single/Multitenant - I think it is important to... [Read More]

Using HISTORY in SQL*PLUS 12.2….

One of the biggest things that we couldn’t do in the previous versions of the oracle database was to use the back arrow button-to reexecute the old commands, without typing them. Of course, a workarouns is possible in the form of rlwrap but it’s not comparable to a natively available feature in the SQL*PLUS. Well, until now because now, we have HISTORY option available in 12.2 SQL*PLUS. Let’s take a look.

SQL> /

BANNER                         (more...)

In case you miss the downloads of Oracle Database 12.1.0.2 on OTN

Somebody asked me the other day why the download options for Oracle Database 12.1.0.2 for Linux and Solaris  disappeared from OTN? The same will happen with the other platforms as soon as Oracle Database 12.2.0.1 is available on-premises for them as well. You can always download Oracle Database 12.1.0.2... [Read More]

Converting an 12.1 non-CDB and plug it into an 12.2 CDB

2 customers requested a bit more explanation on how to:Convert and Plugin an Oracle 12.1 non-CDB database into an Oracle 12.2 container database Cool, I like that I will do this right away and use the approach to Upgrade first, then Plugin afterwards.. Upgrading an Oracle 12.1.0.2 database to Oracle 12.2.0.1 ... [Read More]

3 Oracle Database 12c Courses You Need to Get Started


Three Oracle courses in particular will help you get started on Oracle Database 12c:

The Oracle Database 12c R1: New Features for Administrators training will provide you with up-front information about (more...)

Oracle Database 12c Release 2 is Now Available…and so is our New VirtualBox Appliance!

Want to get started on learning everything there is to know about the latest version of our Database? Don’t want to really have to install or create anything? Well, you’re in luck. Just go download our image. The image is up and running, complete with sample data for you to play with. In a few minutes,... [Read More]

Install components in Multitenant ALWAYS with catcon.pl

I did blog several times about how to remove an unwanted component from a database. But yesterday I came across this interesting scenario worth a blog post.. How to install a component afterwards in Single-/Multitenant? I haven't checked all the MOS Notes but I recognized that some MOS Notes explaining how to... [Read More]

12.2 .. not even 24 hours available on-premise and the first “bug” .. but a good one ..

We missed to document some functionality !!! With the next milestone for Oracle Database 12c Release 2 just taking place - the availability on premise for Linux x86-64, Solaris Sparc64, and Solaris x86-64, in addition to the Oracle Cloud - I managed to use this as an excuse to play around with it for a bit .. and... [Read More]

Goldengate 12c OGG-01117 core dumped

This probably applies to other versions as well.

Don’t you love it when there’s a simple solution?

oracle@test1:/opt/oracle/12.2.0/ggs01$ ggsci

Oracle GoldenGate Command Interpreter for Oracle
Version 12.2.0.1.170221 OGGCORE_12.2.0.1.0OGGBP_PLATFORMS_170123.1033_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Jan 23 2017 21:54:15
Operating system character set identified as UTF-8.

Copyright (C) 1995, 2017, Oracle and/or its affiliates. All rights reserved.



GGSCI (test1) 1> create subdirs

Creating subdirectories  (more...)

Getting Apex 4.2 Up and Running on Oracle 12c Using PL/SQL Gateway

Recently I was asked to create a simple Master-Detail Apex form on top of some metadata tables stored within Oracle 12c. Apex version 4.2 is already pre-installed in 12c but it needs configuring to be able to use. This is where I hit some trouble which stems from a conflict of information across a number of different sources.

I was following the Oracle certified documentation on 4.2 and how to get it running (more...)

Free Oracle SOA Suite 12c & BPM Suite 12c On-demand Training & Free SOA Partner Community

View this message in a Web browser


Oracle EMEA Partner Sales







Free Oracle SOA Suite 12c & BPM Suite 12c On-demand Training & Free SOA Partner Community


Dear Integration Expert,


We would like to invite you to become hands-on trained in the latest versions of Oracle SOA Suite 12c and BPM Suite 12c – free of charge!


Community Registration cta-arrow


Oracle TestFest
bullet Step 1: Free SOA & BPM Partner Community Registration

For regular information, including free trainings and free certifications, become a (more...)

Oracle Database Result Cache Troubleshooting

I was troubleshooting an issue where the Oracle Database Result Cache did not get used when the RESULT_CACHE hint was specified inside a subquery. As the main query has a sysdate inside, the RESULT_CACHE Hint can not be specified for the main query, but only for the subquery.

1
2
SELECT SQ.*, sysdate FROM
(SELECT * FROM tableX, ....) SQ;

When using “/*+ RESULT_CACHE */ inside of Subquery, result cache was not (more...)

How to speed up slow unicode migration of a table with xmltype columns

Recently I have had an issue with slow unicode migration of the database upgraded from 10g to 12.1.0.2. The main problem was a table with xmltype: we spent about 4 hours for this table(~17GB) during test migration, though all other tables (~190GB) migrated just for about 20 minutes.
We used DMU(Database Migration Assistant for Unicode), and the root cause of the problem was update statement generated by DMU for this table:

update   (more...)