I’ve been using standby databases, on and off, since Oracle 8i. I first wrote about Data Guard for Oracle 9i. I’ve had an article on 11gR2 Data Guard for ages, but up until recently I’ve always used the manual setup.
We’ve got a project coming up that *may* use Data Guard and *may* be installed by a 3rd party, so I figured I better get up to speed with the Data Guard Broker, in case they (more...)
A new version 4.23 of the XPLAN_ASH utility is available for download.As usual the latest version can be downloaded here.
This version comes only with minor changes, see the change log below.
Here are the notes from the change log:
- Finally corrected the very old and wrong description of "wait times" in the script comments, where it was talking about "in-flight" wait events but that is not correct. ASH performs a "fix-up" (more...)
Why you might want to think twice about using INSERT ALL.
One of those things I knew and then forgot.
So, let’s say you’ve got three tables or a partitioned table or something like that.
Let’s use regional tables for simplicity.
drop table t1_r1;
drop table t1_r2;
drop table t1_r3;
create table t1_r1
(col1 varchar2(2) not null
,col2 number not null
,check( col1 in ('R1')));
create table t1_r2
(col1 varchar2(2) not null
,col2 number not (more...)
I’m a taxonomy practitioner at Fishbowl Solutions who has worked with many companies to implement simple to sophisticated document management systems. I’ve noticed over the years the large number of obstacles that have prevented companies from establishing taxonomy frameworks to support effective document management. I won’t review an exhaustive alphabetic list of obstacles, in fact, there are probably far more than 26, but I’ll highlight the top culprits that have turned even the best, most (more...)
With my latest customer I was building the same OSB project over and over again with some minor changes. With copy and paste from other project a lot of other namespaces are saved in the xml under the proxy files. The main reason for this OSB proxy is logging and handling the security between the different domains. Because it was the always the same proxy structure and in OSB 11g there is no template available I (more...)
The Oracle Service Bus has built in features to poll an IMAP of POP3 mail account. There are loads of excellent blog posts that exactly describe how to do it. However, when the mail server happens to be a Microsoft Exchange server, things become shady. Exchange’s IMAP implementation tends to be not really that compatible, and the server log will fill up with stacktraces such as:
javax.mail.MessagingException: Connect failed;
nested exception is:
If you need TranslationHub (Windows only) for your forms and reports development and plan to move to one of the following
- 12c Database for your TranslationHub repository
- 12c Forms/Reports (only available for 64 bit Windows)
- higher version of 64 bit 11g Forms/Reports
then please immediately stop! None of this combination works with TranslationHub!
For the last point I had created enhancement request 14155931 back in June 2012!
For the first point I had created a service request (more...)
I was contacted by Dev team to look into Development database where Oracle queue size kept on increasing. As per them messages were not getting cleared.They were running count on Queue table and the count kept increasing. To find out exact cause I included the msg_state in the query and found out that there were…
iAdvise presented the APEX 5.0 roadshows in the first half of 2015. Besides the presentation about the new features, we provided 3 tutorials which helped the visitors to explore Oracle Application Express 5.0. Now we offer these tutorials through our blog. In this article the second tutorial is presented.
This tutorial helps you step by step through the process of migrating an application to the Universal Theme
of Oracle Application Express 5.0
. In this tutorial we talk about (more...)
A new version 4.22 of the XPLAN_ASH utility is available for download.As usual the latest version can be downloaded here.
This version primarily addresses an issue with 12c - if the HIST mode got used to pull ASH information from AWR in 12c it turned out that Oracle forgot to add the new "DELTA_READ_MEM_BYTES" columns to DBA_HIST_ACTIVE_SESS_HISTORY - although it got officially added to V$ACTIVE_SESSION_HISTORY in 12c. So now I had to implement (more...)
If you try to install oracle forms & reports 220.127.116.11 on SLES 11.3 than despite all installer checks are passed maybe you get a message like:
Error in invoking target ‘install’ of makefile ‘<FR_HOME>/sqlplus/lib/ins_sqlplus.mk’.
The reuirement check of the installer shows only missing openmotif classes which are not really required on SLES (see Doc ID 1567715.1), but no problems with a compiler or something similar.
Checking for binutils-2.19-11. (more...)
A rather not so great post about an ORA-00600 error i faced on a standby database. Environement was 18.104.22.168 on Sun Super Cluster machine. MRP process was hitting ORA-00600 while trying to apply a specific archive log.
The error message was something like this
MRP0: Background Media Recovery terminated with error 600
Errors in file /u01/app/oracle/product/22.214.171.124/diag/diag/rdbms/xxxprd/xxxprd1/trace/xxxprd1_pr00_6342.trc:
ORA-00600: internal error code, arguments: , , , , , , , (more...)
A recent case at a client reminded me of something that isn't really new
but not so well known - Oracle by default performs evaluation at the latest possible point in the execution plan.So if you happen to have expressions in the projection of a simple SQL statement that runs parallel
it might be counter-intuitive that by default Oracle won't evaluate the projection in the Parallel Slaves but in the Query Coordinator
- even (more...)
I ran into a problem the other day when moving some code from one database to another (both XE 11g). The code in question needs to convert an XMLType to a CLOB to do some (hacky) string manipulation on it, and then turn it back to an XMLType.
Here's the original code: l_xml := apex_web_service.make_request(...);
-- little hack to remove bad empty namespace from result
l_clob := l_xml.getClobVal();
Today my presentation is confirmed: “Bob the Builder: Build/Deploy of ADF enterprise applications”.
I will speak over our experiences with following
- build tools
- deployment tools
- versioning & branching
- continuous integration
- hot deployment in development
- compile & runtime dependencies
If you speak german and you are interested in some of this, you should come and attend DOAG 2015.
Filed under: Deploying
, ADF Architecture
Continuing from the previous part
- which was about the Temp Table Transformation and join cardinality estimates - using the same simple table setup here is a slight variation of the previously used query to demonstrate the potential impact on single table cardinality estimates
explain plan for
cte as (
select /* inline */ id from t1 t
where 1 = 1
*/ * from cte a, cte (more...)
Heuristic Temp Table Transformation - 2 Some time ago
I've demonstrated the non-cost based
decision for applying the temp table transformation when using CTEs (Common Table/Subquery Expressions). In this note I want to highlight another aspect of this behaviour.Consider the following data creating a table with delibrately wide columns:
create table a
rownum as id
, rownum as id2
, rpad('x', 4000) as large_vc1
, rpad('x', 4000) as large_vc2
, rpad('x', 4000) (more...)
In general it is known that Function-Based Indexes (FBIs) can no longer be used by the optimizer if the expression contains literals and CURSOR_SHARING = FORCE / SIMILAR (deprecated) turns those literals into bind variables. Jonathan Lewis described the issue quite a while ago here
in detail.In a recent OTN thread
this issue was raised again, but to my surprise when I played around with a test case that mimicked the OP's problem query (more...)
While trying to run pre_upgrade_status.sql script for DB upgrade (10.2.0.4 to 126.96.36.199), we got following error @pre_upgrade_status.sql ERROR at line 1: ORA-01873: the leading precision of the interval is too small ORA-06512: at line 8 On debugging further , found out that it was due to limit imposed on "INTERVAL DAY TO SECOND" datatype. By…
Recently we came across a issue where our DB crashed with ORA-00338 error . Errors in file /oracle/diag/rdbms/orcl11g/orc11g/trace/orc11g_lgwr_24118.trc: ORA-00338: log 2 of thread 1 is more recent than control file ORA-00312: online log 2 thread 1: '/oracle/oradata/orcl11g/redo02.log' LGWR (ospid: 24118): terminating the instance due to error 338 DB couldn't be restarted as it gave same errors…