Запуск и управление инстанцией в СУБД ORACLE, страница 10

       222 snapshot_refresh_keep_connections                                         1 FALSE                                                                            TRUE      FALSE FALSE     FALSE      FALSE Keep network connections between execution of jobs             

       223 optimizer_percent_parallel                                                3 0                                                                                TRUE      TRUE  FALSE     FALSE      FALSE optimizer percent parallel                                     

       224 optimizer_search_limit                                                    3 5                                                                                TRUE      TRUE  FALSE     FALSE      FALSE optimizer search limit                                         

       225 parallel_min_percent                                                      3 0                                                                                TRUE      TRUE  FALSE     FALSE      FALSE minimum percent of threads required for parallel query         

       226 parallel_default_max_instances                                            3 0                                                                                TRUE      FALSE FALSE     FALSE      FALSE default maximum number of instances for parallel query         

       227 cache_size_threshold                                                      3 20                                                                               FALSE     FALSE FALSE     FALSE      FALSE maximum size of table or piece to be cached (in blocks)        

       228 create_bitmap_area_size                                                   3 8388608                                                                          TRUE      FALSE FALSE     FALSE      FALSE size of create bitmap buffer for bitmap index                  

       229 bitmap_merge_area_size                                                    3 1048576                                                                          TRUE      FALSE FALSE     FALSE      FALSE maximum memory allow for BITMAP MERGE                          

       230 parallel_min_servers                                                      3 0                                                                                TRUE      FALSE FALSE     FALSE      FALSE minimum parallel query servers per instance                    

       231 parallel_max_servers                                                      3 5                                                                                TRUE      FALSE FALSE     FALSE      FALSE maximum parallel query servers per instance                    

       232 parallel_server_idle_time                                                 3 5                                                                                TRUE      FALSE FALSE     FALSE      FALSE idle time before parallel query server dies                     

       237 hash_join_enabled                                                         1 TRUE                                                                             TRUE      TRUE  FALSE     FALSE      FALSE enable/disable hash join                                        

       238 hash_area_size                                                            3 0                                                                                TRUE      TRUE  FALSE     FALSE      FALSE size of in-memory hash work area                               

       239 hash_multiblock_io_count                                                  3 8                                                                                TRUE      TRUE  IMMEDIATE FALSE      FALSE number of blocks hash join will read/write at once