The only way a select statement can be captured is via auditing. You can also see select statements in the library cache, but that is not persistent storage.
What is the purpose of redo in Oracle? Does a select statement change anything? No, so what is there to be re-done?
Here is a list of some books on Oracle. If you are new to Oracle, spend some time on reading books and the documentation.http://dba-oracle.com/googlesearchsite_pro...p;q=easy+oracle