Sol:
SQL> show parameter spfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string
SQL> show parameter pfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string
SQL> show parameter dump
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
background_core_dump string partial
background_dump_dest string /slot/oracle/11.2.0/log/diag/rdbms/oracledb1/oracledb1/trace
core_dump_dest string /slot/oracle/11.2.0/log/diag/rdbms/oracledb1/oracledb1/cdump
max_dump_file_size string 10M
shadow_core_dump string PARTIAL
user_dump_dest string /slot/oracle/11.2.0/log/diag/rdbms/oracledb1/oracledb1/trace
SQL> CREATE SPFILE FROM PFILE;
File created.
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 2154590208 bytes
Fixed Size 2230112 bytes
Variable Size 1325402272 bytes
Database Buffers 805306368 bytes
Redo Buffers 21651456 bytes
Database mounted.
Database opened.
SQL> show parameter pfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string /slot/oracle/11.2.0/dbs/spfileoracledb1.ora
SQL> ALTER SYSTEM SET processes = 5000 SCOPE=SPFILE;
System altered.
No comments:
Post a Comment