SMP001-01:/tmp # cufconfig -o > backup_cufconfig_20180119.txt SMP001-01:~ # cufconfig -o|grep MallocLimit MallocLimit: 33554432
SMP001-01:~ # cd /tmp/ SMP001-01:/tmp # vi mygdo.txt MallocLimit: 67108864
SMP001-01:/tmp # cufconfig -f /tmp/mygdo.txt _______ | | | | ___ __ ____ | ____ __|__ ____ | / |/ \ ____| ____| ____| | ____| | --- | / | / | / | | / | | \___ | \____| \____| \____| |__ \____|
Release 15.10.06.06 Version 15.10.06.08 UDF GDO Configuration Utility (Mar 2006) UDFConfig_t size 120768 gdo size 120768 version 10 Exiting cufconfig... SMP001-01:/tmp # cufconfig -o|grep MallocLimit MallocLimit: 67108864
To make effect of the change it require to reboot database engine.
SMP001-01:/tmp # cnsterm 6 Attempting to connect to CNS...Completed. Hello Input Supervisor Command: > disable logons disable logons 18/01/19 12:19:13 Logons disabled. Input Supervisor Command: Input Supervisor Command: > abort session *.* abort session *.* Input Supervisor Command:
SMP001-01:~ # tpareset -f "Reboot for Malloklimit Change" You are about to restart the database on the system 'DWTSAWSDBS03' Do you wish to continue (default: n) [y,n] y
Check the status of database SMP001-01:~ # psh pdestate -a
<--------------------- localhost --------------------------------> PDE state is RUN/STARTED. DBS state is 1/1: DBS Startup - Initializing DBS Vprocs
SMP001-01:~ # psh pdestate -a
<--------------------- localhost --------------------------------> PDE state is RUN/STARTED. DBS state is 2: Logons are disabled - Users are logged on
SMP001-01:/tmp # cnsterm 6 Attempting to connect to CNS...Completed. Hello
Input Supervisor Command: > enable logons enable logons 18/01/19 12:26:20 Logons enabled.
SMP001-01:~ # psh pdestate -a <--------------------- localhost --------------------------------> PDE state is RUN/STARTED. DBS state is 4: Logons are enabled - Users are logged on
SMP001-01:/tmp # cufconfig -o|grep MallocLimit
MallocLimit: 67108864 |