Ganesh -
I have'nt worked extensively on 7.3 - but it seems that
Log miner was intriduced with 8.1 as per this Metalink
Doc
========================================
PURPOSE
This paper details the mechanics of what LogMiner does, as well as detailing
the commands and environment it uses.
SCOPE & APPLICATION
For DBAs requiring further information about LogMiner.
The ability to provide a readable interface to the redo logs has been asked
for by customers for a long time. The ALTER SYTSTEM DUMP LOGFILE interface
has been around for a long time, though its usefulness outside Support is
limited. There have been a number of third party products, e.g. BMC's PATROL
DB-Logmaster (SQL*Trax as was), which provide some functionality in this
area. With Oracle release 8.1 there is a facility in the Oracle kernel to do
the same. LogMiner allows the DBA to audit changes to data and performs
analysis on the redo to determine trends, aid in capacity planning,
Point-in-time Recovery etc.
=====================================
Regards
Ankur Shah
Oracle DBA
DHR-GA
----- Original Message -----
From: "Ganesh Raja" <[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed] Thursday, May 30, 2002 2:51 PM
Subject: RE: determinie contents of log files
| Ankur,
|
| I have read some place that I can analyze the contents of a Log of 7.3
| with Logmnr... Correct me if I am wrong.
|
| Best Regards,
| Ganesh R
| Tel : +971 (4) 397 3337 Ext 420
| Fax : +971 (4) 397 6262
| HP : +971 (50) 745 6019
| ============================================
| Live to learn... forget... and learn again.
| ============================================
|
|
| -----Original Message-----
| From: Ankur Shah [mailto:[Email Address Removed] Sent: Thursday, May 30, 2002 10:28 PM
| To: LazyDBA.com Discussion
| Subject: Re: determinie contents of log files
|
|
| U can if U were on 8i - with LOG MINER
|
| =======================================
|
| HTHU
|
| Ankur Shah
| Oracle DBA
| DHR-GA
| ----- Original Message -----
| From: "Joehnk, John" <john.[Email Address Removed] To: "LazyDBA.com Discussion" <[Email Address Removed] Sent: Thursday, May 30, 2002 2:04 PM
| Subject: RE: determinie contents of log files
|
|
| | So I know that I cannot read the logs as are. Any other suggestions
| | to focus in on the cause?
| |
| | -----Original Message-----
| |
| | Running 7.3.4 and would like to look into log files and see what is
| | there.
| |
| | We have a collection database where all persons have select only, the
| | collection programs have write access. We are not able to determine
| | that any of these applications were misbehaving, but my log switches
| | went from about once an hour to every few minutes during a period last
|
| | night.
| |
| | Do I have any options to help me investigate what might have happened?
| |
| | Thanks
| |
| | John Joehnk
| |
| | --------
| | Oracle documentation is here:
| | http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
| | To unsubscribe: send a blank email to
| oracledba-[Email Address Removed] | To subscribe: send a blank email to oracledba-[Email Address Removed] | Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
| | Tell yer mates about http://www.farAwayJobs.com
| | By using this list you agree to these
| | terms:http://www.lazydba.com/legal.html
| |
| | --------
| | Oracle documentation is here:
| | http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
| | To unsubscribe: send a blank email to
| oracledba-[Email Address Removed] | To subscribe: send a blank email to oracledba-[Email Address Removed] | Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
| | Tell yer mates about http://www.farAwayJobs.com
| | By using this list you agree to these
| terms:http://www.lazydba.com/legal.html
| |
|
| --------
| Oracle documentation is here:
| http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
| To unsubscribe: send a blank email to oracledba-[Email Address Removed] To subscribe: send a blank email to oracledba-[Email Address Removed] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
| Tell yer mates about http://www.farAwayJobs.com
| By using this list you agree to these
| terms:http://www.lazydba.com/legal.html
|
|
| --------
| Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
| To unsubscribe: send a blank email to oracledba-[Email Address Removed] To subscribe: send a blank email to oracledba-[Email Address Removed] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
| Tell yer mates about http://www.farAwayJobs.com
| By using this list you agree to these terms:http://www.lazydba.com/legal.html
|
|
Oracle LazyDBA home page