Skip navigation.


SQL and PL/SQL Questions

Both SQL Trace and TKPROF help to find the statistics of an SQL statement which could be used for query optimization.

Start Oracle SQLTRACE:

In Oracle, to start an SQLTRACE for the current session, execute:


Stop Oracle SQLTRACE

In Oracle, to stop SQL tracing for the current session, execute:

ALTER SESSION SET sql_trace = false;

Read More

Trasliteration - Conversion of double/triple byte characters to single byte characters for various requirements

I recently came across a document where the requirement was to convert from triple/double byte characters to single byte characters to send it for export complaince check as the export compliance system can accept only single byte characters.
Basically the useful thing about this was they were using IBM ICU project(an open source project) for this process,so in a way making it more open to developers.
These were the pros and cons for IBM identified by them.
- No interface needed (written in Java, integrable in Oracle)
- High level of portability, flexibility and scalability
- No int

Installing Oracle E-Business 12.1.1 on Oracle Enterprise Linux

vjain's picture

The Adventure Begins

This article is a shortened version of the full article on Installing Oracle E-Business 12.1.1 on Oracle Enterprise Linux 5.4 64-bit which can be read on

I started by purchasing a brand new enterprise server without an OS. My first goal was to install the latest release of Oracle Enterprise Linux for the operating system and then to install the latest release of Oracle Database (11.2).

Proc SQL for SAS Programmers

SQL for SAS Programmers - Introduction

What is SQL?

SQL stands for Structured Query Language and was designed for development and maintenance within a Database Management System (DBMS).

SAS Display Manager Commands

In my view, Display Manager commands didn’t get much attention of SAS programmers as they should be. It may be because...

1) SAS Documentation has very little information about how to use this facility.
2) Even Google searches aren’t helpful enough.

Here are the list of Display Manager Commands I know…

Using Manager commands we can open the dataset from any directory without touching the Explorer window…

Read more:

Killing my Oracle sessions

Many a time, developers ask for procedures to kill there own sessions in the oracle db.
Many of our developers are scattered around the globe in different time zones.
During on-call rotation, developers will be calling me, round the clock, to kill their sessions.

To resolve this issue, I came up with this package, consisting of a pipelined function
and a procedure. The pipelined function, displays the users' sessions in the db.
The procedure kills the developer's session only.

Heartbeat failed to connect to standby-11g Dataguard

Error:Heartbeat failed to connect to standby Error 12541
By using rdist command, one can copy Oracle's password file from primary site to physical standby site.

Moving multiple tables and indexes between tablespaces at once

David Lozano Lucas's picture

Here I present a simple query to use when we want to move the tables and indexes of several users at once.

To make it one by one:


To move data from multiple owners.

Oracle10g Regular Expression

Oracle10g Regular Expression

Oracle database 10g added a new feature "Regular Expression" enhancement that can be used with SQL and PL/SQL statements.

There are four regular expression functions :-


The functions REGEXP_SUBSTR, REGEXP_INSTR and REGEXP_REPLACE basically extend the functionality of other well known string functions SUBSTR, INSTR and REPLACE.

REGEXP_LIKE is basically an operator that is similar to existing LIKE operator.

The above regular expression functions are very efficient and powerful.

A regular ex

Blog site testing.

Just testing things a bit. Sorry if you got spammed with this bog entry. I am posting at both OraFAQ and Oracle forums to try out the two interfaces for blog entries. Also trying and Google Sites.

If you have tried out the blogging and have a preference for one vs another, please let me know.