| Contents of redo log files [message #492588] |
Tue, 01 February 2011 05:35  |
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  |
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 |
 |
Michel Cadot
Messages: 68648
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 |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
