Why a transaction cannot reuse space that was deleted from

Author: asktom.oracle.com | Published: 4th Apr 2008 | Visited: 36 times | Add Comment
Filed in: Oracle FAQ

Tom, in your recent presentation in Hartford you were discussing the difference in refreshing materialized views from version 9 to 10 in that it went from a truncate/insert to a delete/insert which caused some confusion. You also mentioned in the co...

Read Article

Sponsored Links

• Read committed--Why transaction can read uncommitted data Hello Tom Thanks for your time.. I have a question: I understand that by default Oracle uses read committed by statement level, normally other session can't see the modification execept the session that makes the modification itself. Read c ...

• About the transaction status in oracle 9i Hello Tom Thanks for your time.. I am using oracle 9i(9.2.0.1) databases. And some day I find there is a column (status) in the v$transaction and I understand if there is a transaction open and not committed, the status always shows active. If ...

• Toatl free space and largest extents Hi Tom, I am new to this blog. I have one doubt regarding fragmentation. select TABLESPACE_NAME, sum(BYTES), max(BYTES) from dba_free_space group by TABLESPACE_NAME; If we give this query we will get sum(BYTES)- ...

• Using A Single Transaction With Multiple Typed DataSets Provides a detailed explanation of how to implement a single transaction across multiple Typed Data ...

• When is a commited transaction removed form the ITL Hi Tom, A transacion entry is created in the ITL in the data/index block header when a transaction modifies a block. How long does this entry stays in the ITL after the transaction is committed and do you get a snapshoot too old if a long runnig qu ...

• Article :: Collaborating with Windows Meeting Space Paul McFedries runs through the basics of connecting with others using Vista's replacement for NetMeeting, Windows Meeting Sp ...

• Emacs command mark the block (Ctrl+Space) does not work QC#: 5871 Version: 7.0 Status: Open defect, requires resolution Description: The Emacs key mapping has very limited functionality. In some cases it's a very frustrating when even basic commands does not work properly, e.g. mark beginning or end of the ...

• Grafting Compiled Code: Unlimited Code Reuse Add Functionality to a Project Using Existing Compiled Machine ...

• NASA Space Shuttle TV Schedule Transfer to Outlook Calendar NASA Space Shuttle Mission Schedule reads Excel files published by NASA containing the television schedule for Space Shuttle missions and provides the ability to enter and update the schedule in Outlook?s Calen ...

• Flyout - A great way to save space on your webpage. The article will demo how a free Flyout can help to save space on webp ...

Next: Rman - Strategy to Catalog Non-availability