Fulltext results:

Oracle: SPFile and PFiles @info:oracle

5 Hits, Last modified: 12 years ago

====== Oracle: SPFile and PFiles ====== Oracle reads its parameters from a file called "SPFile". You can'... dditionally, Oracle can read the parameters from "PFiles", which are regular text files. ===== Create PFile ===== To export the SPFiles to a PFile, just enter the following in SQLplus: ... If your PFile is located at ''/db/oracle/config/pfiles/initweb.ora'', the the second line would be: <co

Oracle Errors @info:oracle

1 Hits, Last modified: 12 years ago

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

Oracle: Resize Instance @info:oracle

1 Hits, Last modified: 12 years ago

d the PGA to 2GB. First, change the [[spfile_and_pfiles|SPFile]]: <code sql> ALTER SYSTEM SET pga_aggreg