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_wa
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,
On 13 Apr 2001, at 10:06, Ed wrote:
> the re-start seems to clear the buffer or any "cow
> webs" from previous session.
As all old timer Oracle users know, you really want to get
rid of all those buffer clogging "cow webs" ASAP, otherwise
you might get "mad dot com" disease. :)
Go on down to y
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 get