Fulltext results:

Oracle: SPFile and PFiles

8 Hits, Last modified: 12 years ago

====== Oracle: SPFile and PFiles ====== Oracle reads its parameters from a file called "SPFile". You can't change it directly as it's a binary f... t files. ===== Create PFile ===== To export the SPFiles to a PFile, just enter the following in SQLplus: <code sql> CREATE PFILE FROM SPFILE; </code> It will create a PFile ''${ORACLE_HOME}

Oracle: Resize Instance

6 Hits, Last modified: 12 years ago

d to 6GB and the PGA to 2GB. First, change the [[spfile_and_pfiles|SPFile]]: <code sql> ALTER SYSTEM SET pga_aggregate_target = 2G SCOPE=SPFILE; ALTER SYSTEM SET sga_target = 6G SCOPE=SPFILE; </code> Then, (optionally) export the SPFile to a PFile:

Oracle Errors

1 Hits, Last modified: 12 years ago

rman|Remove archive logs]]. * **Resolution**: [[spfile_and_pfiles|Enlarge the flash recovery area]]. *