strange thing happens when i do a query. I am querying contract
numbers, when i query the contract number example..
"F30093-01-C-119190", this is send into the api. The resulting list is
huge, and the contract number Im looking for isn't even in the list.

Oracle 9.2.0.6 EE on Windows
I'm finding that the CBO has some serious limitations when it comes to
evaluating SQL with subqueries in 9i.
It appears that it will Unnest subqueries whenever possibe without any

Over the weekend I tried to install the latest Oracle patch 9.2.0.7.0
over 9.2.0.1.0 on a XP box. However, strange thing happened:
After executing the setup.exe, Oracle begins it's installation,
but shortly after the installation procedure begins, a form poped

This is a datawarehouse system , and parallel query is mostly used.
I am trying to locate the oracle pga memory allocation inside the
process in
order to size my systems memory requirements. I have read the documents

I have a number of Pro*C applications that were compiled on an
AIX machine with Oracle 9.2, and are now expected to be used on
a newer AIX machine with 10g.
Does anyone know how to get it running? We used to run Oracle 7

i have used EMCA to drop my original repository "OEMREP" (after not
being able to successfully rename it) - selecting to remove it in its
entirety (not just repository only).
to my surprise, i found all the files, services etc associated with

In Data Guard, setting LogXptMode = SYNC incurs
a performance penalty on the primary database.
That is because there is latency involved in
writing to the standby redo log.

Is there are any way to do this?
Would like to do this, so that we could look at a single trace file
for a session, instead of multiple ones if a sql requests migrate from
(shared) server to (shared) server.

All,
Is there are a way to completely remove perfstat from the database
(w/o looking through each create script)? (9.2.0.7)
For whatever reason, something keeps not being incremented, and we get

I was trying to fix an export issue and mistakenly ran
@catalog.sql
@catproc.sql
as SYSTEM instead of SYS

After I do an insert to a table is there a way to retrieve the primary
key that was assigned?  I'm just blanking on this, but I'm sure there's
a simple way.  Is there something like:
-- do an insert to myTable

Anybody knows a way to produce output from a SELECT statement on a
single line, instead of each hit on a separate line?
Here is what I mean: let's say I have a table listing families, one per
row that includes the name of father, mother and the number of children.

This question is related to Oracle 9.2.0.6 JDBC.
Please refer to the below program.
Because of some generic code in a lower level of our Java code, we
decided to always use the

 How to define the size of object in tablespaces?  For example, the
size of user occupies in tablespace.
Kai Ming

Windows XP SP2, Oracle 9i Release 2 (9.2.0.1.0), networked machine.
I've installed Oracle 9i Release 2 Enterprise Edition, but the Oracle
Management Server service (OMS) is missing from the Windows services.
I've checked the installed products using Universal Installer and