RPM_PRICE_EVENT_EXEC_RMSBATCH aborted
In scope of resolving aborted batch, support ask me to take a look at the following code that has to be executed to resolve the issue: update price_hist ph1 set ph1.ACTION_DATE=ph1.ACTION_DATE-1 where ph1.tran_type = 0 and ph1.action_date >= to_date('10.11.2014','dd.mm.yyyy') and exists (select 1 from price_hist ph2 where ph2.item = ph1.item and ph2.loc = ph1.loc and […]
DNS server replacement and influence on Java apps
This is one of the longest living issues I’ve got for resolving, as in busy production environments you can rarely get some time frame for action on DNS. First let me explain the issue. Client where I’ve been working need to replace one very old DNS server with a new one. On each server we […]
Moving Oracle running process to background without interruption on AIX
Imagine that you are going home, but before you go, you start some script (bash, Oracle SQL*Plus, or PL/SQL procedure) for which you didn’t know or didn’t think in advance that job you start to execute can take a long time to finish, and can’t be interrupted. In this blog I’m assuming you are running […]
SQLcl tool – a modern SQL*Plus
With the new version of SQL Developer 4.1, Oracle makes available early adopter of the SQLcl, a new tool that might replace SQL*Plus tool. I’ve make some tests with version last updated on September 14th, 2015 (version 4.2.0.15.257.0801). This is the list of features that I like the most. 1. autocomplete Better than rlwrap utility […]
SQL Developer 4.1 New Performance Related Features
SQL Developer has been my favorite tool for database development and administration from the beginning, as it has many advantages over commercial tools, neglecting the price difference. The name of the tool is a bit misleading as it suggest that the target audience are database developers, which is not correct. The main progress during the […]
Oracle Retail Batches performance tuning – Location Move Schedule batch
As described in the operations guide, location moves allow you to move location from one zone into the different zone. This is one of the most complex batches in Oracle Retail Suite. The batch is running in two phases. First it is needed to run Location Move Schedule batch, and after that the main Location […]
Oracle Retail Batches performance tuning – Reclassification
I’ve been asked to help resolving performance issue with reclassification batch, as important business process was unable to finish within reasonable time frame. A few facts about reclassification batch (RECLSDLY): As described in Operations Guide (13.2.x), item reclassification is the process through which an item or item list is moved from one department/class/subclass to another. […]
Troubleshooting performance issue by using OS Watcher and AWR report
Recently I’ve been assign to help in resolving issue named “name_of_the_critical_app slowing down” between 2 and 3 AM. As the system architecture is fairly complex, I’ve decided to start with analyzing OS data collected by Oracle’s utility OS Watcher. From generated report, It’s clear that during one hour period several disks had large service time […]
How to speed up copying files over the network
Assuming that ftp service is disabled for security reasons, the most admins are using scp to copy files to/from the target server. As many users have already noticed, the file transfer is slow (at least slower then NFS share or Samba for example). Reason for this is in the letter “s” in the scp command which […]