Re: What do you make of this?
- From: Paul Baumgartel <paul.baumgartel@xxxxxxxxx>
- To: "Ravi_Kulkarni@xxxxxxxx" <Ravi_Kulkarni@xxxxxxxx>
- Date: Sun, 11 Sep 2005 20:11:59 -0400
No to index.
On 9/9/05, Ravi_Kulkarni@xxxxxxxx <Ravi_Kulkarni@xxxxxxxx> wrote:
>
> Is it No to Index or is it a No to Trigger ..
>
> ------------------------------
> *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto:
> oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Paul Baumgartel
> *Sent:* Friday, September 09, 2005 11:52 AM
> *To:* Deepak Sharma
> *Cc:* Kulkarni, Ravi; oracle-l@xxxxxxxxxxxxx
> *Subject:* Re: What do you make of this?
>
> No, but I wouldn't think that would affect parse elapsed time.
>
> On 9/9/05, Deepak Sharma <sharmakdeep_oracle@xxxxxxxxx > wrote:
> >
> > Any index on lastaccess ?
> >
> > --- Ravi_Kulkarni@xxxxxxxx wrote:
> >
> > > Paul,
> > >
> > > Can you confirm any (before-update) triggers on
> > > VALIDKEYS ?
> > > What are the cursors that the raw trace file show
> > > (with dep > 0) ?
> > >
> > > Thanks,
> > > Ravi.
> > >
> > > ________________________________
> > >
> > > From: oracle-l-bounce@xxxxxxxxxxxxx
> > > [mailto: oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of
> > > Paul Baumgartel
> > > Sent: Friday, September 09, 2005 11:18 AM
> > > To: oracle-l@xxxxxxxxxxxxx
> > > Subject: What do you make of this?
> > >
> > >
> > > Hi, all. Oracle10g (10.1.0.4.0) on Windows 2000.
> > >
> > > I have a set of traces that are puzzling. I had the
> > > traces done in
> > > controlled conditions, with a single user on the
> > > database; CPU usage on
> > > the DB server was less than 25%. This statement is
> > > a good example of
> > > what I'm trying to figure out. There's a high ratio
> > > of elapsed to CPU
> > > on the parse, but not much in the way of wait
> > > information--except the
> > > SQL*Net message from client. The client is a COM+
> > > application server.
> > > No recent changes that I know of on that machine,
> > > nor on the DB server
> > > itself. I have inspected the raw trace file as well
> > > and don't see
> > > anything to suggest that the tkprof timing summaries
> > > are incorrect.
> > >
> > > II'm looking for ideas on how to go about diagnosing
> > > the SQL*Net waits
> > > (assuming they're accounting for the different
> > > between CPU and elapsed)
> > > or finding where the rest of the elapsed time comes
> > > from. Thanks in
> > > advance for any suggestions!
> > >
> > > UPDATE VALIDKEYS SET LASTACCESS = :V00001
> > > WHERE
> > > VALIDKEYS_PK = :V00002
> > >
> > >
> > > call count cpu elapsed disk
> > > query current
> > > rows
> > > ------- ------ -------- ---------- ----------
> > > ---------- ----------
> > > ----------
> > > Parse 198 0.46 2.72 0
> > > 0 0
> > > 0
> > > Execute 99 0.12 0.49 0
> > > 297 396
> > > 99
> > > Fetch 0 0.00 0.00 0
> > > 0 0
> > > 0
> > > ------- ------ -------- ---------- ----------
> > > ---------- ----------
> > > ----------
> > > total 297 0.59 3.22 0
> > > 297 396
> > > 99
> > >
> > > Misses in library cache during parse: 0
> > > Optimizer mode: ALL_ROWS
> > > Parsing user id: 12492
> > >
> > > Elapsed times include waiting on following events:
> > > Event waited on Times
> > > Max. Wait Total
> > > Waited
> > > ---------------------------------------- Waited
> > > ----------
> > > ------------
> > > SQL*Net message to client 381
> > > 0.00
> > > 0.00
> > > SQL*Net message from client 381
> > > 0.01
> > > 0.51
> > > log file sync 1
> > > 0.00
> > > 0.00
> > >
> > ************************************************************************
> > > ********
> > >
> > > --
> > > Paul Baumgartel
> > > paul.baumgartel@xxxxxxxxxxxx
> > >
> > >
> > >
> >
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Tired of spam? Yahoo! Mail has the best spam protection around
> > http://mail.yahoo.com
> >
>
>
>
> --
> Paul Baumgartel
> paul.baumgartel@xxxxxxxxxxxx
>
>
--
Paul Baumgartel
paul.baumgartel@xxxxxxxxxxxx
Other related posts:
