RE: RBO/CBO question

From: Deshpande, Kirti <kirti.deshpande_at_verizon.com>
Date: Wed, 11 Sep 2002 13:47:57 -0500
Message-Id: <22541.293609@fatcity.com>

Dennis,
Yes, that's the one.
The Vendor loves it. They use it to copy from/to whatever data from 50 databases anywhere on a set of 10 servers.

Kirti

-----Original Message-----
From: DENNIS WILLIAMS [mailto:DWILLIAMS_at_LIFETOUCH.COM] Sent: Wednesday, September 11, 2002 1:37 PM To: 'ORACLE-L_at_fatcity.com'
Cc: 'kirti.deshpande_at_verizon.com'
Subject: RE: RBO/CBO question

Kirti

Is that the venerable SQL*Net COPY command? I say venerable because it is little-documented, hasn't been enhanced in years, and when I called Oracle support several years ago I was told that it would go away soon.

Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com <mailto:dwilliams_at_lifetouch.com>

-----Original Message-----
From: Deshpande, Kirti [mailto:kirti.deshpande_at_verizon.com] Sent: Wednesday, September 11, 2002 2:08 PM To: Multiple recipients of list ORACLE-L Subject: RBO/CBO question

Listers,
How do you set optimizer_goal to 'choose' to take effect for sessions connecting using COPY command?
The database runs with optimizer_mode=RULE. I want to test if CBO would be better for queries used for data selection via COPY.

Thanks.

Kirti -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: kirti.deshpande_at_verizon.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Sep 11 2002 - 13:47:57 CDT