Re: log file format

"John" <j_barbe_at_hotmail.com> wrote in message news:8bc78dd8.0105212317.22ce44c5_at_posting.google.com...
> Yes I mean I'd like to read the contents of the active log.
> I've been studying the logminer tool for a while but there are several
> problems with it.
> For example, it can't get information about queries that aim chained
> rows and it's hard to use when DB contains partitionned table.
> So I'd like to know if it's possible to read the log file by my own.
>

Your descriptions of Log Miner's limitations are pretty accurate so far! From the Backup and Recovery course guide: "SQL on chained data rows is not reconstructed" (as you point out). There's nothing about partitions being a particular problem, though -but then you do say it's "hard", not impossible!

I just honestly don't know what you expect to be able to achieve by poking around in the logs "on your own" that Log Miner can't do. Or, to put it the other way, that which Log Miner can't do probably can't be done, unless you are willing to pay big bucks (I know that there are third party tools out there which do the same sort of things as Log Miner, but last time I vaguely checked, we were talking maybe 5-digit numbers for costs).

Any particular problem you are trying to deal with, or is this just the spirit of adventure and technical curiosity?

Regards
HJR
>
> "Howard J. Rogers" <howardjr_at_www.com> wrote in message
 news:<3b099990$1_at_news.iprimus.com.au>...
> > Do you mean you want to be able to read the contents of the active log?
> > Because if so, Log Miner was introduced in 8.1 for just precisely that
> > purpose (and it works just fine on inactive and archived logs too -and
 even
> > on version 8 logs supplied from an 8.0 database external to your 8.1
 one).
> >
> > It's supplied with 8.1 as standard, for free.... but I suspect (but
 haven't
> > checked) that it might be an Enterprise Edition only feature.
> >
> > If that's not what you meant, maybe you could re-phrase your request, or
> > indicate precisely what it is you are trying to achieve.
> >
> > Regards
> > HJR
> > --
> > =============================!!=============================
> > The views expressed are my own only, and definitely NOT those of Oracle
> > Corporation
> > =============================!!=============================
Received on Tue May 22 2001 - 03:14:47 CDT