How to protect UC4 Scheduler with Oracle Clusterware (RAC)
UC4 Scheduler (Atomic) is one of the best software scheduler on the market, recently acquired by CA. In my case, UC4 is used for scheduling batch jobs for Oracle Retail and for the integration platform (Oracle Service Bus, JMS, AQ…). It is a very scalable scheduler which in my case is executing more than 20.000 […]
PCC-S-02201 error when compiling Pro*C program
Recently I have to develop/modify one of the most complex batch programs in Oracle Retail: the dealinc batch. After making several optimizations and change the program logic (Oracle even in the most recent version of Oracle Retail 14 & 15 did not fix all the performance issues related with this batch), I was not able […]
How to call Web Service from the Oracle database
In this article I want to explain what you need to do to be able to call Web Service. Although there are many good articles on the web, no one provide complete step by step instructions on how to do it. My goal in this article is to explain the complete procedure in a simple […]
RMAN performance tuning in combination with Tivoli server
Last month I’ve been working on rman backup optimization. One of the largest databases that I manage starts to break time frame given for the full backup. Full backup starts every Saturday at midnight and should finish till Sunday 10AM. Suddenly, for no apparent reason, full backup finish around 2:30 PM. As the database is […]
Calculating segment growth and related issues
One of the thinks that Oracle user would expect is to find on the Web script for segment growth report/analysis for the last x days. Although there are many scripts available, all of them (at least all scripts that I’ve checked) does not provide correct result. As scripts for tracking segment growth are all based […]
How to trace execution of PL/SQL code for target application that uses connection pool
Here is a problem: I need to track all PL/SQL code that application of interest (Oracle Retail Price Management in this case) is executing, where I need to find out not only all anonymous code along with stored procedures/packages/functions that have been executed, but also the sequence of execution (time of execution). In this case, […]
optimizer_features_enable hint and when to use it
Cost based optimizer is the most important piece of code in Oracle database as CBO is responsible for optimal execution of SQL queries. CBO has been constantly developed, where each release introduces many new features/tricks and improvements. As with any programming code, CBO is not immune on bugs in the code. Good news is that […]
ORA-14137 after executing drop table purge;
I had a case where the drop table with purge option DDL statement produce the error from the title and left partitioned table in the partially dropped state. I can still see the table and all belonging objects like indexes/constraints… in dictionary, but If I try to select from that table, I get the following […]
Oracle Service Bus and Remote JDBC disabled Java error
Recently I’m been facing issues inside OSB (Oracle Service Bus) as one of the data sources are constantly filling a log with the following error: Invoke JCA outbound service failed with application error Remote JDBC disabled com.bea.wli.sb.transports.jca.JCATransportException: oracle.tip.adapter.sa.api.JCABindingException: oracle.tip.adapter.sa.impl.fw.ext.org.collaxa.thirdparty.apache.wsif.WSIFException: servicebus:/WSDL/df67_stock_order_from_RMS/resource/wsdl/df67_swl_sub_stock_order [ df67_swl_sub_stock_order_ptt::insert(ZDf67TransferHeaderStgCollection) ] – WSIF JCA Execute of operation ‘insert’ failed due to: Could not […]
Compound triggers performance and use cases
Let’s assume you have to track changes in stage table (in this case tstage table) and insert all inserted rows in trigger_test table. Once of your logical choices is to create a trigger (there are a couple of other options related to AQ/streams). Before 11g version, you can create before/after row trigger (where later is […]