In a few weeks I’ll be talking about monitoring Oracle GoldenGolden using Oracle Enterprise Manager 12c at IOUG Collaborate in Las Vegas. This is one of the few presentations I will be giving that week (going to be a busy week). Although this posting, kinda mirrors a previous post on how to configure the Oracle GoldenGate JAgent, it is relevant because:
1. Oracle changed the name of the JAgent to Oracle Monitor Agent 2. Steps (more...)
Some time ago I wrote a blog note describing a hack for refreshing a large materialized view with minimum overhead by taking advantage of a single-partition partitioned table. This note describes how Oracle 12c now gives you an official way of doing something similar – the “out of place” refresh.
I’ll start by creating a matieralized view and creating a couple of indexes on the resulting underlying table; then show you three different calls to refresh (more...)
The Oracle SOA Suite 12c quick start is an excellent way to get started with all the new features of 12c. I imagine it must be frustrating when you log in to http://localhost:7101/servicebus and are confronted with an 401 – Access Denied error message. Rest assured, there is nothing wrong with your credential configuration. The cause is likely much more simple; you use the wrong Java version.
Although the certification matrix for FMW 12.1. (more...)
SQL> with function f return int is
3 for r in (select value from v$mystat natural join v$statname where name like 'IM scan rows') loop
5 return r.value;
6 end loop;
8 select f() from t_inmemory where rownum<=1
1 row selected.
1 row selected.
In an earlier post, I mentioned that Oracle has finally, offcially supported the Oracle Management Repository (OMR) on Database 12c (22.214.171.124). As I’ve been working on a DBaaS project, I built a new Oracle Enterprise Manager (OEM) enivornment to test out a few things. Since I was rebuilding, I decided to try out the PDB as an OMR (afterall I’ve been asking about this approach). In the past, installation would fail around (more...)
Oracle Stream Explorer is available now for download. For those unfamiliar with the product, it is a new tool based on Oracle Event Processing (OEP, formerly known as Complex Event Processing). It’s a graphical interface on OEP, hiding the rather daunting CQL (Continuous Query Language) from the user.
Installation is pretty straightforward. You start with installation of OEP 12.1.3.
While creating a BPM project simulation in the JDeveloper 12c IDE, I noticed some differences in behavior as opposed to 11g. Although the functionality is mostly unchanged, the UI is different. Most of them are more intuitive, but you might want to check them out and save some time.
Simulations are not always listed by default in the BPM project navigator. You can add them by right-clicking on the project, select New … | From (more...)
Yeah, it’s indeed true and official. So if you still haven’t started reading and learning Multitenant architecture introduced in 126.96.36.199 and enhanced in 188.8.131.52, it’s high time that you start doing it. Not because that it’s new but because the old architecture you are familiar with, it’s officially on the verge of extinction.
A recent thread on the OTN database forum supplied some code that seemed to show that In-memory DB made no difference to performance when compared with the traditional row-store mechanism and asked why not. (It looked as if the answer was that almost all the time for the tests was spent returning the 3M row result set to the SQL*Plus client 15 rows at a time.)
The responses on the thread led to the question: (more...)
Oracle Database 12c brings us many new features including: the long needed ability to run OPatch and query the patch software installed in the Oracle Home programatically through SQL using the new DBMS_QOPATCH package.
If you’re a DBA working in an environment where patching consistently among databases is important, this is a welcomed enhancement. Sometimes one-off critical bug fix patches are important in the environment. Other times regular and consistent application of the quarterly (more...)
The replicat process is the apply process within the Oracle GoldenGate environment. The replicat is responsible for reading the remote trail files and applying the data found in cronilogical order. This ensures that the data is applied in the same order it was captured.
Until recently there was only one version of a replicat, that version was the classic version. As of 184.108.40.206, there are now three distinct versions of a (more...)
The Data Pump group is an secondary extract group that is used to help send data over a network. Although a data pump is another extract group, don’t confuse it with the primary extrat group. The main purpose of the data pump extract is to write the captured data over the network to the remote trail files on the target system.
Note: if the data pump is not confgured then the primary extract group (more...)
The extract process of Oracle GoldenGate is used to perform change data capture from the source database. The extract can be used to read the online transaction log (in Oracle the online redo logs) or the associated archive logs. The data that is extracted from the source database is then placed into an trail file (another topic for a post) for shipping to the apply sided.
To configure an extract process there needs to (more...)
There are many different ways of monitoirng Oracle GoldenGate; I have posted about many of these in earlier blog posts. Additionally, I have talked about the different ways of monitoring Oracle GoldenGate at a few conferences as well. (The slides can be found on my slideshare site if wanted). In both my blog and presentations I highlight many different approaches; yet I forgot one that I think is really cool! This one was shown to (more...)