why do redo logs stay 'ACTIVE' for so long?

From: NetComrade <andreyNSPAM_at_bookexchange.net>
Date: Wed, 23 Feb 2000 22:32:22 GMT
Message-ID: <36d328f8.85484568@news.earthlink.net>

GROUP#     THREAD#    SEQUENCE#  BYTES      MEMBERS    ARC STATUS
FIRST_CHAN FIRST_TIME          

---------- ---------- ---------- ---------- ---------- ---
---------------- ---------- --------------------

         1 1 7051 20971520 1 NO ACTIVE 72156077 02/23/00 16:14:30

         2 1 7052 20971520 1 NO ACTIVE 72156121 02/23/00 16:15:13

         3 1 7050 20971520 1 NO ACTIVE 72156029 02/23/00 16:14:00

         4 1 7053 20971520 1 NO ACTIVE 72156124 02/23/00 16:15:44

         5 1 7049 20971520 1 NO ACTIVE 72155928 02/23/00 16:13:28

         6 1 7054 20971520 1 NO ACTIVE 72156126 02/23/00 16:16:15

         7 1 7055 20971520 1 NO ACTIVE 72157473 02/23/00 16:19:00

         8 1 7056 20971520 1 NO CURRENT 72158806 02/23/00 16:19:48

         9 1 7047 20971520 1 NO INACTIVE 72155765 02/23/00 16:06:07

        10 1 7048 20971520 1 NO ACTIVE 72155926 02/23/00 16:06:53

Each of them is about 20 Megs, and I see no disk contention.

As soon as I turn off TIMED_STATISTICS they all become INACTIVE (weel, except for one)

---

In case I forgot to mention:
We use Oracle 7.3.4 on Solaris 2.6, 2.7 boxes

---

Andrey Dmitriev	 eFax: (978) 383-5892  Daytime: (917) 750-3630
AOL: NetComrade	 ICQ: 11340726 remove NSPAM to email

Received on Wed Feb 23 2000 - 16:32:22 CST