Oracle 9i Fundamentals I Exam Cram 2

Index

[A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W]

B-tree indexes 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th

background processes     Archiver 2nd     ARCn (Archiver)     Checkpoint 2nd 3rd 4th     CKPT

     Database Writer 2nd 3rd

     defined     Dispatcher 2nd     Job Queue 2nd 3rd

     LGWR     Lock Manager Server     Log Writer 2nd

     Process Monitor 2nd

     Queue Monitor

     Recoverer 2nd

     System Monitor 2nd background trace files 2nd

BACKGROUND_DUMP_DEST initialization parameter

backups     control files 2nd 3rd binary sorting bitmap indexes 2nd 3rd 4th 5th 6th 7th 8th

block size

     default 2nd

block utilitization parameters

     INITRANS 2nd

     MAXTRANS 2nd

     PCTFREE 2nd

     PCTUSED 2nd 3rd

blocks

     block header

     data space

     DB_BLOCK_SIZE initialization parameter 2nd 3rd

     defined

     disk blocks

     extents 2nd 3rd 4th

     free space 2nd

     header 2nd     layout 2nd 3rd 4th 5th     row data

    segments

         bootstrap segments         cache segments

         data segments

         defined         index segments

         LOBnn segments         rollback segments 2nd

         table segments         temporary segments     size 2nd 3rd 4th 5th 6th 7th 8th 9th 10th     space usage 2nd bootstrap segments 2nd 3rd 4th

buffer cache 2nd