1. HOT => Heap Organized Table IOT => Index Organized Table 2.HOT Heap Organzied 3.IOT a.The data is index Organized b.The data is the index, the index is the data i.No extra cost for managing index ii.When you get the index, you get the data. No "table access" is …
Notes on ‘Expert Oracle’ — No.10.2: Table — HOT & IOT Read More »
1. Tow modes of Segment Space Management a. Automatic — ASSM b. Manual — MSSM We only care about ASSM here. 2.High-water Mark 2.1 What is it for ? Question: I’ve deleted all the data from the table by using "delete from …". Why does "select count(*) from …" take a long time? …
Notes on ‘Expert Oracle’ — No.10.1: Table — Segment Space Management Read More »
很简单，一句话： selenium.selectWindow(null);
睇睇啦…
1. Amount of Undo Log Delete > Update > Insert Operations on Indexed Columns > Operations on Non-indexed 2. What can cause "Snap Too Old" exception? => The undo segment is too small 3. How to make the undo segment not so small? a. Enlarge it, of course i.Enlarge UNDO_RETENTION, which …
Notes on ‘Expert Oracle’ — No.9.6: Redo&Undo — Undo Log Read More »
a.When data blocks are involved in a transaction, there are locking info created in the block. b.This info should be cleaned out when the transaction ends. c.They can be cleaned out immediately when the transaction ends, but not definitely. —- There are cleaned out on commitment, only if the blocks needed to be cleaned …
Notes on ‘Expert Oracle’ — No.9.5: Redo&Undo — Block Cleanout Read More »
1. The large your Redo log is, the more time-consuming your SQL operation is. 2. Can we turn off Redo Log? a. Not Recommeded b. You can use "NOLOGGING" in SQLs to reduce much of the log. c. You can also use "NOLOGGING" for INDEX. This is actually acceptable. 3. How to …
Notes on ‘Expert Oracle’ — No.9.4: Redo&Undo — More about Redo Log Read More »
1. What happens if a transaction is commited? a. The Redo Log is flushed b. Is the data blocks in SGA flushed also? No. We don’t need to do that with Redo Log. 2. Is the time of commitment a function of the volumn of manipulated data? No. There is not …
Notes on ‘Expert Oracle’ — No.9.3: Redo&Undo — Commit & Rollback Read More »
1. Redo log is made for a. Data Blocks b. Indexes c. Undo (That’s intersting) 2. The Redo info is first made in Cache, and it will be flushed into disk when a. 3 seconds passed b. The Redo Cache is 1/3 full or is over 1MB c. Commit …
Notes on ‘Expert Oracle’ — No.9.2: Redo&Undo — How Redo works? Read More »
1. Undo a. Undo is recorded in the Undo Segment b. Used for undo uncommited operations. c. When we do undo, we actually run the opposite SQLs. 2. Redo a. Redo = Redo Log i. Log as Cache in SGA ii. Log flused to Disk b. Used only …
Notes on ‘Expert Oracle’ — No.9.1: Redo&Undo — Overview Read More »