oracle

So I've got a backup script that runs a BACKUP DATABASE followed by a BACKUP ARCHIVELOG command. The BACKUP ARCHIVELOG FROM TIME command runs to collect all the archived logs created since the beginning of the Level 0.

So the new place I work has some small applications built in Apex. I'm getting ready to build some monitoring tools and wanted to integrate their functionality into the apps that are already available.

If you haven't seen this optimizermagic.blogspot.com post already, check it out.

It covers the standard Execution Plan stuff, but also covers use of the dbms_xplan package including using dbms_xplan.display to format output and using dbms_xplan.display_cursor to see Bind Variables used to generate a plan!

Click here for Article

-- Dave

So I have mentioned before about the replication product that we use that is based on Archived Redo Logs (Golden Gate). Well sometimes the replication process abends before the RMAN backup. Since there is no communication between the two processes, RMAN happily removes archived logs that the replication process might need the next time it starts up. Because of this we usually like to keep a few hours worth of archived logs hanging around. Does this suck up disk space? Yes. Is it worth it sacrifice some disk space in order to save us some DBA time? Absolutely.