SQL> create pfile='F:\oracle19c\dbs\initorcl.ora' from spfile;File created.SQL> shutdown immediate修改生成的pfile文件,以下为修改前的参数值:*.sga_max_size=8388608000*.sga_target=9799m可以看到sga_target比sga_max_size值大。将sga_max_size修改为:*.sga_max_size=12000mC:\Users\Administrator>sq...
SQL> create pfile='F:\oracle19c\dbs\initorcl.ora' from spfile;File created.SQL> shutdown immediate修改生成的pfile文件,以下为修改前的参数值:*.sga_max_size=8388608000*.sga_target=9799m可以看到sga_target比sga_max_size值大。将sga_max_size修改为:*.sga_max_size=12000mC:\Users\Administrator>sq...
SQL> create pfile='F:\oracle19c\dbs\initorcl.ora' from spfile;File created.SQL> shutdown immediate修改生成的pfile文件,以下为修改前的参数值:*.sga_max_size=8388608000*.sga_target=9799m可以看到sga_target比sga_max_size值大。将sga_max_size修改为:*.sga_max_size=12000mC:\Users\Administrator>sq...