In my work for Oracle RAC Support, I have noticed that people sometimes identify the wrong background process trace files… for example, uploading an old LMON trace file instead of the current one. Here are some one-liners to identify the current background traces. Read more
Category: Oracle
12.1.0.2 patch set released!
for Solaris and Linux today. See My Oracle Support note 1683799.1 for availability & known issues.
Oracle’s outer join syntax (+)
Sometimes I think I might be the only person who’s more comfortable with Oracle’s original outer join syntax than with the ANSI standard. Read more