[oracle@strong ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production onThu May 3 10:55:54 2018 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release11.2.0.4.0 - Production With the Partitioning, OLAP, Data Miningand Real Application Testing options SQL> SQL> ALTER SYSTEM RESET memory_targetSCOPE=SPFILE; System altered. SQL> ALTER SYSTEM RESETmemory_max_target SCOPE=SPFILE; ALTER SYSTEM RESET memory_max_targetSCOPE=SPFILE * ERROR at line 1: ORA-32010: cannot findentry to delete in SPFILE SQL> show parameter memory_max_target NAME TYPE VALUE ------------------------------------ ----------------------------------------- memory_max_target big integer 6016M SQL> create spfile from pfile; File created. [oracle@strongdbs]$ ll 总用量 24 -rw-rw----. 1oracle dba 1544 5月 3 11:12 hc_YADATA.dat -rw-r--r--. 1oracle dba 2851 5月 15 2009 init.ora -rw-r--r--. 1oracle dba 927 5月 3 11:11 initYADATA.ora -rw-r-----. 1oracle dba 24 6月 29 2017 lkYADATA -rw-r-----. 1oracle dba 1536 6月 29 2017 orapwYADATA -rw-r-----. 1oracle dba 2560 5月 3 11:12 spfileYADATA.ora [oracle@strongdbs]$ vi initYADATA.ora 删除*.memory_target=6294967295 |