NT Registry entries for Oracle

I send you a complete list of the NT registry entries for Oracle:

HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE
           A2OWIZ80:REG_EXPAND_SZ:C:\ORANT\A2OWIZ80
           API:REG_EXPAND_SZ:C:\ORANT\DBS
           COMPANY_NAME:REG_EXPAND_SZ:Oracle Corp
           CORE40:REG_EXPAND_SZ:C:\ORANT\CORE40
           EXECUTE_SQL:REG_EXPAND_SZ:PLUS80
           MSHELP:REG_EXPAND_SZ:C:\ORANT\mshelp
           MSHELP_TOOLS:REG_EXPAND_SZ:C:\ORANT\MSHELP
           NET80:REG_EXPAND_SZ:C:\ORANT\NET80
           NLS_LANG:REG_EXPAND_SZ:AMERICAN_AMERICA.WE8ISO8859P1
           NLSRTL33:REG_EXPAND_SZ:C:\ORANT\NLSRTL33
           odbo3220:REG_EXPAND_SZ:C:\ORANT\ODBORA32
           OI_NLS32:REG_EXPAND_SZ:C:\ORANT\orainst\NLB
           oisfp10:REG_EXPAND_SZ:C:\ORANT\oisfp10
           ORA_NLS33:REG_EXPAND_SZ:C:\ORANT\NLSRTL33\DATA
           ORA_ORCL_PWFILE:REG_EXPAND_SZ:C:\ORANT\DATABASE\PWDORCL.ORA
           ORA_SHUTDOWN:REG_EXPAND_SZ:FALSE
           ORACLE_GROUP_NAME:REG_EXPAND_SZ:Oracle for Windows NT
           ORACLE_HOME:REG_EXPAND_SZ:C:\ORANT
           ORACLE_SID:REG_EXPAND_SZ:ORCL
           ORASMP_FixedPitchFontName:REG_SZ:Courier
           ORASMP_VOBLIB:REG_SZ:C:\ORANT\SYSMAN\ADMIN\
           OTRACE73:REG_EXPAND_SZ:C:\ORANT\OTRACE73
           OTRACE80:REG_EXPAND_SZ:C:\ORANT\OTRACE80
           OTT80:REG_EXPAND_SZ:C:\ORANT\OTT80
           OTT_DFLT:REG_EXPAND_SZ:OTT80
           OWAST:REG_EXPAND_SZ:C:\ORANT\OWAST
           PLSQL80:REG_EXPAND_SZ:C:\ORANT\PLSQL80
           PLUS80:REG_EXPAND_SZ:C:\ORANT\PLUS80
           PLUS_DFLT:REG_EXPAND_SZ:PLUS80
           PRO80:REG_EXPAND_SZ:C:\ORANT\PRO80
           RDBMS80:REG_EXPAND_SZ:C:\ORANT\RDBMS80
           RDBMS80_ARCHIVE:REG_EXPAND_SZ:C:\ORANT\DATABASE\ARCHIVE
           RDBMS80_CONTROL:REG_EXPAND_SZ:C:\ORANT\DATABASE
           SHARED_ORACLE_HOME:REG_EXPAND_SZ:C:\ORANT
           SQLPATH:REG_EXPAND_SZ:C:\ORANT\DBS
           SVRMGR:REG_SZ:C:\ORANT\RDBMS80           VS10:REG_SZ:C:\ORANT\VS10
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\Backup
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\Backup\ntinstall
           MOH Icons:REG_SZ:exec           Shareable:REG_SZ:TRUE
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\Backup\ntinstall\OCSM Groups
           Full Download:REG_SZ:ntcompat,exec,deinstl
           Run From Server:REG_SZ:res:US,prodmsg:US,script:US
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\Backup\w32net8a80
           Shareable:REG_SZ:TRUE
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\Backup\w32net8a80\OCSM Groups
           EXEs DLLs Download:REG_SZ:deinstl,dll,exec,html,image,other
           Full Download:REG_SZ:deinstl,dll,exec,html,image,other
           Run From Server:REG_SZ:deinstl,dll,exec,html,image,other
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\Backup\w32plus80
           Shareable:REG_SZ:TRUE
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\Backup\w32plus80\Map Vars
           oracle_group_name:REG_SZ:Oracle for Windows NT
           PLUS80:REG_SZ:C:\ORANT\PLUS80
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\Backup\w32plus80\OCSM Groups
           EXEs DLLs Download:REG_SZ:deinstl,msg,sql,prefs,exe
           Full Download:REG_SZ:deinstl,msg,sql,prefs,exe
           Run From Server:REG_SZ:deinstl,msg,sql,prefs,exe
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\Backup\w32plus80\Registry Backup
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\Backup\w32plus80\Registry Backup\Oracle
locations           1:REG_SZ:$ORACLE,,SQLPATH,1,0
           2:REG_SZ:$ORACLE,,PLUS80,1,0
           3:REG_SZ:$ORACLE,,EXECUTE_SQL,1,0
           4:REG_SZ:$ORACLE,,PLUS_DFLT,1,0  
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\Backup\w32rsf80
           Shareable:REG_SZ:TRUE
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\Backup\w32rsf80\Map Vars
           CORE40:REG_SZ:C:\ORANT\CORE40
           NLSRTL33:REG_SZ:C:\ORANT\NLSRTL33
           OTRACE80:REG_SZ:C:\ORANT\OTRACE80
           PLSQL80:REG_SZ:C:\ORANT\PLSQL80           PRO80:REG_SZ:C:\ORANT\PRO80
           RDBMS80:REG_SZ:C:\ORANT\RDBMS80
           WINSYS:REG_SZ:C:\WINNT\System32  
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\Backup\w32rsf80\OCSM Groups
           EXES DLLS Download:REG_SZ:deinstl,deinstl70,deinstl71,msvcdll,
                mfcdll,commdll,dll,msg,sql,nlsdata,user
           Full Download:REG_SZ:deinstl,deinstl70,deinstl71,msvcdll,mfcdll,
                commdll,dll,msg,sql,nlsdata,user
           Run From Server:REG_SZ:deinstl,deinstl70,deinstl71,msvcdll,mfcdll,
                commdll,dll,msg,sql,nlsdata,user
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\Backup\w32rsf80\Registry Backup
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\Backup\w32rsf80\Registry Backup\Oracle
locations           1:REG_SZ:$ORACLE,,RDBMS80,1,0
           2:REG_SZ:$ORACLE,,PLSQL80,1,0           3:REG_SZ:$ORACLE,,CORE40,1,0
           4:REG_SZ:$ORACLE,,NLSRTL33,1,0
           5:REG_SZ:$ORACLE,,ORA_NLS33,1,0           6:REG_SZ:$ORACLE,,PRO80,1,0
           7:REG_SZ:$ORACLE,,OTRACE80,1,0  
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\Misc_Reg_Entries
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\OO4O           CacheBlocks:REG_SZ:20
           FetchLimit:REG_SZ:20           FetchSize:REG_SZ:4096
           HelpFile:REG_SZ:C:\ORANT\MSHELP\oracleo.hlp
           PerBlock:REG_SZ:16           SliceSize:REG_SZ:256
           TempFileDirectory:REG_SZ:c:\temp
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\ORACLE_HOMES
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\ORACLE_HOMES\ORACLE1
           API:REG_EXPAND_SZ:C:\ORANT\DBS
           COMPANY_NAME:REG_EXPAND_SZ:Oracle Corp
           MSHELP:REG_EXPAND_SZ:C:\ORANT\mshelp
           NLS_LANG:REG_EXPAND_SZ:AMERICAN_AMERICA.WE8ISO8859P1
           ORACLE_GROUP_NAME:REG_EXPAND_SZ:Oracle for Windows NT
           ORACLE_HOME:REG_EXPAND_SZ:C:\ORANT
           OTRACE73:REG_EXPAND_SZ:C:\ORANT\OTRACE73
           SHARED_ORACLE_HOME:REG_EXPAND_SZ:C:\ORANT  
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\ORACLE_HOMES\ORACLE1\Misc_Reg_Entries
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\SECURITY
           ORA_ORCL_STARTMODE:REG_SZ:TRUE  
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\SMPDaemon
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\SMPDaemon\Version1
           Agent Period:REG_SZ:3           Connection Cache:REG_SZ:10
           Discover Period:REG_SZ:1800           Heartbeat Period:REG_SZ:60
           Heartbeat Timeout:REG_SZ:60           Port:REG_SZ:7770
           Register User on Startup:REG_SZ:1           Retry Period:REG_SZ:60
           Worker Threads:REG_SZ:5  
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\Software Manager
           Console Directory:REG_SZ:C:\ORANT\Sysman\OSM10
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\Software Manager\Object Manager
           OSM_SIMPLIFIED:REG_SZ:TRUE
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\VOBMGR1.4.0           allow_ignore:REG_SZ:0
           debug_flags:REG_SZ:                       file_wip_enabled:REG_SZ:0
           home:REG_SZ:${oracle_home}sysman/admin
           plsql_postfix:REG_SZ:;           startlog:REG_SZ:${home}vobmgr.log
           version_table:REG_SZ:smp_rep_version
           vobctrl_xrl:REG_SZ:vobctrl.xrl
           vobxtrn_xrl:REG_SZ:vobxtrn.xrl           wip_batch:REG_SZ:0
           wip_logfile:REG_SZ:0           wip_logtable:REG_SZ:0
           wip_window:REG_SZ:1  HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\XPLIB1.4.0
           analysis_delete:REG_SZ:100           commit_interval:REG_SZ:10
           debug_flags:REG_SZ:                 default_rule_file:REG_SZ:xpo000
           default_sql_format:REG_SZ:1           default_xdl:REG_SZ:.xdl
           file_wip_enabled:REG_SZ:1
           home:REG_SZ:${oracle_home}sysman/expert
           kb_activate_style:REG_SZ:binary
           kb_binary_extension:REG_SZ:.xrb           kb_eob_marker:REG_SZ:[EOB]
           kb_float_cache:REG_SZ:10           kb_frame_stack_size:REG_SZ:75
           kb_init_file:REG_SZ:k:/xplib/devel/init.xrl
           kb_int_cache:REG_SZ:15           kb_maximum_data_cache:REG_SZ:300
           kb_maximum_debug_breaks:REG_SZ:20
           kb_maximum_function_arguments:REG_SZ:10
           kb_maximum_registers:REG_SZ:300
           kb_rule_bootstrap_command:REG_SZ:goal();
           kb_rule_bootstrap_file:REG_SZ:xpom00
           kb_rule_hash_table_size:REG_SZ:100           kb_rule_trace:REG_SZ:0
           kb_source_buffers:REG_SZ:20           kb_source_extension:REG_SZ:.xrl
           kb_source_library:REG_SZ:k:/xplib/xpxrbo/
           kb_string_cache:REG_SZ:15           kb_uint_cache:REG_SZ:10
           kb_variable_hash_table_size:REG_SZ:400
           kb_variable_stack_size:REG_SZ:100           list_cache_size:REG_SZ:50
           max_cache_txn_reqs:REG_SZ:50           max_orphan_txn_reqs:REG_SZ:100
           max_wip_history_lines:REG_SZ:1000
           maximum_stat_samples:REG_SZ:8640
           scratch_path:REG_SZ:${oracle_home}sysman/temp
           sql_hash_key:REG_SZ:137           startlog:REG_SZ:${home}xplib.log
           string_cache_size:REG_SZ:50
           tempfile_mask:REG_SZ:xptmp%1.tmp
           timestamp_format:REG_SZ:%1 %2           trace_report:REG_SZ:0
           wip_batch:REG_SZ:0           wip_interval:REG_SZ:20
           wip_logfile:REG_SZ:0           wip_logtable:REG_SZ:0
           wip_window:REG_SZ:0           work_in_progress_interval:REG_SZ:1
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Oracle80
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Oracle80\Performance
           Close:REG_SZ:CloseOracle8PerformanceData
           Collect:REG_SZ:CollectOracle8PerformanceData
           First Counter:REG_DWORD:0x796           First Help:REG_DWORD:0x797
           Hostname:REG_SZ:(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=BEQ)
                (PROGRAM=oracle80)(ARGV0=oracle80orcl)(ARGS='(DESCRIPTION=
(LOCAL=YES)
                (ADDRESS=(PROTOCOL=beq)))')))(CONNECT_DATA=(SID=ORCL)))
           Last Counter:REG_DWORD:0x7f2           Last Help:REG_DWORD:0x7f3
           Library:REG_SZ:operf80.dll
           LOGFILE:REG_SZ:C:\ORANT\dbs\operf80.log
           Open:REG_SZ:OpenOracle8PerformanceData
           Password:REG_SZ:Manager
           PERF_FILE_NAME:REG_SZ:C:\ORANT\dbs\perf80.ora
           Username:REG_SZ:SYSTEM
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\OracleAgent
           DisplayName:REG_SZ:OracleAgent           ErrorControl:REG_DWORD:0x1
           ImagePath:REG_EXPAND_SZ:C:\ORANT\agentbin\DBSNMP.EXE
           ObjectName:REG_SZ:LocalSystem           Start:REG_DWORD:0x3
           Type:REG_DWORD:0x10  
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\OracleAgent\Security
           Security:REG_BINARY:<intentionally left blank>
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\OracleClientCache80
           DisplayName:REG_SZ:OracleClientCache80
           ErrorControl:REG_DWORD:0x1
           ImagePath:REG_EXPAND_SZ:C:\ORANT\BIN\ONRSD80.EXE
           ObjectName:REG_SZ:LocalSystem           Start:REG_DWORD:0x3
           Type:REG_DWORD:0x10 H
KEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\OracleClientCache80\Security
           Security:REG_BINARY:<intentionally left blank>
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\OracleNamesService80
           DisplayName:REG_SZ:OracleNamesService80
           ErrorControl:REG_DWORD:0x1
           ImagePath:REG_EXPAND_SZ:C:\ORANT\BIN\NAMES80.EXE
           ObjectName:REG_SZ:LocalSystem           Start:REG_DWORD:0x3
           Type:REG_DWORD:0x10  HK
EY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\OracleNamesService80\Security
           Security:REG_BINARY:<intentionally left blank>
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\OracleServiceORCL
           DisplayName:REG_SZ:OracleServiceORCL
           ErrorControl:REG_DWORD:0x1
           ImagePath:REG_EXPAND_SZ:C:\ORANT\bin\oracle80.exe ORCL
           ObjectName:REG_SZ:LocalSystem           Start:REG_DWORD:0x2
           Type:REG_DWORD:0x110
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\OracleServiceORCL\Enum
           0:REG_SZ:Root\LEGACY_ORACLESERVICEORCL\0000
           Count:REG_DWORD:0x1           NextInstance:REG_DWORD:0x1
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\OracleServiceORCL\Security
           Security:REG_BINARY:<intentionally left blank>
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\OracleStartORCL
           DependOnGroup:REG_MULTI_SZ:        
           DependOnService:REG_MULTI_SZ:OracleServiceORCL
           DisplayName:REG_SZ:OracleStartORCL
           ErrorControl:REG_DWORD:0x1
           ImagePath:REG_EXPAND_SZ:C:\ORANT\bin\strtdb80.exe
           ObjectName:REG_SZ:LocalSystem           Start:REG_DWORD:0x2
           Type:REG_DWORD:0x10  
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\OracleStartORCL\Enum
           0:REG_SZ:Root\LEGACY_ORACLESTARTORCL\0000
           Count:REG_DWORD:0x1           NextInstance:REG_DWORD:0x1  
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\OracleStartORCL\Security
           Security:REG_BINARY:<intentionally left blank>
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\OracleTNSListener80
           DisplayName:REG_SZ:OracleTNSListener80
           ErrorControl:REG_DWORD:0x1
           ImagePath:REG_EXPAND_SZ:C:\ORANT\BIN\TNSLSNR80.EXE
           ObjectName:REG_SZ:LocalSystem           Start:REG_DWORD:0x2
           Type:REG_DWORD:0x10  
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\OracleTNSListener80\Enum
           0:REG_SZ:Root\LEGACY_ORACLETNSLISTENER80\0000
           Count:REG_DWORD:0x1           NextInstance:REG_DWORD:0x1 H
KEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\OracleTNSListener80\Security
           Security:REG_BINARY:<intentionally left blank>
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\OracleWebAssistant
           DisplayName:REG_SZ:OracleWebAssistant
           ErrorControl:REG_DWORD:0x1
           ImagePath:REG_EXPAND_SZ:C:\ORANT\bin\OWASTsvr.exe
           ObjectName:REG_SZ:LocalSystem           Start:REG_DWORD:0x2
           Type:REG_DWORD:0x10           Version:REG_SZ:1.0
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\OracleWebAssistant\Enum
           0:REG_SZ:Root\LEGACY_ORACLEWEBASSISTANT\0000
           Count:REG_DWORD:0x1           NextInstance:REG_DWORD:0x1  
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\OracleWebAssistant\Security
           Security:REG_BINARY:<intentionally left blank>
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\OracleWebAssistant\WebPages

poncejua, thanks for the that, it answers the ORA_SHUTDOWN part of the question: TRUE or FALSE I guess, with a datatype of REG_EXPAND_SZ

But I still need to know about the WORKINGSET parameters.

This is just in addition to the answer above -
The  line which reads -
if ora_workingsetmin is used in isolation  - is completed as
if ora_workingsetmin is used in isolation , then once the working set
rises above the threshold , it will not drop below.

