I have a table like this:
ID  | prod_nr  | rate
----|----------|------------
1   |  23      |  8

Since we are developing on Oracle Database 9i we did not do anything
about optimization. The Performance now is horrible. But the
Performance Manager would not open because not supported Charaktercode
American.America.WE8ISO8859P1

ora 9.2.06, AIX 5.2 ML06, IBM Power5, 1 CPU, EMC storage
We have a transaction which consumes about 2-3 gigs undo space in our
test environment. When we run the batch in production, the transaction
was pretty hungry for undo space; it needed more than 40 gigs...Strange

Good Morning,
I know this is dangerous and I will take appropriate safety
precautions.
This is what I'm trying to do and I wonder if it is possible to do it

while taking export I found an error
. exporting synonyms
. exporting views
EXP-00056: ORACLE error 1472 encountered

I am currently working on a data warehouse project with a fact table
that will hold many millions of records over a rolling 6 month period.
The fact table is partitioned by week.
I would like to create a materialized view that will give summary

We are deciding whether or not to implement Oracle 10g grid computing
on Windows 2003.  Does anyone know where I can find some whitepapers or
success stories doing this?  Does anyone have any experience doing this?

Folks;
I am trying to upgrade both the oracle server and client from 8i to
10g.  The server is on a sun box running solaris 9.  The client is
running on a redhat 7.2 system.  My question is this...

I have been having a hard time trying to produce a report with the
following
requirements: The report is a billing report. I hope you can help or
point me

Is there are a more elegant way to know my pid?
I've modified T. Kyte's method of 'Alternative Solution to Provide
Worry-Free Access [to sql trace output' from his Effective Oracle by
Design book (pages 129-135), to allow in session viewing of the trace

My onle experience is only limited in the below
a) install one database with one instance in one server, hence one sid,
one dbname
b) install one database with one instance in one server. I did this the

We have upgraded from Oracle 8 to Oracle 9.2.0.6.
I am getting a bitmap conversion. We do not have a single bitmap index
in our system. Is this possible ? The query is now slow as opposed to
before. We are using an ORDERED hint in the query. Grateful for any

Just a curious question:
When you are duplicating a database which is on a differnt host, why
does it require you to copy the files to the remote host?  Why can't
RMAN use the files on the primiary host?

This is my first posting on this group.
Well i am having a DB with UTF8 characterset and we insert french and
english characters in it. i want to know that when i set my
nls_lang=utf on my client side to insert special characters it give me

I won this at the Oracle Developer Day event in Atlanta, GA.  As much
as I would like to go, I don't really have the time.  I'd rather buy a
new computer instead to make best use of the new tools I discovered at
the event.