Does anyone know why the statspack report might show blank Parse CPU to
Parse Elapsed and Non-Parse CPU?

Say I have a lookup table in a database that looks like
ID (PK)
datafield1
datafield2

I spent a little time going through this group and found some older
references to my question, but wanted to get a slightly newer opinion.
We have many Oracle database servers running on Solaris and SPARC
hardware. We have a backup server and large tape library running on

Greetings...
This is an extremely simplified version of the actual problem, just to
make it easier.
I have 2-tables: R(a) and S(a,b)

We have many columns defined as LONG in our data model , and reading
from manual, I suggested that these long columns should be converted to
LOBs . However they said that this may need a change in the application
and so they did not accept the idea...so the question is ..does this

I have a stupid question.  I did following to move a temp file:
(1) alter database tempfile '/old_dir/mytempfile1' offline;
(2) moved tempfile to new directory in OS.
(3) alter database rename file '/old_dir/mytempfile1' to

I have plus trace role enabled and also plan table created on the
schema of the user..now from the server when I login as the user, from
the server itself, I do not get the error, but when I login as the same
user, not from the server , but using oracle client and connect as

I have downloaded Oracle Express 10G. I install it with no errors but
when I try to open the "Go To Database Home Page" I get "the page
cannot be displayed".
I have not changed anytning and try to connect to

Have they made Data Guard (and hence Enterprise edition) a requirement
for 10G?  Or can I set it up the same way I have done for 8i and 9i,
which is to manually move and apply the logfiles via scripts.  I hate
to think I have to saddle a customer with the huge cost increase just

How do you post a question
or or follow up to a question
on asktom.
Every time I go there, there is a backlog and I can not post.

Suppose I have a sql statement like so:
select kind, amount from petstore;
Now, I want to change it so that amount is always null.  I want to do
this, because we have some C++ code that assumes a fixed number of

Thought of this situation while going through one of the threads on
asktom on checkpoint.
Suppose
- uncommitted data is flushed to the disk and

Dear Friends,
I am Abu of Birlasoft Inc, NJ. Birlasoft, my company, part of $ 1.3
Billion CK Birla group of India, has a Strategic Equity participation
by GE Capital and offers IT services worldwide from development centers

Has anyone migrated from Ingres to Oracle recently? Where there any major
issues?
What about migrating;
. procedure/rules to PL/SQL

I'm an experienced Oracle Developer who has suddenly found himself
performing non-essential DBA tasks to take the heat away from our DBA
team, who are currently focussing on bigger and more urgent things.
I've recently created a partitioned table. I would be interested to see