Re: question about internals: what exactly does a partition-wise compress do?
- From: Charles Schultz <sacrophyte@xxxxxxxxx>
- To: Tanel Poder <tanel@xxxxxxxxxxxxxx>
- Date: Fri, 21 Oct 2011 10:40:10 -0500
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@xxxxxxxxxxxxxx> wrote:
> V$LOCK_TYPE says this about SI enqueues:
>
> SQL> @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@xxxxxxxxx>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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
