Tracy,
Take a look at the thing calling this 43,814
times. Can this query be used as an inline view for the thing using this querys
result set? If so, then youll eliminate 87,629 database calls.
As Tom Kyte says, Tune the
QUESTION, not the query.
Cary Millsap
Hotsos Enterprises
Jolene,
Mladen's answer is a good one. There is also an in-depth discussion on
this subject on pp210-217 of the book Optimizing Oracle Performance.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
* Nullius in verba *
Upcoming events:
- Performance Diagnosis 101: 1/27 Atlanta
- SQL
you the chance to
eliminate that waste and go forward on a less expensive infrastructure
than you might have imagined if you had studied it only on paper.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
* Nullius in verba *
Upcoming events:
- Performance Diagnosis 101: 1/27 Atlanta
difficult on the users once the journey began. :)
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
* Nullius in verba *
Upcoming events:
- Performance Diagnosis 101: 1/27 Atlanta
- SQL Optimization 101: 2/16 Dallas
- Hotsos Symposium 2004: March 7-10 Dallas
- Visit www.hotsos.com
I dont think this one made it
through on my first attempt.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Nullius in verba
Upcoming events:
- Performance
Diagnosis101: 1/27 Atlanta
- SQL Optimization101: 2/16 Dallas
- Hotsos Symposium 2004:
March 710 Dallas
- Visit
being traced.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance Diagnosis 101: 1/27 Atlanta
- SQL Optimization 101: 2/16 Dallas
- Hotsos Symposium 2004: March 7-10 Dallas
- Visit www.hotsos.com for schedule details...
-Original Message-
[EMAIL
Interesting. Of course, Gummi's right: I blew both my course URLs in my
note. The correct URL for the PD101 coruse is
http://www.hotsos.com/courses/PD101.php, too. Slow connection; didn't
have time to check thoroughly; sorry for the inconvenience.
Thanks, Gummi.
Cary Millsap
Hotsos Enterprises
My question, Richard, is can a person pass the exam just by studying
what is correct? Or is it necessary to work harder to acquire some
veneer of false knowledge specifically in order to pass the exam?
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance
, but probably some of the same release 7
questions are still on the test.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance Diagnosis 101: 1/27 Atlanta
- SQL Optimization 101: 2/16 Dallas
- Hotsos Symposium 2004: March 7-10 Dallas
- Visit www.hotsos.com
/NJ or Botson. I expect
this year we'll do one event in one of these locations sometime this
summer or fall. We'll post our Q3 calendar sometime toward the end of
Q1.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance Diagnosis 101: 1/27 Atlanta
- SQL
, and we spend a lot more time practicing case studies in the course
than the book does.
The OP101 course and the book are almost totally independent.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance Diagnosis 101: 1/27 Atlanta
- SQL Optimization 101: 2/16
WinCVS has worked well for us and several of our friends. www.wincvs.org
If I recall correctly, it's free.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance Diagnosis 101: 1/27 Atlanta
- SQL Optimization 101: 2/16 Dallas
- Hotsos Symposium 2004: March 7
what
would otherwise have been thousands of connections/disconnections and parse
calls per day. All the db gets are binds, executes, and fetches except for the
first few minutes after instance start-up.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance
/appearances/adams2004.03.php.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance Diagnosis 101: 1/27 Atlanta
- SQL Optimization 101: 2/16 Dallas
- Hotsos Symposium 2004: March 7-10 Dallas
- Visit www.hotsos.com for schedule details...
-Original Message
In-line...
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance Diagnosis 101: 1/27 Atlanta
- SQL Optimization 101: 2/16 Dallas
- Hotsos Symposium 2004: March 7-10 Dallas
- Visit www.hotsos.com for schedule details...
-Original Message-
Boris Dali
Boris,
Cursor #0 seems reserved for two special uses: (1) wait events
associated with COMMIT processing (also, of course, ROLLBACK and
SAVEPOINT), and (2) wait events associated with dbcalls not instrumented
because of bug 2425312.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
by the event. That is, if you can eliminate the dbcall that
follows, then you can eliminate the between-call event (and its elapsed
time). The assignment of blame is what forward attribution is about.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance Diagnosis
.
Connor's script is a neat means of jarring someone out of the belief
that a good hit ratio necessarily indicates good performance.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance Diagnosis 101: 1/27 Atlanta
- SQL Optimization 101: 2/16 Dallas
- Hotsos
detail.)
It's not the ratio that needs condemning, it's the advice about how to
use the ratio. The ratio just happens to be the emblem on the flag.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance Diagnosis 101: 1/27 Atlanta
- SQL Optimization 101: 2/16
I hope not, but I think so.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance Diagnosis 101: 1/27 Atlanta
- SQL Optimization 101: 2/16 Dallas
- Hotsos Symposium 2004: March 7-10 Dallas
- Visit www.hotsos.com for schedule details...
-Original
,
and test their code.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance Diagnosis 101: 1/27 Atlanta
- SQL Optimization 101: 2/16 Dallas
- Hotsos Symposium 2004: March 7-10 Dallas
- Visit www.hotsos.com for schedule details...
-Original Message-
[EMAIL
Avnish,
The book goes through this a bit on p61. There are a few tools out
there, including three from Oracle. As I mention in the book, I use our
own Hotsos Profiler, described at www.hotsos.com/products/profiler.html.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming
not to mention running 48 batch jobs on a 8CPU box with all of them
committing after every record and using the table to generate keys
(Cary
would love this one) ;) They wanted to find other reasons and he
conveniently ignored the real problem.
Beautiful...
Cary Millsap
Hotsos
No, no, no! Definitely not me. I'm 99.999% certain not Mogens or Anjo
either. I don't think Steve either (80% sure). Not sure about the
others.
Thank you for the sentiment, though!
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance Diagnosis 101: 12/16
The answer to your first question is Correct.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance Diagnosis 101: 12/16 Detroit, 1/27 Atlanta
- SQL Optimization 101: 12/8 Dallas, 2/16 Dallas
- Hotsos Symposium 2004: March 7-10 Dallas
- Visit www.hotsos.com
life to teach people NOT to do.
So, to the list, and to Rich, please accept my apology.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance Diagnosis 101: 12/16 Detroit, 1/27 Atlanta
- SQL Optimization 101: 12/8 Dallas, 2/16 Dallas
- Hotsos Symposium 2004
Science is the belief in the ignorance of experts. --Richard Feynman
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance Diagnosis 101: 12/16 Detroit, 1/27 Atlanta
- SQL Optimization 101: 12/8 Dallas, 2/16 Dallas
- Hotsos Symposium 2004: March 7-10 Dallas
By more sophisticated I/O, I
mean things like: read and write files anywhere from a byte at a time to a
whole file at a time, do buffered C-like stuff (getc, ungetc), read and write
directly with compressed output, get and set tty attributes, do graphics, and
so on.
Cary Millsap
The only thing I think I disagree with is
the word almost.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance
Diagnosis101: 12/16 Detroit, 1/27 Atlanta
- SQL Optimization101: 12/8 Dallas, 2/16 Dallas
- Hotsos Symposium 2004:
March 710 Dallas
not attempt to combine your Bus.Tx# data in the way you
describe.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance Diagnosis 101: 12/16 Detroit, 1/27 Atlanta
- SQL Optimization 101: 12/8 Dallas, 2/16 Dallas
- Hotsos Symposium 2004: March 7-10 Dallas
- Visit
My answers are in-line, preceded with [Cary Millsap]...
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance Diagnosis 101: 12/16 Detroit, 1/27 Atlanta
- SQL Optimization 101: 12/8 Dallas, 2/16 Dallas
- Hotsos Symposium 2004: March 7-10 Dallas
- Visit
mentioned previously in this thread.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance Diagnosis 101: 12/16 Detroit, 1/27 Atlanta
- SQL Optimization 101: 12/8 Dallas, 2/16 Dallas
- Hotsos Symposium 2004: March 7-10 Dallas
- Visit www.hotsos.com for schedule
of the knee for a given number of parallel service channels
(for example, CPUs in your case) on Table 9-3 on p260 of Optimizing
Oracle Performance.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance Diagnosis 101: 12/16 Detroit, 1/27 Atlanta
- SQL
regular _expression_ processing
is spectacular compared to anything else out there; this is critical for text
processing (lexical analysis and parsing).
-
Perl is more portable,
more easily extensible, and better supported with lots of interesting open
source libraries than Unix shells.
Cary
1. latch free for the shared pool latch (a shared pool latch in 9i).
2. Indirectly, SQL*Net message from client and CPU service time
consumption too, because not using bind variables probably means that an
application parses more often than it needs to.
Cary Millsap
Hotsos Enterprises, Ltd.
http
by comparing pairs of gettimeofday() calls
(truss to find out for yourself). The e=40us is actually accurate to
within +/-1us (not counting measurement intrusion effect). The c value
is potentially way off, as I explained in the other note.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
You're on the right trail by experimenting with it. I'm surprised that
the number of gettimeofday() calls is so small. The times() call is the
SVR4 analog of the BSD getrusage() call. I guess I shouldn't be
surprised to see both times() and getrusage() being used.
Cary Millsap
Hotsos
this information to full
advantage.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance Diagnosis 101: 12/16 Detroit, 1/27 Atlanta
- SQL Optimization 101: 12/8 Dallas, 2/16 Dallas
- Hotsos Symposium 2004: March 7-10 Dallas
- Visit www.hotsos.com
with what I've said here.
Happy Thanksgiving, everyone.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance Diagnosis 101: 12/16 Detroit, 1/27 Atlanta
- SQL Optimization 101: 12/8 Dallas, 2/16 Dallas
- Hotsos Symposium 2004: March 7-10 Dallas
- Visit
V$SYSSTAT has a NAME attribute. V$SESSTAT doesn't. So seeing the name
when you're using V$SESSTAT requires a join with V$STATNAME.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance Diagnosis 101: 12/16 Detroit, 1/27 Atlanta
- SQL Optimization 101: 12/8
is a reduced hard parse count. If you parse outside the loop
(in which case, you MUST use bind variables), then you reduce your
number of parse calls. A soft parse is a little cheaper than a hard
parse. NO PARSE is a lot cheaper than a soft parse.
Cary Millsap
Hotsos Enterprises, Ltd.
http
Not a coincidence. See Optimizing Oracle Performance, Chapter 12, Case
3: Large SQL*Net Event Duration on pages 337-344. See also the SQL*Net
material on pp311-315.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance Diagnosis 101: 11/19 Sydney, 12/16
.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance Diagnosis 101: 11/19 Sydney, 12/16 Detroit
- SQL Optimization 101: 12/8 Dallas, 2/16 Dallas
- Hotsos Symposium 2004: March 7-10 Dallas
- Visit www.hotsos.com for schedule details...
-Original Message
Barb,
What you're really after is called forward attribution in the book.
You need to see the dbcall that immediately follows each WAIT
nam='SQL*Net message from client' event in the trace file. This will
tell you what database call's execution it was that ended the read().
Cary Millsap
Hotsos
To finish off the answer to your direct question, compute the sum of the
ela values shown in your excerpt:
0 cs
0
1
0
0
0
1
1071
---
1073 cs = 10.73 seconds
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance Diagnosis 101: 11/19
I agree as Step 1, but I expect that you'll find quickly that the issue
is a big c value for the EXEC on the block. If you do find this, then it
indicates exactly what's been suggested several times already: use
DBMS_PROFILER to dig into the response time of the EXEC.
Cary Millsap
Hotsos
The implementations I've seen all did SELECT...FOR UPDATE.
Works.
Doesn't scale.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance Diagnosis 101: 11/19 Sydney
- SQL Optimization 101: 12/8-12 Dallas
- Hotsos Symposium 2004: March 7-10 Dallas
- Visit
), lots of unnecessary CPU service consumption
due to the spinning (especially if you try to tinker with _spin_count),
and possibly a wide range of side effects including write complete
waits waits and others.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance
Yep, in the USA, SSN is very not unique.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance Diagnosis 101: 11/19 Sydney
- SQL Optimization 101: 12/8-12 Dallas
- Hotsos Symposium 2004: March 7-10 Dallas
- Visit www.hotsos.com for schedule details
That's it. If you didn't use the cache, then it would cause the same
problem as with normal table-managed sequence numbers. But with cached
sequence numbers, an application can get a sequence number without
touching the database (SEQ$) at all.
Cary Millsap
Hotsos Enterprises, Ltd.
http
problems unless you have only a
single-user system.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance Diagnosis 101: 11/19 Sydney
- SQL Optimization 101: 12/8-12 Dallas
- Hotsos Symposium 2004: March 7-10 Dallas
- Visit www.hotsos.com for schedule details
I've never heard of an Oracle sequence not generating unique id's,
OPS/RAC or not. Gaps, yes. Overlaps, never.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance Diagnosis 101: 11/19 Sydney
- SQL Optimization 101: 12/8-12 Dallas
- Hotsos Symposium 2004
I've heard of people using instance startup triggers to insert VOID
records in cases where there are gaps. I haven't thought about it much
recently, but I can't presently think of occasions when gaps occur other
than instance shutdown.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Well, there you go. :)
I will crawl back into my tiny little focus area now.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance Diagnosis 101: 11/19 Sydney
- SQL Optimization 101: 12/8-12 Dallas
- Hotsos Symposium 2004: March 7-10 Dallas
- Visit
in
properties of the insertion and deletion methods used to manipulate
them. For complete information, see Knuth's The Art of Computer
Programming, Volume III: Sorting and Searching, pp473-480.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance Diagnosis 101: 10/28
tim.pl is the program shown on p134 of Optimizing Oracle Performance.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance Diagnosis 101: 10/28 Phoenix, 11/19 Sydney
- SQL Optimization 101: 12/8-12 Dallas
- Hotsos Symposium 2004: March 7-10 Dallas
- Visit
was too much to cache in one's head anyway, so I
didn't worry so much about making this part flow. I expected that
Parts I and III would be full-scanned by a wide audience, and that Part
II would be index range-scanned by a narrower audience. :)
Cary Millsap
Hotsos Enterprises, Ltd.
http
Title: 10046 trace data question
In release 8, its V$TIMER.HSECS.
In release 9, it varies by platform. Its
the unadulterated value of gettimeofday() on our Linux server.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance
Diagnosis101: 10/28
Bingo. I've included a few more details in a separate note sent just
prior to my receiving this one.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance Diagnosis 101: 10/28 Phoenix, 11/19 Sydney
- SQL Optimization 101: 12/8-12 Dallas
- Hotsos Symposium
resources. SMON's automatic coalescing wastes even more. Always did;
still does.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance Diagnosis 101: 10/28 Phoenix, 11/19 Sydney
- SQL Optimization 101: 12/8-12 Dallas
- Hotsos Symposium 2004: March 7-10 Dallas
it
*should* be set to almost everywhere).
- You can turn off SMON's ridiculous CPU-consuming, lock-holding
behavior by setting event 10269.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance Diagnosis 101: 10/28 Phoenix, 11/19 Sydney
- SQL Optimization 101: 12/8-12
a simple FF scan,
using extended SQL trace (event 10046 level 8).
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance Diagnosis 101: 10/28 Phoenix, 11/19 Sydney
- SQL Optimization 101: 12/8-12 Dallas
- Hotsos Symposium 2004: March 7-10 Dallas
- Visit
by Jim Kennedy and Anna Everest,
which you can read about at http://www.interviewedge.com/.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance Diagnosis 101: 10/28 Phoenix, 11/19 Sydney
- SQL Optimization 101: 12/8-12 Dallas
- Hotsos Symposium 2004: March 7
to survive in business you have to be *competitive*.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance Diagnosis 101: 10/28 Phoenix, 11/19 Sydney
- SQL Optimization 101: 12/8-12 Dallas
- Hotsos Symposium 2004: March 7-10 Dallas
- Visit www.hotsos.com for schedule
:)
I didn't study that stuff very much in my last five years at Oracle.
Fast-full index scans weren't around when I was digging in the dirt.
Anyway, things change across versions, and it's impossible to remember
everything in one brain anyway...
So,... test!
Cary Millsap
Hotsos Enterprises
have gotten had I
bought the Tanner book. It's probably not a completely fair assessment,
but it's all I had to work with in a 10-minute window.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance Diagnosis 101: 10/28 Phoenix, 11/19 Sydney
- SQL
Bambi,
Be careful. Many will fall in love with you if you continue to submit
such things as this to the list.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance Diagnosis 101: 10/28 Phoenix, 11/19 Sydney
- SQL Optimization 101: 12/8-12 Dallas
- Hotsos
dont know how
they could have confirmed or refuted my statements
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance
Diagnosis101: 10/28 Phoenix, 11/19 Sydney
- SQL Optimization101: 12/812 Dallas
- Hotsos Symposium 2004:
March 710 Dallas
- Visit
why something works in order to use it. I tried to design Parts I and
III to give you what you need to make the method work, regardless of
whether you are interested in proving out the theory. I just didn't feel
like it would be responsible to sell Part III without including Part II.
Cary Millsap
to start
rearranging the names of things that have been studied carefully by
several generations of scientists since the early 1800s. See p228 for
more info on this.
/personal-hypothesis
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance Diagnosis 101: 10/28
indicates that nothing was written, in the
case of pwrite, or end of file, in the case of pread), or
-1 on error, in which case errno is set to indicate the
error.
Therefore, my DBWR is writing 4,096 bytes at a time.
Cary Millsap
Hotsos Enterprises, Ltd.
http
Oops, I didn't see that part. Thanks for the catch, Hemant.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance Diagnosis 101: 10/28 Phoenix, 11/19 Sydney
- SQL Optimization 101: 12/8-12 Dallas
- Hotsos Symposium 2004: March 7-10 Dallas
- Visit
performance analyst to meet. We have tried to
further stimulate the revolution of Oracle performance methods from the
very weak and inefficient checklist-based methods to a more efficient
scientific approach.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance
No, the most complete and detailed queueing theory thing I've ever done
is Chapter 9 of the book. You might be thinking of Batch Queue
Management and the Magic of '2', which is a completely different thing.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events
available for free at www.oreilly.com. I think relevance, common
sense, self-confidence, and the ability to communicate effectively are
much more important (and actually more difficult to learn) than a lot of
the more obvious educational factors.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Fyi, Oracle updated note 182699.1 last Friday. The inaccurate statements
about index fragmentation have been removed.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance Diagnosis 101: 10/28 Phoenix, 11/19 Sydney
- SQL Optimization 101: 12/8-12 Dallas
I think you need this instead:
select *
from mytable
where mycol like '\%%' escape '\'
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance Diagnosis 101: 10/28 Phoenix, 11/19 Sydney
- SQL Optimization 101: 12/8-12 Dallas
- Hotsos Symposium 2004: March 7
(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: Cary Millsap
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051
level 8 or 12).
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance
Diagnosis101: 10/28 Phoenix, 11/19 Sydney
- Hotsos Symposium 2004:
March 710 Dallas
- Visit www.hotsos.com for schedule
details...
-Original Message-
From: [EMAIL PROTECTED
using hints upon the SQL to coax
the optimizer into using the plan you want, but I would advise doing
this only in unusual circumstances. If all your other work is done
properly, then I would submit that it's usually a good idea to eliminate
hints from your SQL.
Cary Millsap
Hotsos Enterprises
that requires
registration. Youll find it at http://www.hotsos.com/catalog.
I hope it helps...
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance
Diagnosis101: 10/28 Phoenix, 11/19 Sydney
- SQL Optimization101: 12/812 Dallas
- Hotsos Symposium 2004:
March 710
of the motives I had for writing the book. I believe
that an idea with a real book behind it is a lot more likely to have
weight in a bureaucracy than an idea without a book behind it. For some
reason, a book is like a necktie for ideas.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Title: RE: RE: Cary's Book - new topic
Hotsos Profiler will handle it, no problem.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance Diagnosis101:
10/28 Phoenix, 11/19 Sydney
- Hotsos Symposium 2004:
March 710 Dallas
- Visit www.hotsos.com
, the following *is* true: You should separate indexes and data
into different tablespaces because there are several legitimate reasons
to do so.
http://www.hotsos.com/dnloads/0.Millsap1995.09.24-OFA.pdf for more
information.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events
you're watching.
From there, it's all downhill.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance Diagnosis 101: 10/28 Phoenix, 11/19 Sydney
- Hotsos Symposium 2004: March 7-10 Dallas
- Visit www.hotsos.com for schedule details...
-Original Message
: none.
...But I haven't tested it.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance Diagnosis 101: 10/28 Phoenix, 11/19 Sydney
- Hotsos Symposium 2004: March 7-10 Dallas
- Visit www.hotsos.com for schedule details...
-Original Message-
[EMAIL
today. Actually, don't misunderstand: the BCHR *is* useful, and it
always has been. When it's really close to 100%, it's an almost total
guarantee that you have some really serious performance problems. This
statement has been true since at least Oracle V5...
Cary Millsap
Hotsos Enterprises, Ltd
, only to have a drill sergeant
tell me that no, his shop's not going to do it that way because a big
copper and red book says you should do it differently.
That day was a big splash of cold water. I have tried to react
productively to it. :)
Cary Millsap
Hotsos Enterprises, Ltd.
http
/;;[^;]
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance Diagnosis 101: 10/28 Phoenix, 11/19 Sydney
- Hotsos Symposium 2004: March 7-10 Dallas
- Visit www.hotsos.com for schedule details...
-Original Message-
[EMAIL PROTECTED]
Sent: Thursday
Yep. Much better than mine.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance Diagnosis 101: 10/28 Phoenix, 11/19 Sydney
- Hotsos Symposium 2004: March 7-10 Dallas
- Visit www.hotsos.com for schedule details...
-Original Message-
McBain, Neil
If you exited the Oracle session without deactivating the trace, then
you should probably see a XCTEND as well, right? If you see the XCTEND
but no STAT lines, then I think you've found a bug.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance Diagnosis
of Configuring Oracle Server for VLDB, both available for free at
www.hotsos.com.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance Diagnosis 101: 10/28 Phoenix, 11/19 Sydney
- Hotsos Symposium 2004: March 7-10 Dallas
- Visit www.hotsos.com for schedule
Niall,
I think you've specified the right test.
However, whether to separate indexes from data is an easier argument.
All it takes is one of potentially dozens of reasons, and isolating
becomes the right idea.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events
Oh man... now I see the problem.
Well, IMHO, Kevin's advice is the right advice for the wrong reasons.
It's not the OFA.
Thanks, Jacques, for pointing that out.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance Diagnosis 101: 10/28 Phoenix, 11/19
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: Cary Millsap
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego
will ask you
while you're in school. There's the correct answer, and there's the
answer that the teacher wants. I expect you to know them both.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance Diagnosis 101: 10/28 Phoenix, 11/19 Sydney
- Hotsos Symposium
Title: RE: DBA needed in Austin, TX
It rains sand in Amarillo. Ive seen it.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance Diagnosis101:
10/28 Phoenix, 11/19 Sydney
- Hotsos Symposium 2004:
March 710 Dallas
- Visit www.hotsos.com
I'd be interested to see the sequence of tests that support the
hypothesis that disk sorts are about 14,000 times slower than memory
sorts.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance Diagnosis 101: 10/28 Phoenix, 11/19 Sydney
- Hotsos Symposium
that a cynical view, just a practical one.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance Diagnosis 101: 10/28 Phoenix, 11/19 Sydney
- Hotsos Symposium 2004: March 7-10 Dallas
- Visit www.hotsos.com for schedule details...
-Original Message
v$session.type
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance Diagnosis 101: 10/28 Phoenix, 11/19 Sydney
- Hotsos Symposium 2004: March 7-10 Dallas
- Visit www.hotsos.com for schedule details...
-Original Message-
[EMAIL PROTECTED]
Sent
1 - 100 of 375 matches
Mail list logo