I'm trying to find anyone that can advise on an issue I've observered
on one of my AIX servers BTW I'm a unix admin and not an Oracle
guru ). The issue appears to be an Oracle process which is the parent
of all the forms process f60runm when the total of the parent and the

Oracle 10.2 on linux ...
Is there any inbuilt way of calculating the average for values in separate
columns of a table across a row (cf. the average of values in rows for a
column) which allows for null values?

Table t1 has two fields s1,s2 both with type NUMBER(9,3),
After I exectue following sql,
"SELECT s1, (s1-s2)/s2 FROM t1"
result is:

We are using a flattened table for the Reports. This table is called
as JP_HISTORY_TBL. This table is like a Data Warehouse having all the
required fields for the reports in a flattened structure. So it has
the codes as well as the description. For Example it has the Member

DB = Oracle9i Release 9.2.0.1.0 - Production
OS = Windows XP sp2
Our test database refuses to run any jobs. CJQ0 is there, but does not
start up any Jxxx processes.

I work in networking and our Unix group is implementing their first
Oracle RAC cluster.  I have been assisting with this implementation
and have a few questions.
The Oracle RAC VIP -   I'm familiar with the concept of VIP's but a

We run 11.5.10.2 EBS.  Running on oracle 10.2.0.2  We currently do not
use rman for backups.  We back up the system using TSM daily with the
system down.  We don't have to have 100% up time.  We have archivelog
turned on.  We keep 365 days worth of these incremental backups.  We

I made a mistake and deleted undotbs01.dbf.
now i try to restart the server without success.
i try to recreate an undo tablespace too, but it is not possible due
to "database not open" error and if i try to "alter database open" i

www.bootstraptech.com
We need 100 Oracle Applications Professionals for
Bootstrap's Oracle Knowledge Park
Bootstrap Technologies Private Limited, Global Systems integration and

I have a table with Devices and a Status table and want to create a view
 which returns the Info of the device and the last known status
The tables:
DEVICE

This is RAC 10gR2.
In a basic fail-over configuration, with no cluster managed database
service configured and with client-side fail-over enabled, I've
noticed that no fail-over occurs whenever an instance is in MOUNT

I hope someone whos reads this can help me.
In Oracle Enterprise Manager 10g web interface, I am not able to view
User detail to add role and privileage to it.
An error message pops : "An error occured when processing this

I've got a problem with byte values in Oracle (version 10g). I need to
store a fixed number of bytes. Usually it's less then 10 kilobytes. I
tried to use the data type RAW, but there is a limitation that only
one column of this type may be created in a table. But I need more

Dear group,
I loaded data from a file coming from other source, in sqlplus, some
of the data appear as space, but they are NOT.  And it will cause our
application which uses xml to fail.

Sorry for my english, i'll try to explain my problem
I'm working with Crystal Report X and i call a oracle stored
procedure.
One of the parameter (ListOfPoint) of crystal is a multi value (id of