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

From: Tanel Poder <tanel_at_tanelpoder.com>
Date: Fri, 21 Oct 2011 18:38:33 +0300
Message-ID: <CAMHX9JJJuD73bsW2GNwj9+BE=zA6ua87xBNUO-kKFv4afkzfHg_at_mail.gmail.com>

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?

>

>



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

Received on Fri Oct 21 2011 - 10:38:33 CDT