why the select keep generating redo?

Author: asktom.oracle.com | Published: 11th Dec 2007 | Visited: 65 times | Add Comment
Filed in: Oracle FAQ

Hello,Tom: Good afternoon! I have 2 questions: q1: I delete all rows from a big table and dont commit ,I select count(*) from the table from another session, and i looked in the expain,I found every time the query generated some redos,why,...

Read Article

Sponsored Links

• Dynamically generating thumbnail images in ASP.NET with C# without affecting initial page load time Generate thumbnail on the fly without affecting page load ...

• Select Which Panel Displays AutoHint in Delphi's TStatusBar in Delphi TIPS :: The TStatusBar Delphi control displays a row of panels, usually aligned at the bottom of a form. When AutoHint is true, the status bar automaticall ...

• Using the SelectDirectory Delphi routine - to Select a Directory/Folder in Delphi TIPS :: You can display a dialog to the user to allow directory/folder selection without using a TOpenDialog component. First, add FileCtrl unit to the uses clause o ...

• Article :: A Practical Introduction to PyQt's Undo/Redo Framework Be a smart Python programmer with this introduction to PyQt's undo/redo framew ...

• CodeSnip: How to Select the Records from a Table Following a Pattern without Using ROWNUM In this article Deepankar discusses how to select records from an Oracle 9i table without using ROWNUM. Deepankar provides a detailed analysis of each SQL statement along with the screenshot of the final out ...

• dml single insert/select or bulk collect/forall Tom, i am currently designing a new database 10g Rel2 and would appreciate your advice on the following Which method would you advise for the following business process OPTION 1 ######## DECLARE CURSOR c1 IS SELECT ..........

• Generating Aesthetic line styles A novel way to create complex line patt ...

• Article :: Generating Atom Feed from SQL Data Ivan Pepelnjak describes how you can create an Atom feed directly on the SQL Server with Transact SQL comma ...

• Customize the built in Outlook Select Names Dialog (or any other) In this article you will learn how to customize the built in Select Names Dialog and use different external Datasources for your own Di ...

• CodeSnip: How to Select the Records from a Table Following a Pattern In this code snippet, Deepankar examines how to select only specific records from a table commencing in a series (even series i.e. 2nd,4th,6th...records or odd series i.e. 1st,3rd,5th.... records and other simple series) in a single query. He provides a detailed analysis of the relevant SQL stateme ...

Next: why the cardinaltiy of explain plan does not matches with the tkprof row source operations