Re: V$SESSION_LONGOPS and the domain indexes

From: ddf <oratune_at_msn.com>
Date: Mon, 5 Apr 2010 17:17:06 -0700 (PDT)
Message-ID: <3dc30c16-a7c4-4dfe-b338-a675fc4e84ae_at_a38g2000yqc.googlegroups.com>

On Apr 5, 6:43 pm, Mladen Gogala <n..._at_email.here.invalid> wrote:
> I noticed that there are no entries in V$SESSION_LONGOPS for the creation
> of the domain indexes, text indexes in my case. Is that a sin by omission
> or a deliberate feature? Can anybody shed some light on that?
>
> --http://mgogala.byethost5.com

The base criteria for an entry to appear in V$SESSION_LONGOPS for a table scan:

                       *) Operatrion must run for longer than 6
seconds (I presume this does)
                       *) The table must occupy at least 10,000 blocks

(it may be that your table doesn't)

Creationg text indexes is not the only excluded operaton as nested loop joins are conspicuously absent, however hash joins are readily displayed and can process a measly 20 blocks to be included. Index fast full scans are shown for indexes occupying 1000 blocks.

I'm not certain if yours is an omisson in the list of long operations or if your table has less than 10,000 blocks. Gints Plivna did work on this subject which can be found here:

http://www.gplivna.eu/papers/v$session_longops.htm

David Fitzjarrell Received on Mon Apr 05 2010 - 19:17:06 CDT