Fulltext results:

Oracle: SPFile and PFiles

26 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 file. Additionally, Oracle can read the parameters from

Oracle: Resize Instance

8 Hits, Last modified: 12 years ago

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 PFil

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>adm

Oracle Errors

1 Hits, Last modified: 12 years ago

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

Oracle: Recovery Manager

1 Hits, Last modified: 12 years ago

e days): <code bash> #!/bin/bash . ${HOME}/.profile rman target / << __EOF__ DELETE NOPROMPT ARCHIV