| 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: Waits on archiving
I think this is the best answer from a dba which i have got who is planning
to wait until the user comes back and says the the database is slow.I hope
that was a joke.
I think there is (but i am not sure about this event)an event which tells
whether the arch is running slow or not it is called as "skswat" you can see
in the session wait if it is waiting.
I am not sure about this but i feel this will also help u in telling that
the arch is in some kind of a probs
timer in sksawat
The session waits for the Archiver (ARCH) asynchronous I/O to complete.
Wait Time: 0.01 seconds
Parameters: none
>From: Satar Naghshineh <Satar.Naghshineh_at_irvine.mellesgriot.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: Waits on archiving
>Date: Wed, 25 Oct 2000 11:30:41 -0800
>
>Don't worry about knowing if you have problems, the users will let you
>know.
>The whole Database freezes until the ARCH process can write again.
>
>Regards,
>Satar
>
>
>
> > -----Original Message-----
> > From: David Turner [SMTP:turner_at_tellme.com]
> > Sent: Wednesday, October 25, 2000 7:56 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Waits on archiving
> >
> > What is the best method to tell if performance is degrading because of
> > waiting on
> > the archiver to write logs? I'm running 8.1.6 for Solaris.
> >
> >
> > Thanks, Dave Turner
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: David Turner
> > INET: turner_at_tellme.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).
Share information about yourself, create your own public profile at Received on Wed Oct 25 2000 - 16:51:52 CDT
 |
 |