| 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: Performance Degradation/anomaly?
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
>
-- 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
 |
 |