Re: LogMiner SESSION_INFO is empty

From: andreik <spamme.andreik_at_gmail.com>
Date: Tue, 16 Mar 2010 09:10:37 -0700 (PDT)
Message-ID: <2842ca34-478b-4360-9b4f-fca4003fdaa2_at_u9g2000yqb.googlegroups.com>



On Mar 16, 5:01 pm, ddf <orat..._at_msn.com> wrote:
> 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

so this is normal that session_info does not always get logged into redo?
what does it depend on?
is this mentioned somewhere in the documentation? I couldn't find anything like that. Received on Tue Mar 16 2010 - 11:10:37 CDT

Original text of this message