ThatJeffSmith

Tag: logminer

Oracle’s Append Hint – Faster INSERTs But Mind the Logging!

In yesterday’s post, I posed a question: What Hint Do You See Over or Misused? Gary (Twitter) responded with With APPEND the rows are written directly to the datafiles and are not logged. If the DBA doesn’t know that unlogged changes are being made then whatever recovery plans they have may be useless when it […]

Truncates ARE Logged

Someone asked me yesterday where do I get my blog topics and ideas from. Usually it’s from watching too much TV, but often it’s an actual question or topic that is raised by a co-worker or customer. Yesterday I was asked by my boss about how to find out when TRUNCATEs have been issued because […]