Oracle Database 12c Interactive Quick Reference

You may remember days when you had huge Oracle posters on your cubicle wall that listed the various data dictionary views, or the underlying Oracle architecture.  Maybe you still have them.  For the 12c version of the database Oracle provides the Oracle Database 12c: Interactive Quick Reference.
The Quick Reference provides information on:

  • DBA Views
  • Performance Views
  • Architecture Views
  • Database Architecture
  • Multitenant Architecture
  • Background Processes

As part of the Quick Reference there are Architecture .pdfs (more...)

Which file system to source for adop

One of the big changes for Oracle Applications DBAs in EBS 12.2 is the introduction of online patching.  Instead of using adpatch to apply application patches we now use adop.  In order to allow for online patching Oracle has introduced the dual file system (Run and Patch).  I'm not going to go into a complete explanation of the dual file system in this post, but you can think of it as being two copies (more...)