Contents of redo log files [message #492588] |
Tue, 01 February 2011 05:35 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
jimit_shaili
Messages: 237 Registered: June 2006 Location: India, Ahmedabad
|
Senior Member |
|
|
Dear Friends,
I have some doubts about redo log files,
1) Can we fetch 'select statements' from redo log files through the use of log miner utility or any other?
(I think redo log file contains only insert,update,delete and DDL/DCL commands only)
2) If "No" to the above answer then how can i fetch all select statements fired on the system for a day or particular time.
(setting of sql_trace may be the one of them, but can it be possible for system level)
Please give me some link or related docs for the above problem.
Regards
Jimit
|
|
|
|
Re: Contents of redo log files [message #492599 is a reply to message #492588] |
Tue, 01 February 2011 06:46 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Yasir Hashmi
Messages: 304 Registered: April 2006
|
Senior Member |
|
|
Hi,
There is a phenomenon known as delayed block cleanout. When this phenomenon occurs,a simple select can generate redo.
Now,whether that select is logged in redo logfiles you will have to mine the current redo log file and see for yourself.
|
|
|
Re: Contents of redo log files [message #492603 is a reply to message #492599] |
Tue, 01 February 2011 06:49 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68676 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Quote:There is a phenomenon known as delayed block cleanout. When this phenomenon occurs,a simple select can generate redo.
True but this does not generate entry queryable by Log Miner (this is a side effect of previous DML statements) which was OP's point.
Regards
Michel
[Edit: correct english]
[Updated on: Tue, 01 February 2011 07:31] Report message to a moderator
|
|
|
|