RE: Strange behavior with dbms_stats...

FAQ: http://www.orafaq.net -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Query temp segments blank

for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: how to send messages to other users

information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

OT: Who Wrote ...

--- === Michael P. Vergara Oracle DBA Guidant Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

RE: OT: Who Wrote ...

Thank You. -Original Message- Sent: Wednesday, November 26, 2003 4:24 PM To: Multiple recipients of list ORACLE-L Kevin Loney. And you can find the same information in the first version of the DBA Handbook --- Vergara, Michael (TEM) [EMAIL PROTECTED] wrote: I remember seeing

RE: Changing character set

, 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED

RE: RE: How do you genrate primary keys?

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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services

RE: DBA Support Database

want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com

RE: UNIX OT: deleting file starting with --

also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: Do not connect Oracle DB to the Internet. Oracle Alert #59

Tony: I did not receive the attachment clearly. Can you re-send it or cite the source? Thanks, Mike -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Thursday, October 23, 2003 6:25 AMTo: Multiple recipients of list ORACLE-LSubject: Do not connect

HP-UX 11i/Oracle 9.2.0.4/(Semi)Intelligent Agent

see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Tools to Execute Stored Procedures in Debug Mode !

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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services

RE: Strange Request

errors; HTH -- David Lord -Original Message- From: Vergara, Michael (TEM) [mailto:[EMAIL PROTECTED] Sent: 08 October 2003 02:14 To: Multiple recipients of list ORACLE-L Subject: Strange Request Ok...strange request time. I want to test a script that I found on the DBA Village web

Strange Request

--- === Michael P. Vergara Oracle DBA Guidant Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San

RE: Strange Request

Vergara, Michael (TEM) wrote: Ok...strange request time. I want to test a script that I found on the DBA Village web site. It's supposed to capture some information whenever there's a DB error. Does anybody know how to trigger a 'benign' ORA-600 so I can test this functionality? Thanks, Mike

RE: Unintentional Humor

Hey...I don't have a "tnsping0"! Heck, I don't have "agtctl0" or any of the other"*0" programs! How do I install them? Where is the hidden $ORACLE_HOME/bin? If my management finds out that I bungled the install of 9i I could be in deep doo-doo. chuckle ...or not... /chuckle

Oracle analog to xp_fixeddrives

--- === Michael P. Vergara Oracle DBA Guidant Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

HP-UX 11/9iR2/dbv

in line would be started. Anybody done something like this, or am I just an ambitious dreamer? Thanks, Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: archive old data

than 3 years. I would like to find out how you guys usually do this or a best way to do this. Thanks for any inputs in advance. Nancy -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- 858

RE: what is a materialized view ?

of information I have scribbled in the margins. Much has changed, but not everything. Just my 2¢ worth... Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San

HTML Report Question

://www.orafaq.net -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE

RE: How to keep root out?

Well, first of all, root should not be in your dba group... -Original Message-From: Walter K [mailto:[EMAIL PROTECTED]Sent: Thursday, August 28, 2003 8:34 AMTo: Multiple recipients of list ORACLE-LSubject: How to keep "root" out? Just for grins, I'll ask this question...

HP-UX 11/9iR2/Processes

Hi Everyone: I've noticed a new type of background process in my 9iR2 databases. It's name is ora_j00n_SID. Does anyone know what this process is? Any links to Docs? Thanks, Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vergara, Michael (TEM) INET: [EMAIL

RE: Urgent! Is it safe to apply patch Windows2000-KB823980?

on Windows 200 advanced server, anything to be aware here? Any information is very welcomed. TIA Luis Octavio de Urioste -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

Multiple DBs - Balancing Act

--- === Michael P. Vergara Oracle DBA Guidant Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: dba age

://www.orafaq.net -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE

RE: HP-UX 11i/9.2.0.3/Strange Executions

. Cheers, Mike -Original Message- Sent: Tuesday, July 22, 2003 12:54 PM To: Multiple recipients of list ORACLE-L Color may be irrelevant, depending on amount. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED

HP-UX 11i/9.2.0.3/Strange Executions

- Call Stack Trace - --- === Michael P. Vergara Oracle DBA Guidant Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network

RE: HP-UX 11i/9.2.0.3/Strange Executions

Message- Sent: Monday, July 21, 2003 1:21 PM To: [EMAIL PROTECTED] Cc: Vergara, Michael (TEM) Importance: High SIGSEGV = Segment Violation = invalid address = bad code Sounds like you need to contact SAP and/or Oracle support. Jared -- Please see the official ORACLE-L FAQ: http

RE: HP-UX 11i/9.2.0.3/Strange Executions

an opinion is an art ! -Original Message- From: Vergara, Michael (TEM) [mailto:[EMAIL PROTECTED]] Sent: Monday, July 21, 2003 5:05 PM To: Multiple recipients of list ORACLE-L Subject: HP-UX 11i/9.2.0.3/Strange Executions

RE: HP-UX 11i/9.2.0.3/Strange Executions

] -Original Message- Sent: Monday, July 21, 2003 5:20 PM To: Multiple recipients of list ORACLE-L SIGSEGV = Segment Violation = invalid address = bad code Sounds like you need to contact SAP and/or Oracle support. Jared Vergara, Michael (TEM) [EMAIL PROTECTED] Sent by: [EMAIL

RE: HP-UX 11i/9.2.0.3/Strange Executions

ORACLE-L SIGSEGV = Segment Violation = invalid address = bad code Sounds like you need to contact SAP and/or Oracle support. Jared Vergara, Michael (TEM) [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/21/2003 02:04 PM Please respond to ORACLE-L -- Please see the official ORACLE-L FAQ

RE: ora-600 errors for X_$KCBCBH x_$kcbrbh

$KCBCBH view and apply this process. Report back results before proceeding with other views. Thanks, ~ Stefan. *** -Original Message- Sent: Thursday, July 17, 2003 6:59 PM To: Vergara, Michael (TEM) Hi, I have this problem

RE: RMAN SQL Backtrack

Title: Message Ron: I don't know SQL Backtrack, but two things popped into my head as I read your message. One,RMAN does not have a media interface layer. It depends on a utility such as Legato (also currently included with Oracle) or Netbackup or OmniBack. Two,EMC just bought Legato.

RE: Register vs. Load of JDBC driver

the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

WARNING: Re: [suse-oracle] AIO trouble

hardware? 2 Processor Xeon 2GHz 2 Gb RAM a this time cat /proc/cpuinfo processor : 0 vendor_id : GenuineIntel cpu family : 15 model : 2 model -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services

RE: Schedule Analyze using DBMS_STATS ???

,Which is advisable : ANALYZE or DBMS_STATS ? there was a discussion about the same on the list also. but not found any conclusion yet. anu suggestions !!! the ENV is oracle 9.2.0.1/Win2K. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vergara, Michael (TEM) INET

OT: Peoplesoft buys JDEdwards

And in today's news... http://biz.yahoo.com/rb/030602/tech_jdedwards_peoplesoft_6.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

RE: Database character set for Webshpere access

Title: Database character set for Webshpere access Melissa: I've done US7ASCII to WE8ISO8859 with no trouble. I think that since the UTF character set is a superset of ASCII there should be no problems, but I'd try it on a sandbox first. Cheers, Mike -Original Message-From:

RE: dbshut script - shutdown or shutdown immediate

information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Solaris/8.1.7/LOBSEGMENT

. Vergara Oracle DBA Guidant Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: alert log file

When I see a humungous file like that, I build a little ksh script that hasn't failed me yet. suffix=`date +%y%m%d` cp -p alertSID.log alertSID_${suffix}.log alertSID.log The only thing that might happen is if Oracle is updating the log file at EXACTLY the moment you execute this script

RE: Solaris/8.1.7/LOBSEGMENT

AMTo: '[EMAIL PROTECTED]'Cc: Vergara, Michael (TEM)Subject: RE: Solaris/8.1.7/LOBSEGMENT -Original Message- From: Vergara, Michael (TEM) [mailto:[EMAIL PROTECTED]] I'm getting a report that a LOBSEGMENT has reached MAXEXTENTS. How do I modify this? ALTER LOBSEGMENT

HP-UX 11i/8.1.7.4/login.sql

or ignored when using the /NOLOG parameter? Thanks, Mike --- === Michael P. Vergara Oracle DBA Guidant Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vergara, Michael (TEM) INET: [EMAIL

RE: HP-UX 11i/8.1.7.4/login.sql

--- === Michael P. Vergara Oracle DBA Guidant Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vergara, Michael (TEM) INET: [EMAIL

RE: Oracle, Siebel and rule-based optimization

Michael: Would you please post a summary of findings here on the list? I too have a Siebel implementation going on, and we are experiencing performance issues, and have set all the Siebel-specified initSID.ora parameters. I am in California, and the database is 'across the pond' in

RE: Borderline OT - Unix for Oracle at home

Dan: I am running RedHat 7.3 on a Gateway G6-266 in my home LAN. It connects to the web just fine, and my intent is to make it a lightweight web and DB server. I amrunning Oracle 9iR2. It's slow, but it runs. Cheers, Mike -Original Message-From: Fink, Dan [mailto:[EMAIL

HP-UX 11i/8.1.7/DB Link Question

--- === Michael P. Vergara Oracle DBA Guidant Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: Statspack recomendations.

, 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED

RE: AUTORAID and VA7100 disk arrays for rp7400

/shop/cgi-bin/sweetspot.cgi Thanks Mandar -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting

RE: AUTORAID and VA7100 disk arrays for rp7400

, January 23, 2003 12:45 PM To: Multiple recipients of list ORACLE-L Michael, a dumb question. does this stops me from using VA7100 with 0+1 or are u talking about going some other disk array product? Thanks Mandar -Original Message- From: Vergara, Michael (TEM) [mailto:[EMAIL PROTECTED

RE: Win2k/8.1.7/SQL Question

to develop a strategy for the "retrofit." This is so weird for me... having to unlearn Oracle syntax in order to write ANSI SQL. Sigh... -Original Message- From: Vergara, Michael (TEM) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 14, 2003 4:54 PM To: Multiple recipien

Win2k/8.1.7/SQL Question

-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: New course for 9i - Dumps/Crashes from Oracle University

Title: RE: New course for 9i - Dumps/Crashes from Oracle University I took this seminar set last year for Oracle 8i. It's really very good, but only a little was able to really soak in. I'm trying to convince manglement to let us go again. I had a professor in college who's first lesson was

Oracle 8i/HP-UX,Solaris,Windows/Active Directory Question

://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from

RE: SQLPLUS spool file question

Title: SQLPLUS spool file question Mark: Here is what I usually set in a SQL*Plus script where I will want to spool the output: set echo off pause off termout on feedback on set pagesize 55 linesize 95 tab off trimspool on I rarely use 'sqlplus -s', and I do not get the '^L' character in

RE: SQLPLUS spool file question

may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Win2k/8.1.7.3/Optimizer Weirdness

*/ file_name from dba_temp_files; no rows selected SQL --- === Michael P. Vergara Oracle DBA Guidant Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL

RE: Win2k/8.1.7.3/Optimizer Weirdness

Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Solaris 2.7/8.1.6.3/Listener

-- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from

RE: database link tuning

: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network

RE: RAID5+

FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

HP-UX 11i/8.1.7/SAP

ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: auditing CREATE DATABASE

, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E

HP-UX11/Oracle 8.1.6/Constraint Question

Oracle DBA Guidant Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Space... confusion

ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: ora-01115 after datafile autoexetend from 3.9 GB to 4.1 GB

Title: Message This is interesting. I had a vendor do an install on one of our NT servers, and they set the files to autoextend to 8GB. When I modified that limit down to 2GB (our company standard) they clouded up and rained all over me! They said there was no physical reason to limit the

RE: Table Scans

for the AND standard.bitand(x.flag,524288)0 clause? Thanks, Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web

RE: Is it possible to copy one db to another if the SID is different

DATABASE TEST RESETLOGS ARCHIVELOG ^^^ And when you ALTER DATABASE OPEN you'll also need to say RESETLOGS. HTH, Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- 858

RE: OT: Why do I receive the mails late?

1-2 hours. Is this common? Sometimes i get the reply first and then i get the question Regards Naveen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: logon trigger

SORT_AREA_SIZE = 10485760; Alter session set OPTIMIZER_MODE = choose; end; / George -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: Utl_file and OPENVMS

: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE

Oracle 8.1.6.2/HP-UX 11i/Reorg IOT

--- === Michael P. Vergara Oracle DBA Guidant Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: 8.1.6 to 8.1.7 upgrade

for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting

HP-UX 11i/8.1.7.x/Oracle-to-AD

Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Cannot start database (already running)

the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Win2000/8.1.7.3.0/SQL

://searchdatabase.techtarget.com/tip/1,289483,sid13_gci778766,00.html. I hope you find it useful. Cheers, Mike -Original Message-From: Anand Kumar N [mailto:[EMAIL PROTECTED]]Sent: Monday, August 19, 2002 9:05 PMTo: Vergara, Michael (TEM)Subject: Re: Win2000/8.1.7.3.0/SQL U'r prompting in this SQL

RE: Win2000/8.1.7.3.0/SQL

or OPTIMIZER_GOAL. Using a RULE hint will override the optimizer settings. I'm guessing that degree is 1 and you have old statistics. Jared On Monday 19 August 2002 17:58, Vergara, Michael (TEM) wrote: Ok...this is strange. The optimizer_mode is set to RULE, but if I put a RULE hint into the SQL

RE: Win2000/8.1.7.3.0/SQL

then CBO will be used regardless of OPTIMIZER_MODE or OPTIMIZER_GOAL. Using a RULE hint will override the optimizer settings. I'm guessing that degree is 1 and you have old statistics. Jared On Monday 19 August 2002 17:58, Vergara, Michael (TEM) wrote: Ok

RE: Win2000/8.1.7.3.0/SQL

it work, this may not be the problem. Dan. -Original Message- From: Vergara, Michael (TEM) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 20, 2002 10:05 AM To: Multiple recipients of list ORACLE-L Subject: RE: Win2000/8.1.7.3.0/SQL Dan: When you did a 'select degree from

RE: Win2000/8.1.7.3.0/SQL

structures with a SQL interface. You might want to investigate using the ORDERED hint and changing the order of your driving tables. If your execution plan is using NESTED LOOPS, put the expensive one first ( driving table ). HTH Jared Vergara, Michael (TEM) [EMAIL PROTECTED] Sent

RE: Win2000/8.1.7.3.0/SQL

from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: Win2000/8.1.7.3.0/SQL

) Note: Even if the parameter OPTIMIZER_MODE is set to RULE, the use of these features enables the CBO. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

RE: Win2000/8.1.7.3.0/SQL

- From: Vergara, Michael (TEM) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 20, 2002 4:34 PM To: Multiple recipients of list ORACLE-L Subject: RE: Win2000/8.1.7.3.0/SQL John: That makes perfect sense in view of the fact that only the /*+ RULE */ hint makes the query run. I'm

Win2000/8.1.7.3.0/SQL

--- === Michael P. Vergara Oracle DBA Guidant Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538

RE: Win2000/8.1.7.3.0/SQL

FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Win2000/8.1.7.3.0/SQL

to investigate the SORT_AREA_SIZE parameter or maybe just look at increasing the available memory to the instance. Cheers -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX

RE: Win2000/8.1.7.3.0/SQL

: Monday, August 19, 2002 4:28 PM To: Multiple recipients of list ORACLE-L or is that 1 db set to first_rows? If so try the query with a rule hint? Bruce Reardon -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City

RE: compile invalid objects

I have written scripts like this in the past, but the problem I run into is that recompiling some objects invalidates others, sometimes in a circular loop. What I'd like to find/see/learn-how-to-do is a script that compiles things in dependency order. So far, this capability eludes me. I

RE: Cognos-unix???

on hp-ux 10.20 a while ago. The tool was Cognos Tranformer. We decided to build the cubes on the unix box (instead Win NT) then ftp the cubes on a Winframe server. Which tool do you want to install ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM

RE: Oracle9i Installation Error

I haven't started playing with 9i yet, but this message sounds like a message from one of the optional components. I usually get something like this when I'm applying a patch and the patched component does not exist. Ah HA! I checked one of my more obscure systems and found that the 'ctx'

Oracle vs. DB2

-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

HP-UX 11.0/8.1.6.2/Parameters

if this is a modifiable setting. Thanks, Mike --- === Michael P. Vergara Oracle DBA Guidant Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City

RE: UNIX Q: How do I delete files beginning with #

the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Rant

recoveries before, but never this scenario. Thanks, Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet

RE: EMN0

? It deals, from what I have gathered, with Java in the database (maybe?). Thanks in advance for any advice April Wells Corporate Systems Amarillo Texas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network

RE: Rant

ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: EMN0

: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Cognos

') 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael

RE: RE: Cognos

To: Vergara, Michael (TEM); Multiple recipients of list ORACLE-L John, One last point to add to my reply of before. They don't support HP-UX, actually I don't think they support any Unix. Dick Goulet Reply Separator Author: Vergara; Michael (TEM) [EMAIL

  1   2   >