on my DB (ORACLE 9.2.0.8) PERFSTAT runs every 30 min.
Can i set other intervals like every 1h or 2h?
Many Thank's
BR

I'm a newbie to oracle & currently learning oracle form & report at
school.  I currently have an existing oracle 10g on my unix machine,
and I need to download & install oracle 10g development suite on my pc
& try connecting to my db on unix server.  I have looked around on

I have two tables Trade table and Cons table. Records are inserted in
both the tables independent of each other. There are fields like
Exc_Ref, Qty, Date in both the tables.
I need to write a query which should give me records :

Using Oracle 10gR1
Apparently, enabling constraints with or without no validate option
and accessing that table across a DBLINK creates deadlock.  Steps are
broken down below

I have two tables Trade table and Cons table. Records are inserted in
both the tables independent of each other. There are fields like
Exc_Ref, Qty, Date in both the tables.
I need to write a query which should give me records :

I have been using solaris(SUN) and linux.
Now, I have a new production machine which run HPUX(I am not that use
to UPUX):
uname -a

does anyone have any references to this and what are the capabilities

Trying to restore to another Sun server using RMAN backup from live
instance. Keep getting:
RMAN> restore controlfile from '/backup/orabackup/fxpr921/
c-876181117-20070902-00';

Any recommendations for a javadoc-like tool for generating documentation
for pl/sql procedures, etc?
Many TIA!
Mark

I am using this version of Pro*C: "Pro*C/C++: Release 10.2.0.1.0"
When I use the following syntax:
     "ORDER BY t1.RELEASE_REASON  ASC NULLS FIRST;"
I get a syntax error.

I have 10g RAC - 2 node cluster. Most of the time the CPU usage range from 50-
60%. Found that using ADDM, some of the queries took most resource. But when
I check from sql*plus the response was quicker and the explain plan output
was also not bad.

anyone know when 11g XE will be available ?
thanks

Can this be done?
Any gotchas?
Thanks
.......

When i connect ma database access to oracle via ODBC i could not see
decimal in the numerical zone ?
If some one could help me ?
thank's

We are facing problem with our Discoverer server. On one box [ Solaris
5.9 ] we have
2 instance of 11.5.10.2 which we cloned from production.
On this test box - For both instances our discoverer page is not