Re: Index Constraint

2002-06-08 Thread Stephane Faroult
[EMAIL PROTECTED] wrote: An example on my understanding of Reverse Key Indices: Say you have a table EMP with a column EMPNO, and an index on this field.This number is incremented sequentially for every new employee that joins in. And as employees retire, say, the records are deleted.

Re: Horrendous Execution Plan from CBO

2002-06-08 Thread Stephane Faroult
Stahlke, Mark wrote: Greetings, One of our developers came to me with a fairly simple query that runs much faster when she uses the RBO. I looked at the execution plans generated by both the RBO and CBO and the CBO's plan is horrible. I was able to get a reasonable plan from the CBO

Re: SQL Question (DISREGARD 1ST MESSAGE, SORRY)

2002-06-08 Thread Stephane Faroult
Viktor wrote: Hello All, It looks as if I've hit a brick wall and I'd very much appreciate if you can help. desc Names FIRST_INIT NOT NULL CHAR(4) SECOND_INIT NOT NULL CHAR(1) INIT_SEQUENCE NOT NULL NUMBER LAST_NAMEVARCHAR2(30) FIRST_NAME

Re: Horrendous Execution Plan from CBO

2002-06-08 Thread Tim Gorman
Mark, What were the elapsed times for each run? You show the AUTOTRACE, but did you have SET TIMING ON? Some notes: The CBO plan isn't so horrendous (although the elapsed times would be useful to either validate or negate that statement). The total logical reads were about 66,000

Re: connect as SYSDBA using ADO

2002-06-08 Thread Jay
From my experience there is no way that you can use a parameter to connect as SYSDBA. I was reading that you are to connect as INTERNAL if you want to connect as SYSDBA. But we all know that is a bad idea and impossible in 9i anyway. If you find away could you let me know. Thanks Jay -

Why is Parallel Query Running after upgrading to 8.1.7.2

2002-06-08 Thread Cherie_Machler
I have just upgraded my 8.0.4 database to 8.1.7.2. Previously, parallel query would only run on objects that a DEGREE set 1. I just checked and all of my tables and indexes have DEGREE set to 1. So are most of my queries now running in parallel? I just checked my init.ora file and I haven't

Re: Why is Parallel Query Running after upgrading to 8.1.7.2

2002-06-08 Thread Tim Gorman
Here's my thinking -- it could be way off the mark... As observed in the output from the 10053 trace, the CBO always considers not only serial full table scans but also parallel full table scans. The big question is exactly what degree of parallelism is it using in its cogitations; I haven't

Install: 9i on 2000, TNS Listener service not installed

2002-06-08 Thread Robert Monical
Starting to play around with 9i. Downloaded and installed on Windows 2000 Workstation. So far so good except no TNS Listener service lsnrctl start from the command line creates a listener. This may be a side effect of installing on Workstation instead of Server. Anyone have any insight? Anyone

Re: Why is Parallel Query Running after upgrading to 8.1.7.2

2002-06-08 Thread Cherie_Machler
Tim, Thanks for replying on a weekend. After doing some reading, I discovered that parallel_threads_per_cpu is set to the default of 2 on our database. With 8 CPUs, we are seeing 16 parallel threads on these queries, when they do go to parallel (a few of them do not). I experimented with

RE: Why is Parallel Query Running after upgrading to 8.1.7.2

2002-06-08 Thread Larry Elkins
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Tim Gorman Sent: Saturday, June 08, 2002 4:53 PM To: Multiple recipients of list ORACLE-L Subject: Re: Why is Parallel Query Running after upgrading to 8.1.7.2 Here's my thinking -- it could be way

RE: Why is Parallel Query Running after upgrading to 8.1.7.2

2002-06-08 Thread Khedr, Waleed
PQ will not be used except degree was defined to a value 1 or set to default. Hints also can trigger that. I would simply get the execution plan for simple sql that access individual tables and the check the plan table if it's serial or using PQO . Waleed -Original Message- To:

Wrong Results Bug in Oracle 8.1.7.1

2002-06-08 Thread MacGregor, Ian A.
SQL SELECT VOUCHER_ID FROM PS_VCHR_MM_VW WHERE ROWNUM 10; VOUCHER_ 3394 3395 3396 3397 3398 3399 3400 3401 3402 set feedback on 1 SELECT VOUCHER_ID FROM PS_VCHR_MM_VW 2*

A bit Off Topic - But need Help

2002-06-08 Thread viraj
Hello all, Sorry I am being a bit off topic, but I am helpless. What I need to know is the details (how, which file to add to, what is the name of the kernel file) of adding storage parameters in kernel. I need for 3 systems, that is Solaris 8 or any version, AIX 4.2.2 or above, and HP-uX