Fulltext results:

Oracle: SQLplus Scripting

9 Hits, Last modified: 12 years ago

or other stuff, enter the following: <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 HTM

Oracle: Resize Instance

2 Hits, Last modified: 12 years ago

ile_and_pfiles|SPFile]]: <code sql> ALTER SYSTEM SET pga_aggregate_target = 2G SCOPE=SPFILE; ALTER SYSTEM SET sga_target = 6G SCOPE=SPFILE; </code> Then, (opt

Oracle: SPFile and PFiles

2 Hits, Last modified: 12 years ago

820/initparams063.htm#REFRN10235|11.2]] Example: Set flash recovery area to 8GB. The usage of ''SCOPE=... emory and in the SPFile. <code sql> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE=8G SCOPE=BOTH SID='*';