Allows you to control the database global buffers feature without requiring that the database be open.
1 – Description
If you move a database from one system to another, or when memory usage or system parameters change, you may have to modify the global buffer parameters for a database when it is not possible to open the database. This situation could occur, for example, if you have insufficient available physical or virtual memory. The RMU Set Global_Buffers command allows you to alter some of the global buffer-related parameters without opening the database. This allows you to reconfigure the database so that it can be opened and accessed on the system.
2 – Format
(B)0[mRMU/Set Global_Buffers root-file-spec [4mCommand[m [4mQualifiers[m x [4mDefaults[m x /Disabled x None /Enabled x None /Large_Memory={Enabled|Disabled} x None /Log x None /Number=n x None /User_Limit=n x None
3 – Parameters
3.1 – root-file-spec
Specifies the database root file for which you want to modify the global buffers feature.
4 – Command Qualifiers
4.1 – Disabled
Disables global buffers for the specified database.
4.2 – Enabled
Enables global buffers for the specified database.
4.3 – Large Memory
Large_Memory=Enabled Large_Memory=Disabled Large_Memory=Enabled enables global buffers in large memory (VLM). Large_Memory=Disabled disables global buffers in large memory (VLM).
4.4 – Log
Displays a log message at the completion of the RMU Set Global_ Buffers command.
4.5 – Number
Number=n Sets the number of global buffers.
4.6 – User Limit
User_Limit=n Sets the global buffers user limit value.
5 – Usage Notes
o This command requires exclusive database access (the database cannot be open or accessed by other users). o The Enabled and Disabled qualifiers are mutually exclusive. o The Large_Memory=Enabled and Large_Memory=Disabled qualifiers are mutually exclusive. o Changes made by the RMU Set Global_Buffers command are not journaled. You should make a subsequent full database backup to ensure recovery. o When global buffers are set to reside in large memory (Large_Memory=Enabled), the process that opens the database must be granted the VMS$MEM_RESIDENT_USER rights identifier. Oracle Corporation recommends that you use the RMU Open command when you utilize this feature.