I'm *not* talking about the cost as computed by the optimizer here.
Please let's forget this figure.
When, internally, does Oracle consider that a certain join will give
better results than the other to join 2 tables ? Can the algorithm be

Oracle 9.2.0.6 EE on W2K SP3.
As part of our nightly backup procedure we do an RMAN hot backup as
follows:
{

I want to install this client.  Went to OTN Windows Download. It shows
me following files under 9201 installation for Windows 2003 32 bit
Download the Complete Files
        OUI220180.zip (47,405,300 bytes)

I have 2 databases on a box with the same ORACLE_HOME.   Do I run the
'MIGRATE', 'CATPATCH.SQL' & 'UTLRP.SQL' on both databases?

I am trying for the first time to connect VB6 and oracle express 10g (and I
am brand new to oracle)
1 ) I installed, Oracle and the various universall installer
2 ) I created a user with all privileges and a table "CUSTOMERS"

This is our direct client position; we are looking for ETL developer
with ORACLE 11i experience (oracle ERP). Requirements are given below;
if you find any of uor consultant profile appropriate with the given
skills sets then please send me your updated resume ASAP.

someone could tel me how can i do to get a log exp in french
thanks

How do use insert statements to insert millisecs into an oracle table?
CREATE TABLE [dbo].[script] (
   [scriptid]            numeric(20,0) NOT NULL,
   [creationdate]        datetime NOT NULL,

How do I add one millisec to a date in Oracle?
CREATE TABLE [dbo].[script] (
   [scriptid]            numeric(20,0) NOT NULL,
   [creationdate]        datetime NOT NULL,

What is the difference between cache buffer lru chain and cache buffers
chains ?? Are these two different chains with different set of buffered
blocks or two chains maintain buffer block information in two different
ways?

We plan to use ASM for the FLASH recovery location of our database. But
how can the information be backed up to tape, to safeguard against loss
of the entire data center? Is there a way to 'unload' (and reload)
files from an ASM volume?

In using Solaris Pro Compiler to compile Pro*C code. I am getting this
error:
make: Fatal error in reader: parser_proc_online.mk, line 26: Badly
formed macro assignment

we have a unix server running HP-UX hp-adv-2 B.11.11 U 9000/800.
4 processors, Oracle 10.1.0.4.0.
When I do a "drop tablespace MY_TBL_10M including contents and
datafiles", then it sometimes happens that the space in the file

We are setting up a 4 node 10GR2 Rac on RHEL ( 3 or may be 4 ) using
Oracle clusterware. One of my tasks is to test the interconnect with
varying user loads. Possibly use swingbench or oracle's load runner. I
am new to linux - how to do it ? Or do I solely rely on Statspack ?

Subject:  Strange behavior - recursive sql
Platform:  Oracle 9.2.0.6.0 on Solaris 9
In assisting a developer trying to track down a performance issue, I
set up an 'on logon' trigger to start a 10046 trace, then fed the