Fulltext results:

Oracle: SPFile and PFiles

32 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

Oracle: Resize Instance

9 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; <

Oracle Errors

2 Hits, Last modified: 12 years ago

an|Remove archive logs]]. * **Resolution**: [[spfile_and_pfiles|Enlarge the flash recovery area]]. * **Documentation**: [[http://download.oracle.com/docs/

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: Recovery Manager

1 Hits, Last modified: 12 years ago

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