Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Performance Degradation/anomaly?

RE: Performance Degradation/anomaly?

From: Ed <junior_peon_at_yahoo.com>
Date: Fri, 13 Apr 2001 19:12:26 -0700
Message-ID: <F001.002E9981.20010413185056@fatcity.com>

Mladen,

Thanks very much for responding to this. I was leafing thru' a tuning book and it suggest checking the types of metrics az mentioned by you. I suspect the db parameters needs some tuning.

Regards,
Ed
--- "Gogala, Mladen" <MGogala_at_oxhp.com> wrote:
> Ed, try looking in the v$session_wait to see what is
> the session waiting
> for.
> That should give you a hint on what might be going
> on. If you cannot find
> anything in the database, check OS, swapping,
> paging, CPU, queues on the
> disk
> drives etc....
>
> -----Original Message-----
> Sent: Friday, April 13, 2001 2:07 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Greetings all,
>
> This is more of a tuning question. We have a pl/sql
> procedure doing inserts and updates to a very large
> table. This procedure process different groups of
> same types of data sequentially. The difference
> between these groups is with the volume of raw data.
>
>
> When the procedure gets to process a large dataset
> (large volume), the performance slows significantly.
>
> However, it will speed up when it gets to process a
> smaller dataset.
>
> The clincher: If I was to terminate and re-start the
> procedure the performance picks up for the same
> large
> dataset. It behave as though the buffer is "full"
> and
> the re-start seems to clear the buffer or any "cow
> webs" from previous session.
>
> The procedure has been tuned. The target table has
> recently been defragmented. No other processes
> running concurrently.
>
> We suspect the database needs tuning but do not know
> how to proceed. What should we be looking for? I am
> hoping to get suggestions on what to do to tune the
> DB. Appreciate any feedback.
>
> Thanks very much,
> Ed
>
>
>
>
>
>
>
> __________________________________________________
> Do You Yahoo!?
> Get email at your own domain with Yahoo! Mail.
> http://personal.mail.yahoo.com/
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Ed
> INET: junior_peon_at_yahoo.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists

>



> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (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.com
> --
> Author: Gogala, Mladen
> INET: MGogala_at_oxhp.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists

>

> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).


Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ed
  INET: junior_peon_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Fri Apr 13 2001 - 21:12:26 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US