Does someone have information about when oracle will release
stable/production version of Oracle XE
under http://www.oracle.com/technology/products/database/xe/index.html
is written that release is scheduled for late 2005 but i have been told that

Can you, or is it feasible, to rebuild your undo tablespace?   I've
been told that a previous DBA used to rebuild the undo tablespace when
it grew and became too large.
This really does not make sense to me, as I thought you gave the Undo

My OCI program contains an update statement.  Something like:
   UPDATE mytable SET name = :this, id = :that, timestamp = $TODAY
in Unix parlance, it would be like this:
   UPDATE mytable SET name = :this, id = :that, timestamp = `date`

aix 5.2
oracle 9.2.0.7
Seems like it is very straight forward on how to get a job to start at the
top of the hour then start every hour after that.

I need to capture all executions of a query which is executed from
9iAS.
Among other things I need to log userid - any userid that ties to an
individual.

Is there a reason why we have to pay more for licensing for a different
kind of processor?
Why are we not charged for the Hyperthreading on some processors also.
If Oracle is really conserned about the low end business market (small

I'm pretty new to Oracle and need to uninstall a Patchset. (Oracle
9.2.0.7)
There are no backups of the DB or Filesystem as it was before
installing the patchset.

A few months ago we all talked here about how hard it is to get
Oracle 9ir2 to work with Linux, direct i/o and aio, right?
And some might remember the comments back then on the
rigmarole of patches that needs to be applied to 9i to get it to

Metalink #231159.1 discusses the 2GB Windows virtual address space
limitation.
It states as follows: "All memory allocations made by all user
connections and background threads have to fit into 2GBs".

I would like to know how I can collect all stored procedures (SPs),
functions (SFs), packages and SQL calls to the DB between two
timestamps. I tried to write SQL against, DBA_HIST_SNAPSHOT,
DBA_HIST_SYSSTAT, DBA_HIST_SQLSTAT,  DBA_HIST_SQL_PLAN and

Well, I've been searching around...and from what I'm seeing...there is
no way to get Oracle or Oracle client software (SQL*Plus...etc) running
on Linux PPC?
If this not the case...can anyone point me to the download?

I am using Oracle Objects for Ole in an MFC application.  It is
supposed to run 7-24 querying the DB for work to do.
When running, I have found that there are handles leaking.  I have been
able to replicate the problem with the following stripped down code.

Any guesses on whether increasing UNDO_RETENTION has a negative impact
on performance?

 I'm trying to determine how the 10g optimizer calculates the
cardinality and/or cost
 for an index fast full scan.   I do have Jonathan Lewis's latest
book, but I haven't