Help - Search - Members - Calendar
Full Version: Select Statement information
Oracle DBA Forums > Oracle > Oracle Forum
Tanvi Agrawal
Hi Guys,

I want to know where is the log of Select statement stored. I dont think that Redo log contains this information. Why does there is no log switch when firing a Select Statement when fetchin millions of data.




burleson
Hi Tanvi,

>> want to know where is the log of Select statement stored.

Nowhere! It would cost too much in disk storage!

You can turjn-on select auditing, but on a busy database, it can generate terabutes per hour in log files:

http://www.dba-oracle.com/t_audit_sql_select_statements.htm

Good Luck!

SteveC
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
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.