Also set these parameters in
HKEY_LOCAL_MACHINE -> SOFTWARE -> ORACLE in the
registry

Almost there, the datatype is REG_SZ ?

And what are the default values?

OK! Here we go ...

The default is "FALSE"

and the data values you could set are like 20 for 20MB and
30 for 30MB.

It is a string value.

OK, so i now know how to adjust the workingset size, but I still don't know what the default values for the MAX and MIN are, or are they calculated based on memory size?

Sorry to string this one out, but I omitted this detail from the initial question in error. (I knew what I wanted!!!)

This is my understanding of these parameters.

The workingsetmax is not very useful, but when set would go as high as the total size of the shared_pool, buffer_cache and redo_buffers , which would be the same as setting pre_page_sga. This may not be optimal as other processes could be suffering because of this - especially if the database has a varying work load.

The workingsetmin which is more useful, when set let's say to 20MB, when the system gets loaded, the oracle process retains its memory pages and doesn't fall below the 20MB.

I think that when these parameters are not set by default they are set to false, Oracle's
working set is not fixed and it contends with every other process to get  its memory requirement,  and at instance startup only a few of the memory pages are touched .  And  if other processes are faulting oracle's memory pages / working set could get trimmed and oracle's memory pages could get paged out.

If you don't set , then oracle and NT handle the working set for Oracle and does not reserve any memory pages for oracle and could get paged out if other processes are faulting.

If set then the oracle's working set doesn't go below ORA_WORKINGSETMIN.

Thanks, I'll go and experiment on some systems!