[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.
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
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
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
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
-
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
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
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
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
-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
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:
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*
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
13 matches
Mail list logo