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 events
On Fri, 12 Dec 2003 [EMAIL PROTECTED] wrote:
> I will try to get the output of v$system_event and will send it you guys. In the
> mean time I have more question..
>
> I am reading Cary's 'Optimizing Oracle Performance Book'. I am half way thru and
> over looked rest of the chapters but didnt fi
I will try to get the output of v$system_event and will send it you guys. In the mean
time I have more question..
I am reading Cary's 'Optimizing Oracle Performance Book'. I am half way thru and over
looked rest of the chapters but didnt find an easy way to analyze thousands of lines
trace file
All,
This sounds wy too familiar to me.
My (blind) guess is that sql*net round trips is killing performance.
System-wide could indicate this, but, as Jared states, trace out a specific session, and grab the session-specific info from v$sesstat, before and after.
We brute forced the issue of
The wholesale system wide collection of timing data is not generally
a good way to go about trouble shooting performance issues.
You need to pick a process, collect the timing data for that process,
and *only* that process, diagnose where the most time is being spent,
and determine what can be don
**
>-Original Message-
>From: [EMAIL PROTECTED]
>[mailto:[EMAIL PROTECTED]
>Sent: Thursday, December 11, 2003 11:29 AM
>To: Multiple recipients of list ORACLE-L
>Subject: RE: Performance tuning in complex environment
>
>
>Not really sure what happened
Avnish - Since nobody has mentioned it yet (my posts arrive late, so
probably will by the time this appears), get Cary Millsap's book Optimizing
Oracle Performance
http://search.barnesandnoble.com/textbooks/booksearch/isbnInquiry.asp?userid
=6WIANMIL0H&isbn=059600527X&TXT=Y&itm=1
His methods soun
:www.compuware.com
-Original Message-
[EMAIL PROTECTED]
Sent: Thursday, December 11, 2003 2:29 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Performance tuning in complex environment
Not really sure what happened and why we decided to that. I was involved in
Oh I've run into THIS beforeyou are in a sticky technical AND political
situation I am sure.
It is really not that complex.
I'll bet they (your DBAs) have already been told you that the app is
horribly designed and it was a mistake and that the hardware is under
powered canned "dataserver ins
Thanks
I asked because we also use Citrix and so far we never had a problem related to
Citrix, only problems we had were inefficient coding and oracle bugs, nothing related
to HW/disk/WTS etc. The only problem initially with Citrix was configuring client
printers, but our guys figured it out a
Not really sure what happened and why we decided to that. I was involved in the
beginning of project and remembered that PM was mentioning about talking to another
Logician client who were facing same issues.
-Original Message-
Jamadagni, Rajendra
Sent: Thursday, December 11, 2003 10:55
DBAs should never 'guess' about performance. If they are guessing you need new DBAs.
They should be running statspacks, sql trace, and looking at timing data.
Its too much to explain in an email. Fire your DBAs and find people who dont 'guess'.
How much are you paying these guys?
>
> From: <
Ummm ... what was the problem that prompted you guys to replace citrix servers?
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts,
Hi!
Maybe it's a delayed commit cleanout issue, due massive deletes, so during
your first select most of your buffers involved in delete have to be cleaned
out (thus becoming dirty and generating extra redo).
Tanel.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL
Robin,
Thanks for the reply. I figured it would. Thats what
we are working at now. It's unfortunate it was set up
this way to begin with, but I am starting to see the
light at the end of the tunnel.
Larry
--- Robin Li <[EMAIL PROTECTED]> wrote:
> I had the performance issue with CLOB in one of m
Raj,
I agree. I could see where that could affect the
overall performance. The analyze wouldnt have an
effect on a SELECT COUNT(*) though would it??? That is
the piece that really has me stumped at the moment.
--- "Jamadagni, Rajendra"
<[EMAIL PROTECTED]> wrote:
> After deleting lot of old data, a
I had the performance issue with CLOB in one of my databases. After I did a
re-org, and separated the tables,indexes and CLOB into different
tablespaces, the performance got tremendous improvement.
Robin
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Se
After deleting lot of old data, an analyze of the table is in order though ..
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, ha
t. there is no 'exact' very high and very low. you have to
interpret it.
>
> that is about it. Anyone who uses it for anymore than that is wrong.
> >
> > From: Mladen Gogala <[EMAIL PROTECTED]>
> > Date: 2003/10/28 Tue PM 12:09:34 EST
> > To: Multipl
to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: Re: performance issue on select count(*)
So, what exactly is indicated by a high or low hit rate? What, exactly, is "high"
and what do you con
t ORACLE-L <[EMAIL PROTECTED]>
> Subject: Re: performance issue on select count(*)
>
> So, what exactly is indicated by a high or low hit rate? What, exactly, is "high"
> and what do you consider "low"?
> What "HR" are you talking about?
> T
So, what exactly is indicated by a high or low hit rate? What, exactly, is "high"
and what do you consider "low"?
What "HR" are you talking about?
This would be the infamous BCHR:
select 'bc_hit_ratio' ratio,( sum(decode(name, 'consistent gets',value,0))
+ sum(decode(name,'db block gets', value
The symptom suggests caching is a big factor here - most likely
block-buffers.
Contrary to ?current? popular beliefs, BCHR is still a very relevant
performance indicator - either being very high, or being too low - both of
which gives a good indication of something that needs to be looked at.
to client 54 00
0 0
99 SQL*Net message from client53 02893 54.5849057
2698
From: Tim Gorman <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]&
Linda,
I am guessing that since your table is partitioned on an unspecified date
column, that the index on TID is either LOCAL or non-partitioned (i.e.
GLOBAL).
If it is LOCAL (you would have had to specify the keyword, as it is not the
default), then you will be performing indexed RANGE scans on
t; <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Subject: RE: performance issue on select count(*)
Date: Mon, 27 Oct 2003 05:49:24 -0800
Linda,
I guess that the key word is 'partition'. This type of query should
Linda,
I guess that the key word is 'partition'. This type of query should not require to
access the table if (hopefully) tid is indexed. If the index on tid is also
partitioned, all index partitions have to be searched. My feeling is that in such a
case what should run faster is some paralle
One of my clients has been talking to me about similar issues.
What kind of system are you replicating?
How much redo logging are you generating per day?
Does shareplex start to fall behind during the processing peaks?
_
David Kurtz
Go-Faster Consultancy Ltd.
tel: +44 (0)
Do you have primary keys etc and hint file? Also do you have constraints disabled. Some "Nelson, Allan" <[EMAIL PROTECTED]> wrote:
Since the results of triggers firing in the source will appear in thelog files, then in general you do not want the same triggers firing inthe target. Similarly since d
I probably found my problem. My replicated tables have a lot of indexs.
I removed all of them, and step by step I will add indexs who will help my
replication.
Tx
Luc
-Original Message-
Sent: October 23, 2003 3:04 PM
To: Multiple recipients of list ORACLE-L
Since the results of trigge
Since the results of triggers firing in the source will appear in the
log files, then in general you do not want the same triggers firing in
the target. Similarly since data integrity is usually enforced in the
source db you can typically disable it in the target. I suppose
something on this orde
Your DNS is toasty. Gethostbyname is a UNIX system call that takes your
ip address and turns it into a name. This could be a big part of your
delay. Networked apps do not take kindly to being unable to both
forward and reverse lookups. H_errno = 2 is not found.
Allan
-Original Message
Now we don't use Shareplex, but I do know of others who do & this is not the first
time I hear of performance problems, but I may be able to shed some light on the
problem. Since Shareplex reads the redo logs, if one statement on the source database
affects more than one row (lets say 10 for ar
Who's using other 50%? Is SP active or is waiting?
On 10/23/2003 02:19:32 PM, [EMAIL PROTECTED] wrote:
Allan,
I don't know about the source machine.
I receive around 350Megs of data every day.
I'm using sp_ctrl to stop and restart my Post process and monitor the
queue.
I'm pretty sure that the bot
Shareplex is fast here. We replicate a 6 CPU db to a 4 CPU machine
without excessive loads or problems. We run an average of 29 messages
with about 1 GB in the queues. Our data is 0 minutes old.
Outside of contacting Quest support I'm sure of how much help I can be.
When I have seen SP claim as
Dan,
The process taking 50% is an Oracle process and it is connected on Shareplex
Oracle user.
I have two different error messages:
1- "System call error: sp_cop(dsm) Temporary error (h_errno = 2)
gethostbyname (can't add entry for ora4)
I got this error every 10 minutes, but I didn't find someth
Allan,
I don't know about the source machine.
I receive around 350Megs of data every day.
I'm using sp_ctrl to stop and restart my Post process and monitor the queue.
I'm pretty sure that the bottleneck come from Shareplex. Oracle is waiting
for Shareplex, we have server's resources available (
How big is the box that is the source for this machine? Have you tried
running sp_ctrl and doing a shutdown and startup?
Allan
-Original Message-
Sent: Thursday, October 23, 2003 10:30 AM
To: Multiple recipients of list ORACLE-L
Hi gurus,
Oracle 8.1.7.3 on Sun Solaris
One of our data
With 2 CPUs, a Run-Queue of 1.27 isn't high. As SharePlex seems to be
the only process taking CPU, it is taking 100% of 1 CPU. If it is one
process only,
then the CPU speed __could__ [and I'm not saying "IS"] the constraint.
Adding CPUs wouldn't help. However, upgrading to a faster CPU would
Cary,
I detoured from the new Tom Kyte book after chapter 4 to read your test through.
chapter 6 of the tom kyte book might have been a better band aid for me at the moment, but - I finally (4 weeks after the issue was raised) got a user to let me know when he was going to run a posting routine.
Ryan,
Your two questions have different answers.
I studied mathematics as an undergrad. I focused on the abstract stuff:
predicate calculus, language theory, functional analysis, topology,
In my studies I constructed many, Many, MANY proofs. (A "proof" in
mathematics is a piece of technical
what is your math background? what level of math would you recommend
performance specialists to have?
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, October 21, 2003 3:49 PM
> Michael, I've responded by preceding your questions with "MM:
here is a list of tuning books to read. I used to work with the guy who
wrote it. He definitely knows what he is doing. There are quite a few people
on this list who can attest to that.
http://www.amazon.com/exec/obidos/tg/listmania/list-browse/-/VL8CI2YJANX1/re
f=cm_lm_dp_l_2/102-3468524-1000163
Cary,
Thank you for your in-depth response. It was very helpful. To me, the
hardest books to read and understand are those that tell you WHAT but not
WHY. From the excellent reviews I've received (look at MLaden's review just
posted), it appears to give plenty of WHY. I appreciate that very much.
Thank you Dennis. I will take a look at that sample chapter, then probably
go out and pick up the book.
Thanks again.
This e-mail, including attachments, may include confidential and/or
proprietary information, and may be used only by the person or entity to
which it is addressed. If the reader
Cary, I believe that I'm more then entitled to a commission.
On 10/21/2003 06:04:26 PM, Michael Milligan wrote:
Cary,
Thank you for your in-depth response. It was very helpful. To me, the
hardest books to read and understand are those that tell you WHAT but
not
WHY. From the excellent reviews I've
Sorry to double post. It didn't show up on the board and after about an hour
I thought there was a problem. Of course as soon as I posted again, they
both showed up! I'll be more patient next time.
Michael Milligan
Oracle DBA
Ingenix, Inc.
2525 Lake Park Blvd.
Salt Lake City, Utah 84120
wrk 801-98
Cary,
Thank you for your in-depth response. It was very helpful. To me, the
hardest books to read and understand are those that tell you WHAT but not
WHY. From the excellent reviews I've received (look at MLaden's review just
posted), it appears to give plenty of WHY. I appreciate that very much.
t; From: "Cary Millsap" <[EMAIL PROTECTED]>
> Date: 2003/10/21 Tue PM 03:49:24 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: Performance tuning book
>
> Michael, I've responded by preceding your questions with "MM:&qu
I was fortunate to attend the Hotsos Clinic and read the advance version. It is
not your normal tuning book. If you are looking for checklists, hand holding,
"do x to solve y" solutions, don't bother with the book. If you are looking for
a book to teach you the skills to solve your performance prob
ap" <[EMAIL PROTECTED]>
> Date: 2003/10/21 Tue PM 03:49:24 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: Performance tuning book
>
> Michael, I've responded by preceding your questions with "MM:" and my
> answers with &
Michael, I've responded by preceding your questions with "MM:" and my
answers with "CVM:".
MM: ...can you please tell me if your new book, of which I've heard good
things, is different in any way than other Oracle Performance Tuning
books out. Does it take a different approach?
CVM: Drastically
Thank you Dennis. I will take a look at that sample chapter, then probably
go out and pick up the book.
Thanks again.
This e-mail, including attachments, may include confidential and/or
proprietary information, and may be used only by the person or entity to
which it is addressed. If the reader
Sorry to double post. It didn't show up on the board and after about an hour
I thought there was a problem. Of course as soon as I posted again, they
both showed up! I'll be more patient next time.
Michael Milligan
Oracle DBA
Ingenix, Inc.
2525 Lake Park Blvd.
Salt Lake City, Utah 84120
wrk 801-98
Michael
Oh yeah, this book takes a revolutionary approach compared to any other
book written to this point. The first chapter is posted at
http://www.oreilly.com/catalog/optoraclep/index.html
read this and you will see that this book is an entirely new method of
locating the root cause of Oracle
Behalf Of
Jamadagni, RajendraSent: Tuesday, August 26, 2003 4:54
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
Performance Problem
Funny ...
I have tkprof give up analyzing a 4.2G tracefile on a 64bit
platform. anyone else experienced thi
Laura, I really believe that you should take the 10046 and then contact
Hotsos.
It may and probably will save you some time and aggravation. They're not
very expensive,
around $50 per file analyzed.
--
Mladen Gogala
Oracle DBA
-Original Message-
Burton, Laura
Sent: Tuesday, August 26,
Title: RE: Performance Problem
Funny ...
I have tkprof give up analyzing a 4.2G tracefile on a 64bit platform. anyone else experienced this??
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views
Laura,
You might find the problem by checking the things you plan to check, and
by following the advice of the book you're using. But the odds are very
good that you will not. At least not for a long time...
Any application program on your system can tell you where it is spending
its time. Let it
No, I had read not to analyze the sys tables in the 'TIP' section of the
book I am using as a reference (Oracle Performance Tuning/Tips &
Techniques). As I stated earlier, I also made sure that I analyzed all
the tables and indexes that were involved, because I had read that
leaving a table 'un'an
Did you analyze the sys schema by mistake. This can stop the fastest
database. We had a contractor do that to an 8.0.5 database once, and only
once.
Ruth
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of
> Burton, Laura
> Sent: Monday, August 25, 2003 4
Title: RE: Performance Problem
'her' ??
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion
Mladen's advice actually covers that. No matter what's causing the slow
performance, if something's taking time, then it will show up in the
10046 trace data. "That's why we love her so."
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Hotsos Clinic 101 in Sydney
-
'Laura' On Monday, August 25, 2003 1:49 PM said;
> We currently have an application we are trying to speed up. In
> researching rule/cost based optimizers, I read that the cost based
> optimizer was the way to go (although rule had its moments) because that
> is where Oracle would be focusing any
Laura,
Keep in mind that analyzing tables/indexes will invalidate related SQL in
the shared pool. If you have Statspack snapshots at that time, you will see
that both latching (for shared pool/library cache) as well as waits for
'library cache pin/locks/loads' was high at that time. You may have o
To speed up the application, you have to know where the time is spent.
Initial estimates can be made based on V$SESSION_WAIT and V$SESSION_EVENT
for
the application sessions, but to go really deep, you need a detailed
performance
analysis, based on timings and waits produced by the event 10046, lev
"Burton, Laura" wrote:
>
> We currently have an application we are trying to speed up. In
> researching rule/cost based optimizers, I read that the cost based
> optimizer was the way to go (although rule had its moments) because that
> is where Oracle would be focusing any upgrades, enhancements,
Was it always slow ?
Are you monitoring specifics jobs ? If so, have you run tkprof your main SQL
statements ?
When running, what are the main ressources Oracle is waiting on ?
Have you monitor from the OS ? Are you IO bound or CPU bound ?
Cost base optimiser in 805 is not as good as on 8i or 9
how about
SELECT DISTINCT tfc_fct_value
FROM PD_TMP_AGG_VALS_5071_544,PD_OUTPUT_ITEMS,tp_fact_ctl
WHERE OUI_OUT_ID=5071
AND OUI_FACT_ID IS NOT
NULL
AND
oui_item_type=tfc_item_type
AND oui_fact_id in (vd17,vd18,vd19,vd20,vd21)
ORDER BY tfc_fct_value
/
???
Raj
--
Or indeed level 8 would do
Niall
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
> Behalf Of Niall Litchfield
> Sent: 14 July 2003 21:49
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Performance problems VMS 8i
>
>
Hi!
One of first thing I'd check when migrating from 7 to 8i, is settings for
optimizer_index_* parameters. And of course, your tables&indexes should be
analyzed (if not still explicitly using RBO).
Tanel.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]
Hi Barbara
> After an upgrade from Oracle 7.3.4 to 8.1.7.4 on
> OpenVMS, some (but not all) of our batch jobs are
> suffering severe performance degradation. One of our
> critical jobs went from 3 hours to 9 hours elapsed
> time.
>
> The reason is obvious. The solution is not. One of
> our jobs
I'm going to ask the obvious question:
Have statistics been generated for the schemas in question?
It's assumed that you're now using CBO, and if stats have
not been generated, then CBO is making assumptions about the
nature of your data.
Jared
On Monday 14 July 2003 07:54, Barbara Baker wrote
Dear Gaja,
With your many splendid deeds in the name of performance management (my personal
favorite being the fantastic "Compulsive Tuning Disorder" diagnosis) it's
only fair that your name will - until something better comes along - be synonymous
(spelling?) with the best RAID-technology ava
Ramon,
Whatever the plan, your stats border on the insignificant (I mean these are very
small values and it shouldn't even take 2mn to run). Set TIMED_STATISTICS to TRUE if
this is not already done and check system events. There is something unorthodox going
on - not purely a matter of SQL p
Stephane,
I continue having the same problem, in LAB 2 minutes and in PRODUCTION
forever. I made the changes you indicate me.
This is the explain plan in LAB, NO STATISTICS with data from yesterday
Execution Plan
--
0 SELECT STAT
Ramon,
I have had a closer look at your coe. My gut feeling is that
SELECT MAX(A.ACM_FECACUM),
Nvl(A.ACM_ACUMDBANT,0) -
nvl(A.ACM_ACUMCRANT,0) +
nvl(A.ACM_ACUMDB,0)-
nvl(A.ACM_ACUMCR,0)
i
Hey, we can kill Martians by singing. Have you ever seen "Mars Attacks"?
Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, July 01, 2003 11:09 AM
To: Multiple recipients of list ORACLE-L
Now you have made them really mad. Now you
Tks Stephane and Madlen,
Still the same problem.
I added the hint /*+ FIRST_ROWS */ to the query that invoke the function
and it changed from FTS to use Index but still have the same problem. I
added the same hint to the function and
Nothing.
I checked the v$session_wait during the execution o
Now you have made them really mad. Now you will be forced to listen to
their singing *AND* their accordion players!
> -Original Message-
> "All right already! I'll trash all my RAID-5 storage and
> replace it with
> RAID10!!! For the love of mercy, just PLEASE STOP SINGING!!!"
--
Ple
A musical? Is this what militant extremism is coming to?
...I'll admit though, I'm more inclined to give into the demands of
extremists who won't cease singing, rather than give into the more
"traditional" actions taken by militants...
"All right already! I'll trash all my RAID-5 storage and re
Dear Mogens,
Wow!!!
How creative you and Pete have gotten with my last
name!!! Amazing indeed! I bet my Dad suffered from a
few hiccups in the past few days. I am still cooking
up something "big" on you my friend - Mogens
(pronounced as Moens) Nørgaard (just skip the
consanants in the middle and
17:00 get there for 17:50
Stephen Hodgkinson
Oracle DBA
TotalFina Elf Gas & Power Ltd
Phone: 01737 27 5564
[EMAIL PROTECTED]
**
This email contains information which is confidential. It is for the
exclusive use of th
Mladen Gogala scribbled on the wall in glitter crayon:
> I didn't have the book with me at the time, so I was talking by heart,
> from my head. As I am getting older, my memory is obviously playing
> tricks on me. I humbly apologize to everybody whom I might have
> offended by my bad spelling, di
Mladen,
Why do you feel old at the magic age of 42. May be 43 Years now.
The book name is
ORACLE 101 Performance Tuning by
Gaja Krishna Vaidyanatha, Kirtikumar Deshpande and John A. Kostelac Jr.
Regards
Rafiq
Oracle Financial GL, AP, AR, PA, Reporting
NJ Morristown 1 - 3
Mladen,
There is no tone in email messages... I was not annoyed at all! And you
really do not want to hear me sing, small children weep and dogs howl
:)
I just wanted (at the expense of the oh so massive royalties all
authors get) to make sure that the person you were helping bought the
book he r
I can and do get annoyed - but rarely show it. Not worth the effort or
stress on me.
however, show me someone spouting "hit ratios are the only way to tune"
and "raid-5 rules" and you will see annoyance. :)
--- Mogens_Nørgaard <[EMAIL PROTECTED]> wrote:
> I very seriously doubt that Rachel is a
well, perhaps he writes under the name Vaidyanatha.. and uses his true
name for his new career?
--- Pete Sharman <[EMAIL PROTECTED]> wrote:
> Surely not? I was told just last week by the inestimable Mr. Mogens
> Norgaard (who we all know as the source of truth) that Gaja's real
> name is
> Gaja
I very seriously doubt that Rachel is annoyed. On the contrary. Never
experienced it, never will, I think.
I believe it's spelled Gaja Vahatneyhatneyhatney, but I could be wrong.
Mladen Gogala wrote:
Oh, and to grant you Elvis or Cher status, I'd have to hear you sing
first.
Can you do "Heartb
It's true. Gaja Vayanahneenahneeheyheyheyhey (sp?) will star in "BAARF. The
Musical." Also - this might come as a surprise to Pete Sharman - the OakTable
Choir will be part of the musical, and Pete (who, by the way, is a fantastic
baryton singer) will sing one verse of a certain song (lyrics sl
Oh, and to grant you Elvis or Cher status, I'd have to hear you sing first.
Can you do "Heartbreak Hotel" for me? As I have said, I don't have the book
with me and I'm equally adept at spelling french names as at spelling indian
names, so I decided to give it up. From the tone of your message, yo
I didn't have the book with me at the time, so I was talking by heart,
from my head. As I am getting older, my memory is obviously playing tricks
on me. I humbly apologize to everybody whom I might have offended by my
bad spelling, distorting title or forgetting co-authors altogether.
I didn't want
Surely not? I was told just last week by the inestimable Mr. Mogens
Norgaard (who we all know as the source of truth) that Gaja's real name is
Gaja Vaidyanathanathanatha, and he's about to take on a top-secret new
career (details to be revealed at the DB Forum in Denmark in October) ...
:)
Pete
Mladen,
As one of the authors of DBA 101, I appreciate your plugging my book
for me. But Gaja Vaidyanatha (correct spelling) and Kirtikumar
Deshpande (both on this list) are the authors of the book I think you
meant to talk about: Performance Tuning 101.
Marlene (has she now moved onto single na
Ramon,
This is not a strange case at all; I find quite customary to see
dazzling fast queries in a development environment crawl pathetically in
production.
My Spanish being reduced to some vague remnants of Latin (and just
enough to understand the promotion of Mexican holiday resorts) I m
Have you set event 10046, lev 8 for the session? If not, try setting
it and then use 9.2 tkprof to see what is the instance waiting for
as well to analyze the execution plans and see how they differ.
Also, during the execution, you can watch v$session_wait and see what the
session is waiting for. I
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of
> Pardee, Roy E
> Sent: Friday, June 13, 2003 20:10
> To: Multiple recipients of list ORACLE-L
> Subject: ADO and bind variables (was RE: Performance improvement
> required :-))
>
This is interesting--if I use ADO with the ODBC provider (as the code does
below), I get the same results. But if I use just ADO (that is, ms' OLE DB
provider for oracle (MSDAORA.1)) then I don't get bind vars.
(I'm doing INSERTs in my code, not SELECTs).
I wonder if oracle's native OLE DB provi
I'm sure you can. You should see it in an ODBC trace log, or you can
use trace events on the database. Here's a really simplistic test I did
to verify it. I ran this VB code that executes a really dumb query that
could not have come from anywhere else - SELECT DUMMY FROM DUAL WHERE
DUMMY = 'X'
Using REFCURSOR you can return result set from stored procedure.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original Message-
Craig Healey
Sent: 13. júna 2003 12:20
To: Multiple recipients of list ORACLE-L
>
> Why can't you use bind variables? I thought using .Parameters method
> (pro
1 - 100 of 324 matches
Mail list logo
