LogMiner SESSION_INFO is empty
From: andreik <spamme.andreik_at_gmail.com>
Date: Tue, 16 Mar 2010 08:33:42 -0700 (PDT)
Message-ID: <72d6a42b-079f-4ece-980f-74bdd647eee0_at_b7g2000yqd.googlegroups.com>
Hi all,
Date: Tue, 16 Mar 2010 08:33:42 -0700 (PDT)
Message-ID: <72d6a42b-079f-4ece-980f-74bdd647eee0_at_b7g2000yqd.googlegroups.com>
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 Received on Tue Mar 16 2010 - 10:33:42 CDT