:

RSSScripts

Oracle Implicit Commit

The idea behind this test came from a script which was rolled into a production environment. The script had been tested but the incorrect data was only on the production database and we decided that we would leave the commit out of the script and see what the results were before committing it. Within the script […]

Continue Reading

RAT – Workload Analyzer

I have recently been playing around with Real Application Testing (RAT) and as part of the replaying of a captured workload it is advisable to run the Workload Analyzer if you are using the APIs to replay the workload. This is required to identify any potential problems by analyzing the workload capture files in the […]

Continue Reading

How to use the FINDSTR Command in Windows

After upgrading or patching your Oracle software on a Windows platform it’s necessary to check through the log files for any errors encountered during the process which have not caused the upgrade to fail. In order to do this, I use the findstr command against the log file, and example would be: findstr /B /N […]

Continue Reading

RMAN Performance – Block Change Tracking

A new feature within Oracle 10g is the ability to improve the performance of your RMAN incremental backups by using BLOCK CHANGE  TRACKING. The block change tracking feature uses a file stored on the file system to record which blocks have changed since the last backup. Then, when RMAN starts its backup, it can read the file […]

Continue Reading

MISSING Streams multi-version data dictionary

I was testing out the effects of making changes to tables within the source database in a Change Data Capture (CDC) configuration on Oracle. I was adding columns, removing columns, etc and seeing what changes I needed to make in the destination database in order to keep everything working as it should. I then tried […]

Continue Reading

ORA-15567: replay user encountered an error during a sanity check

The Problem I was playing around with Real Application Testing (RAT) on my Oracle 11g database. I had captured a workload from my production database and was attempting to replay the workload into a development database which was a copy of PROD. While attempting to connect the workload replay client to the database, I received the following […]

Continue Reading

ORA-00600: internal error code, arguments: ktsladdfcb-bsz

The Problem I was playing around with the securefile feature in Oracle 11g, which is used with LOB segments. I was trying to create a tablespace with the smallest extent size possible because I wanted to see the affect of using compression quickly and I thought the easiest way was to create a small extent […]

Continue Reading

Enterprise Manager Library Job Removal

One of the main purposes of the Enterprise Manager (EM) software is to centralise the management of various components across your infrastructure. Using the EM software, you can schedule jobs to run against various targets. If, like me, you have lots of jobs running against the databases, you may want to delete them all at […]

Continue Reading

ORA-12154: TNS:could not resolve the connect identifier specified

I came across a little Oracle issue this morning which can be quite confusing at times. It’s to do with compilation of a package which has references across a database link. Here is what we were seeing from our database warehouse: USER1@DW> EXEC CONFIG_PKG.UPDATESOURCEROW ERROR at line 1: ORA-12154: TNS:could not resolve the connect identifier […]

Continue Reading

Oracle 10g RMAN Compression

If you have large databases and you use RMAN to back them up, and you are a little concerned with how much space they currently take up, this could be just the tool for you. Previously, it was not possible to backup your database with RMAN and conserve space using compression; this had to be done afterwards using some […]

Continue Reading