Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Subject: Batch load freezes every couple of minutes
On 4/19/05, Mladen Gogala <gogala_at_sbcglobal.net> wrote:
> I had a problem with the database that appeared
> to be hanging during large loads, and "hanging" was occuring in regular i=
nt=3D
> ervals, which
> immediately made me suspect checkpoints and disregard suspicions about lo=
ck=3D
> ing. As it turns
> out, I was right. The database had a standby, and, of course, there was a=
l=3D
> og_archive_dest_2,
> defined as MANDATORY. I immediately suspected network, but the T3 line wa=
s =3D
> running at <0.1% of capacity.
> It turned out that an ethernet port on the switch was blinking re=3D
> d....the machine
> had a problem reaching the router.=20
>=20
Mladen,
careful where you use ratios :).
0.1% utilization of a GigE network card would translate into a 67%
utilized T1 line.
Gotta love running sqlnet over WANs ... there is an adventure in every epis=
ode.
I had something somewhat similar, whereby the monitoring software
running on the firewall was on the fast ethernet side.
the quote was:
"But the T1 is only running at 1% utilization".
Yes. It was physically impossible for it to get to 2% as a T1 line won't handle 2 Mbps.
Ratios. Can't kill em.
Paul
--=20
#/etc/init.d/init.cssd stop
-- f=3Dma, divide by 1, convert to moles.
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Apr 20 2005 - 19:39:39 CDT
![]() |
![]() |