I'm a longtime Windows user who recently purchased a Mac. Overall I'm very impressed with the machine, but it does have a learning curve, especially for the key bindings. As a DBA and programmer, I use the Home, End, PageUp, PageDown and CTRL keys extensively to quickly navigate code and text documents. And don't get me started... Continue Reading →
After you have issued the FLASHBACK DATABASE command how can you monitor the progress of the command, and more importantly, how can you predict when it will complete?
One of the most powerful features of Evernote is how quickly and easily you can add content to your notebooks. Sometimes however, this is both a blessing and a curse because there is no review process for removing old and outdated notes. Sometimes you come across a note that could do with more context around it as the original reason for writing/clipping it was not recorded at the time. Well luckily, there is now a nice neat solution for reviewing your notes.
The behaviour of the pullup dependency as described in the Oracle documentation for CRS resources is counter-intuitive and so I decided to do some testing around it to see the results and reassure myself that the documentation was correct.
This guide is intended to aid in establishing the origin of failed database login attempts. Most of the time these failed attempts are due to typos or outdated application configurations and are therefore not malicious, however due to default password management policies setting a limit on failed login attempts this often causes accounts to become... Continue Reading →
Before Oracle 11g, it was only possible to wrap PL/SQL code using the command line "wrap" utility. However, it is now possible to wrap code programatically after it has been loaded into the database using a simple PL/SQL procedure.
This article explains how to convert a list of values/readings into a graph to show month by month comparisons over several years as shown above.
Whilst developing some administrative functions within PL/SQL I needed to know whether the database that the code was being run in was part of an Oracle DataGuard setup, which you would think would be a trivial exercise. My first thought was that we could determine this via v$database. If the DATABASE_ROLE column in v$database contains STANDBY then we know... Continue Reading →
Two short and simple methods to create a URL which will direct someone straight to the recommendations section on your LinkedIn profile. This is useful for highlighting your existing recommendations and at the same time prompting the recipient to leave you a recommendation.