| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Oracle 911 Article
I don't mind sharing.
session_cursorsor_cache.sql is available at ixora.com.au
The number of cacheable cursors is greater today than when I ran tests to get an approximate value.
Sorry, no graphs and I don't seem to have save the output of previous tests. S_C_C was at the default of 0, so no cursor sharing was being done.
Hard parses have decreased quite a bit.
I can see how parse time has changed after it has run a few days. ( statspack every 15 minutes )
12:53:43 CIMORAPROD - jkstill_at_dal3 SQL> @session_cursor_cache
PARAMETER VALUE USAGE ----------------------------- ----- ----- session_cached_cursors 1500 100% open_cursors 100 ####%
CURSOR_CACHE_HITS SOFT_PARSES HARD_PARSES
----------------- ----------- -----------
85.15% 9.82% 5.03%
MAX_CACHEABLE_CURSORS
2160
Paul Drake <discgolfdba_at_yahoo.com>
Sent by: oracle-l-bounce_at_freelists.org
03/05/2004 12:24 PM
Please respond to oracle-l
To: oracle-l_at_freelists.org
cc:
Subject: RE: Oracle 911 Article
session_cached_cursor=1500
Really?
I'd love to see the data (or graph) of parse reduction
(and associated resource reduction) vs.
session_cached_cursors.
I just hiked it to 100 and left it there.
Hmmm. Guess I'm interested in "The Burden of Proof" if you care to share.
thanks.
Pd
>
>
> On Fri, 2004-03-05 at 01:51, Niall Litchfield wrote:
> > > You guys are going to enjoy this :-).
> > >
> > > I just read a very interesting article that
> managed to insult
> > > some of my
> > > favorite Oracle authors and the entire state of
> Alabama!
> >
> > Hmm we have a script with a number of ctas
> statements in it
> >
> > Where 'pope'='catholic'
> > Where 'manager name'='in'
> > Where 'niall'='big and clever' etc
> >
> > I read the alabama comment in the same light.
> >
> > > Now
> > > I've heard Mr.
> > > Burleson speak before, and I must admit that I
> thought he was
> > > a dynamic and
> > > entertaining speaker. But do you really think
> that Oracle
> > > Support has ever
> > > told anyone to call HIM to solve their
> performance problems
> > > (his article
> > > makes this claim)?
> >
> > I doubt that oracle support make specific partner
> recommendation in an iTAR though they might. On the
> other hand if you have purchased support from oracle
> because you have no-one experienced in house (though
> why you would then be running oracle is beyond me) I
> can imagine support saying something along the lines
> of , "well if you are uncomfortable with doing this
> you might hire either ourselves or a third party
> oracle specialist to do this work for you". The
> first consultancy site that is returned in a google
> search for "oracle expert" is www.dba-oracle.com
> >
> > In general I didn't like the tone of the article,
> but I do have to agree with jonathan that the
> article focusses on business problems and
> implications for clients, I like that. That said I
> find this approach hard to square with "Unlike
> academic and scientific Oracle DBAs who demand
> proofs and reproducible results before making an
> Oracle change". We can't be the only Oracle house
> that has a change management process that involves
> reproducing problems on test and applying a fix to
> show that it works first can we? This is a business
> process and definitely not a result of the DBA
> insisting on proof before changes are applied. All
> good change management requires some evidence that
> the change will have the desired effect - doesn't
> it?
> >
> > Niall Litchfield
> > Oracle DBA
> > Audit Commission
> > +44 117 975 7805
> >
> >
> >
> >
> >
> >
> >
>
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Sat Mar 06 2004 - 00:43:14 CST
 |
 |