We used to look into the v$sess_io whenever we get a request to find
status of a long running job. And if we see CONSISTENT_CHANGES column
in v$sess_io is increasing then we will say "this session is reading
from undo ".

Does anyone know the maximum number of unions you can use in a SQL query?
For example:
select 1 from dual union all
select 2 from dual union all

I am writing a PL/SQL Block to loop through a series of numbers and
insert them into a row of my table ... but I need to change an alpha
character while I am doing it.
Here is my code:

The Problem: We're getting lots of "ORA-01652: unable to extend temp
segment by 128 in tablespace TEMP1" messages. The DBA enlarged the
TEMP1 segment (added three 1GB tempfiles to it) AND suggested to
"restart the instance once a day" to have better results.

I have installed Oracle 9i client tools on my XP Pro machine, but the
Oracle ODBC driver does not show up as a choice in Data Source
Administrator. Does anybody have any suggestions?
Thanks

Can some one tell me how is it possible to combine
both INDEX and the INDEXED columns to be returned in a single row esp
for a composite index.
Eg : Assume there are 3 index for a table as shown below .

This is very interesting.
Suddenly today, one developer come to me and
said he recompile all his objects cause 20 minutes+.
It used to be like a few minutes.

I am handling a complex query and ultimately the problem boils down to
this.
I have the data in the format
Col1      Col2

Given employee table is :
create table employees (
employee_id number,
manager_id number,

Anybody ever run across apparently extra rows in USER_DEPENDENCIES?
Specifically, I'm seeing a table in the REFERENCED_NAME column for a
stand-alone procedure that does not directly reference the table (or use it
in a %TYPE or %ROWTYPE reference)

All,
I am running Oracle 8i and have run into a problem.  While attempting
to update a row in the database, an exception was thrown (see below).
I caught the exception and attempted to perform a rollback on the

I'm trying to learn how to use Oracle Advanced Queuing. And at the moment
I'm using Oracle 9.2.0.1
I'm writing a simple PL/SQL stored procedure that is supposed to send a
message to a message queue and the beginning of the code goes like this:

I am new to PLSQL.  Here is a sample code from a textbook.  Is the ELSE
checking for 'error > 1 rows' necessary ?  As far I know if there are > 1
rows returned in the SELECT INTO, an exception would be raised before we can
check if %ROWCOUNT >1.

I was wondering if there was a tool sitting out there anywhere that
would enable me to quickly generate CREATE TABLE statements using the
schema used in a set of views?!
I have an application which is running on several hundred views, I know

In bioinformatics tabular separated files (TSV) are quite common. It
occured to me to try to set up Oracle external table (Oracle 10g)
from such a file (GO terms and IDs file from
http://www.geneontology.org/doc/GO.terms_and_ids). I created