Call now: 252-767-6166  
Oracle Training Oracle Support Development Oracle Apps

 E-mail Us
 Oracle Articles
New Oracle Articles

 Oracle Training
 Oracle Tips

 Oracle Forum
 Class Catalog

 Remote DBA
 Oracle Tuning
 Emergency 911
 RAC Support
 Apps Support
 Oracle Support

 SQL Tuning

 Oracle UNIX
 Oracle Linux
 Remote s
 Remote plans
 Application Server

 Oracle Forms
 Oracle Portal
 App Upgrades
 SQL Server
 Oracle Concepts
 Software Support

 Remote S


 Consulting Staff
 Consulting Prices
 Help Wanted!


 Oracle Posters
 Oracle Books

 Oracle Scripts

Don Burleson Blog 









Oracle 8i hidden lm parameters

Don Burleson


Note: Oracle hidden parameters are undocumented and unsupported by Oracle.
Make sure that you thoroughly test all hidden parameters before placing them in your production environment.

Parameter Name                            Description
----------------------------------------- ----------------------------------------------------------------
_lm_activate_lms_threshold                threshold value to activate an additional lms
_lm_cache_lvl0_cleanup                    how often to cleanup level 0 cache res (in sec)
_lm_cache_res_cleanup                     percentage of cached resources should be cleanup
_lm_cache_res_type                        cache resource: string of lock types(s)
_lm_dd_interval                           dd time interval in seconds
_lm_direct_sends                          Processes which will do direct sends
_lm_drm_window                            dynamic remastering bucket window size
_lm_dynamic_lms                           dynamic lms invocation
_lm_dynamic_load                          dynamic load adjustment
_lm_dynamic_remastering                   if TRUE enables dynamic remastering
_lm_enq_lock_freelist                     Number of ges enqueue element freelist
_lm_enq_rcfg                              if TRUE enables enqueue reconfiguration
_lm_enqeue_freelist                       Number of enqueue freelist
_lm_file_affinity                         mapping between file id and master instance number
_lm_lmd_waittime                          default wait time for lmd
_lm_lms                                   number of background global cache server processes to start
_lm_lms_waittime                          default wait time for lms
_lm_locks                                 number of enqueues configured for cluster database
_lm_master_weight                         master resource weight for this instance
_lm_max_lms                               max. number of background global cache server processes
_lm_min_lms                               min. number of background global cache server processes
_lm_msg_batch_size                        GES batch message size
_lm_msg_cache_thresholds                  GES message buffer caching threshold
_lm_msg_cleanup_interval                  GES message buffer cleanup interval time
_lm_node_join_opt                         cluster database node join optimization in reconfig
_lm_non_fault_tolerant                    disable cluster database fault-tolerance mode
_lm_num_pcmhv_latches                     number of latches covering the PCM HV buckets in cgs
_lm_proc_freeze_timeout                   reconfiguration: process freeze timeout
_lm_process_batching                      GES implicit process batching for IPC messages
_lm_procs                                 number of client processes configured for cluster database
_lm_rcfg_timeout                          Reconfiguration timeout
_lm_rcv_buffer_size                       the size of receive buffer
_lm_res_hash_bucket                       number of resource hash buckets
_lm_res_part                              number of resource partition configured for gcs
_lm_ress                                  number of resources configured for cluster database
_lm_send_buffers                          number of cluster database send buffers
_lm_send_queue_batching                   GES send queue message batching
_lm_send_queue_length                     GES send queue maximum length
_lm_share_lock_opt                        if TRUE enables share lock optimization
_lm_sq_batch_factor                       GES send queue minimum batching factor
_lm_sync_timeout                          Synchronization timeout for DLM reconfiguration steps
_lm_ticket_active_sendback                Flow control ticket active sendback threshold
_lm_tickets                               GES messaging tickets
_lm_tx_delta                              TX lock localization delta
_lm_validate_resource_type                if TRUE enables resource name validation
_lm_xids                                  number of transaction IDs configured for cluster database
_load_without_compile                     Load PL/SQL or Database objects without compilation
_local_communication_costing_enabled      enable local communication costing when TRUE
_local_communication_ratio                set the ratio between global and local communication (0..100)
_lock_sga_areas                           Lock specified areas of the SGA in physical memory



Oracle Training at Sea
oracle dba poster

Follow us on Twitter 
Oracle performance tuning software 
Oracle Linux poster


Burleson is the American Team

Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals.  Feel free to ask questions on our Oracle forum.

Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications.

Errata?  Oracle technology is changing and we strive to update our BC Oracle support information.  If you find an error or have a suggestion for improving our content, we would appreciate your feedback.  Just  e-mail:  

and include the URL for the page.


Burleson Consulting

The Oracle of Database Support

Oracle Performance Tuning

Remote DBA Services


Copyright © 1996 -  2020

All rights reserved by Burleson

Oracle ® is the registered trademark of Oracle Corporation.