Fulltext results:

Oracle: SPFile and PFiles

6 Hits, Last modified: 12 years ago

PFiles ====== Oracle reads its parameters from a file called "SPFile". You can't change it directly as it's a binary file. Additionally, Oracle can read the parameters from "PFiles", which are regular text files. ===== Create PFile ===== To export the SPFi... = ==== Flash Recovery Area ==== === DB_RECOVERY_FILE_DEST_SIZE === The parameter ''DB_RECOVERY_FILE

Oracle: Resize Instance

2 Hits, Last modified: 12 years ago

e SGA will be resized to 6GB and the PGA to 2GB. First, change the [[spfile_and_pfiles|SPFile]]: <co... e: <code sql> CREATE PFILE FROM SPFILE; </code> Finally, reboot the instance to activate the change:

Oracle: EXP

1 Hits, Last modified: 12 years ago

{user}''. <code bash> exp USERID=\'/ as sysdba\' FILE={user}.dmp FULL=N OWNER={user} </code> {{tag>a