The Four Options of the SHUTDOWN

One thing that's always good to know is that there are actually 4 different options to the Oracle SHUTDOWN command. They are:NORMALTRANSACTIONALIMMEDIATEABORTNow allow me to cover the differences.NORMALThis is the default option for the SHUTDOWN command. Once a SHUTDOWN NORMAL is issued, no new user connections will be allowed. However,... [Read More]

The Worth of Certifications

NOTE: Howard has since taken his site offline while he finds a suitable webhost, so the first link probably won't workHoward Rogers recently touched on the knowledgeset (or lack thereof) of some interviewees with OCPs. We've all heard this before, and the common theme is that just because someone managed... [Read More]
Tags: oca ocp oracle

sqlplus commit-on-exit?

ACHTUNG: Did you know that SQL*Plus issues a COMMIT when you exit? This has nothing to do with the AUTOCOMMIT setting, which will automatically commit after every statement in sqlplus.If you issue a graceful exit (via the "exit" or "quit" command), sqlplus will always issue a commit. However, if you... [Read More]
Tags: sqlplus oracle

Temporary Tables and REDO Logs

Today in DBA class, the instructor matter-of-factly rattled off some characteristics on global temporary tables. Among these I just barely noticed him state that they generate REDO logging. I sat upright and asked him to confirm that I had heard him correctly, and indeed that is what he said. He... [Read More]