Fulltext results:

Oracle: SPFile and PFiles

35 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

Oracle: Resize Instance

11 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]]: <code sql> ALTER SYSTEM SET pga_aggregate_target = 2G SCOPE=SPFILE; ALTER SYSTEM SET sg

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/d

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

Oracle: Recovery Manager

1 Hits, Last modified: 12 years ago

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