pfile和spfile之间的转换

SQL> create pfile=’/tmp/init.ora’ from spfile;
File created.

https://www.cndba.cn/hbhe0316/article/4846

https://www.cndba.cn/hbhe0316/article/4846

SQL>!echo ‘*.sga_target=2000M’ >> /tmp/init.ora

https://www.cndba.cn/hbhe0316/article/4846

SQL> shutdown immediate
ORA-01507: database not mounted
ORACLE instance shut down.
SQL> create spfile from pfile=’/tmp/init.ora’;
File created.https://www.cndba.cn/hbhe0316/article/4846https://www.cndba.cn/hbhe0316/article/4846

SQL> startup
ORACLE instance started.
Total System Global Area 2097152000 bytes
Fixed Size 8622624 bytes
Variable Size 822087136 bytes
Database Buffers 1258291200 bytes
Redo Buffers 8151040 bytes
Database mounted.
Database opened.

SQL> show parameter sga;https://www.cndba.cn/hbhe0316/article/4846

NAME TYPE VALUE

https://www.cndba.cn/hbhe0316/article/4846

https://www.cndba.cn/hbhe0316/article/4846

---

allow_group_access_to_sga boolean FALSE
lock_sga boolean FALSE
pre_page_sga boolean TRUE
sga_max_size big integer 2000M
sga_min_size big integer 0
sga_target big integer 2000M
unified_audit_sga_queue_size integer 1048576https://www.cndba.cn/hbhe0316/article/4846

https://www.cndba.cn/hbhe0316/article/4846

版权声明：本文为博主原创文章，未经博主允许不得转载。

Linux,oracle