Fulltext results:

Oracle: Recovery Manager

4 Hits, Last modified: 12 years ago

days: <code sql> DELETE ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE -45'; </code> To remove archive log... ode sql> DELETE NOPROMPT ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE -45'; </code> A sample script could be (deleting all logs except the last three days): ... __EOF__ DELETE NOPROMPT ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE -3'; EXIT __EOF__ </code> {{tag>adm

Oracle: Resize Instance

1 Hits, Last modified: 12 years ago

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

Oracle: SPFile and PFiles

1 Hits, Last modified: 12 years ago

g/pfiles/initweb.ora'', the the second line would be: <code sql> STARTUP NOMOUNT PFILE='/db/oracle/co