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