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" <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).