Fulltext results:

Oracle: SPFile and PFiles

4 Hits, Last modified: 12 years ago

ash Recovery Area ==== === DB_RECOVERY_FILE_DEST_SIZE === The parameter ''DB_RECOVERY_FILE_DEST_SIZE'' specifies the size of the flash recovery area. * For more inforamtion, see the documentation: [[ht... <code sql> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE=8G SCOPE=BOTH SID='*'; </code> {{tag>admin oracl

Oracle: Resize Instance

2 Hits, Last modified: 12 years ago

====== Oracle: Resize Instance ====== In this example, the SGA will be resized to 6GB and the PGA to 2GB. First, change the [[

Oracle: SQLplus Scripting

2 Hits, Last modified: 12 years ago

ng: <code sql> SET NEWPAGE 0 SET SPACE 0 SET LINESIZE 80 SET PAGESIZE 0 SET ECHO OFF SET FEEDBACK OFF SET VERIFY OFF SET HEADING OFF SET MARKUP HTML OFF SPOO