Re: Oracle 9.2.0.5 fts

On Apr 2, 8:16 am, "Sylvestre" <Sylves..._at_world.com> wrote:
> Hello
>
> Is there a way to monitore the number of FULL TABLE SCAN
> made by one session ? (trigger ?)
>
> Thank you

select * from v$session_longops where operation = 'FULL TABLE SCAN' (or something like that).

You can also monitor it from v$sesstat.

--
Sybrand Bakker
Senior Oracle DBA