Re: LogMiner SESSION_INFO is empty

From: ddf <oratune_at_msn.com>
Date: Tue, 16 Mar 2010 09:01:31 -0700 (PDT)
Message-ID: <638e3acc-157e-4c4b-875e-c7b59a6be184_at_k6g2000prg.googlegroups.com>



On Mar 16, 11:33 am, andreik <spamme.andr..._at_gmail.com> wrote:
> Hi all,
>
> I'm trying to investigate a table drop using LogMiner.
>
> I can locate the needed SCN and can see the 'DROP' command in V
> $LOGMNR_CONTENTS along with some internal stuff in one transaction.
> But for some reason SESSION_INFO is missing for that transacation!
> Next transaction already comes with session_info. Also when I do a
> test drop now on the same database, I can nicely see myself in the
> SESSION_INFO. But for that old transaction SESSION_INFO is not
> displayed.
>
> Anyone has an idea how can I have SESSION_INFO retrieved for that
> transaction?
>
> 10.2.0.1 on Solaris 64bit
>
> thanks

SESSION_INFO isn't available for that transaction else you'd see it displayed.

David Fitzjarrell Received on Tue Mar 16 2010 - 11:01:31 CDT

Original text of this message