The query below takes longer to run. It was running fine so far but its
been slow now. It runs as part of a procedure. The procedure returns a
REF CURSOR. I ran DBMS_PROFILER on the procedure. I'm not sure what the
problem is and how I can imrpove the performance.

The installation of Oracle 10g on Windows 2003 failed on a couple of
different servers. By failed, I mean that OUI did not appear.
No warning  or error messages appeared either.
We installed Oracle 10g as part of an SAP installation procedure.

We are trying to upgrade our 9.2.0.5 on AIX 5L to 9.2.0.7.  We want to
run the installer in non-interactive mode.   We receive this error
message:
Error:*** Alert: Invalid staging area. There are no top level

I have the following request ( 9.2.0.5 AIX 5.1 )
with
AND  DVACCPER.ACNTYY  =  '2006'
cost =  518 and elapse 3 hours

Oracle Server Quick Reference Guide
http://quickdba.blogspot.com/2006/05/oracle-server-quick-reference-guide.html
Visit daily to get more updated articles

I try to short dinamically the result my stored procedure.
SP seems not validate the field passed.
I try durectly from my query sw with -ORDER BY 'no word' -
and effecly ther is no error and record return are the same present

Is it possible to set up 2 node 9i rac on linux , such that one node is
allways active and the other one is passive. so that all connections
are allways directed only to the active node?
I think it is possible with data guard , but I do not know for sure..if

I posted this about a week ago but did not get an answer so I'm asking
again. Any help is appreciated.
I have a two node Veritas cluster. Each node of the cluster has two
resource groups. A resource group consists of one EM agent monitoring

I have succeeded in getting Oracle NT authentication working but am
having a related permission problem.
I create Oracle users in this format "OPS$JOHN" for example, as long as
I have a domain user named 'JOHN' in the domain the server is

Using oracle 10g (10.2) on a Windows 2003 server
I'm trying to convert a comma-separated list of alphanumeric strings
into a carriage-return-separated list of strings with bullet points and
first letter as uppercase.

Hi I create block of data using table mybase (it's structure is id
NUMBER PK, name VARCHAR2(20)).
I want to achieve effect that if I lanch the form and I will press
insert new record the new record will have in Id cell the highest next

I use Oracle Application Express and have made a mistake to use a swedish
letter in the tabel name.
How do I drop or rename the table?
The tabelname is 'INKÖPARE_LOOKUP'

I need to somehow simplify/finetune this long query, as it takes about
1/2 hour to run, if not more! Any suggestions?
Regards,
Bernard

Can some advise me how I can move forward with this problem?
I have a large table, with a certain field containing a string. I need
to check the string for certain key words, and if I find them, insert a
value into a different field in the same table.

I am facing memory issues related to an instance Oracle 9i running on
hpux 11.11.
In this box actually I have 14 db up and running and I am almost out of
memory.