Re: Logical Standby Issues (cont.)

From: Mark Strickland <strickland.mark_at_gmail.com>
Date: Fri, 11 Aug 2006 10:11:55 -0700
Message-ID: <90ad14210608111011q371291f6j7c3ac8c8850d4b0@mail.gmail.com>

Yes, it's a single-column update. That column is not indexed, but there is a primary key and the primary key index does get used, ie, no full table scans. The table is 32768 blocks, 134217728 bytes. The primary key is on OID and there's also a non-unique index on OIDMORTGAGE. The update statement set ANEWCOLUMN=MARGIN. Here is the table description:

 Name
   Null? Type

---

• ------------------------------------------------- DATELASTMODIFIED NOT NULL DATE DATERECORDADDED NOT NULL DATE MARGIN NUMBER NAME NOT NULL VARCHAR2(30) OID NOT NULL RAW(12) OIDMORTGAGE NOT NULL RAW(12) ORDINAL NOT NULL NUMBER RATE NUMBER BACKUP_MARGIN NUMBER ANEWCOLUMN NUMBER

Nothing else was happening during the test. I will send you the four AWR reports directly. Yes, it would be possible for me to re-run the test and take 5-minute AWR snapshots.

Mark
--

http://www.freelists.org/webpage/oracle-l Received on Fri Aug 11 2006 - 12:11:55 CDT