Fulltext results:

Oracle: SPFile and PFiles

4 Hits, Last modified: 12 years ago

==== Oracle reads its parameters from a file called "SPFile". You can't change it directly as it's a ... tead of ${PATH_TO_PFILE}. <code sql> SHUTDOWN IMMEDIATE; STARTUP NOMOUNT PFILE='${PATH_TO_PFILE}' CREATE SPFILE FROM PFILE; SHUTDOWN IMMEDIATE; </code> If your PFile is located at ''/db/oracle/config/pfiles/initweb.ora'', the the second li

Oracle: Recovery Manager

3 Hits, Last modified: 12 years ago

45 days: <code sql> DELETE ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE -45'; </code> To remove archive ... <code sql> DELETE NOPROMPT ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE -45'; </code> A sample script co... << __EOF__ DELETE NOPROMPT ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE -3'; EXIT __EOF__ </code> {{tag>

Oracle: Resize Instance

2 Hits, Last modified: 12 years ago

nce ====== In this example, the SGA will be resized to 6GB and the PGA to 2GB. First, change the [[s... nstance to activate the change: <code sql> SHUTDOWN IMMEDIATE; STARTUP; </code> {{tag>admin oracle}}

Oracle Errors

1 Hits, Last modified: 12 years ago

: archiver error. Connect internal only, until freed. ===== * **Reason**: The flash recovery area i

Oracle: SQLplus Scripting

1 Hits, Last modified: 12 years ago

SET LINESIZE 80 SET PAGESIZE 0 SET ECHO OFF SET FEEDBACK OFF SET VERIFY OFF SET HEADING OFF SET MARKUP