Re: question about internals: what exactly does a partition-wise compress do?

From: Charles Schultz <sacrophyte_at_gmail.com>
Date: Fri, 21 Oct 2011 10:40:10 -0500
Message-ID: <CAPZQniV6efcAo49v021Vmw30uUSUpQUFW9J-micAsueFeV6ObQ_at_mail.gmail.com>

thanks. We have streams configured in the database from which this database (REPTTEST) was cloned, but:
1) streams is *not* in use in this database 2) we do not configure streams for this table (FGBTRND) On Fri, Oct 21, 2011 at 10:38, Tanel Poder <tanel_at_tanelpoder.com> wrote:

> V$LOCK_TYPE says this about SI enqueues:
>
> SQL> _at_lt si
> Show lock type info from V$LOCK_TYPE for lock si
>
> TYPE LOCK NAME ID1 MEANING ID2 MEANING
> LT_ DESCRIPTION
> ---- ------------------------------ -------------------------
> ------------------------- ---
> ------------------------------------------------------------
> SI Streams Table Instantiation object # 0
> NO Prevents muiltiple streams table instantiations
>
> So, do you have streams in use?
>
> --
> Tanel Poder
> Expert Oracle Exadata book:
> http://www.apress.com/9781430233923
>
>
>
> On Fri, Oct 21, 2011 at 4:39 PM, Charles Schultz <sacrophyte_at_gmail.com>wrote:
>
>> Good day, listers,
>> I have two questions wrapped up in one issue. :)
>> 1) What exactly is "enq: SI - contention" - it does not appear to be
>> documented, and not many relevant hits on google
>> 2) Why would a subpartition compress operation block simultaneous compress
>> operations in different subpartitions or partitions?
>>
>>

-- 
Charles Schultz


--
http://www.freelists.org/webpage/oracle-l

Received on Fri Oct 21 2011 - 10:40:10 CDT