Category Archives: Oracle

Notepad++: Copy highlighted code

Note to self:

You can export highlighted text (e.g.: SQL code) easily from Notepad++ to RTF and/or HTML using  “Plugins” – “NppExport” – “…”. Voilá – there’s highlighted code in your Document, Presentation, Website, a.s.f.!

Also, this: https://sqlandplsql.com/2012/08/11/notepad-tips-and-tricks/

Proposing a SQL-only Diagnosis for Blocking Locks in Single Instance and RAC

When you have to troubleshoot blocking locks in your Oracle DB, you might be lucky enough to have a GUI tool handy that helps you with that (e.g. Enterprise Manager or TOAD). Otherwise you’ll likely have to resort to Oracle’s pre-installed script “utllockt.sql”. Unfortunately, this script only shows locks in the DB instance it’s running on. However, locks chains may span multiple instances in a clustered environment.

In this brief post I’d like to propose a RAC-aware alternative to “utllockt.sql” using only SQL so it can be run in any Oracle client.

Locked?

Picture: Mike Gabelmann / flickr / CC-BY-NC-SA

Continue reading

Visualizing System Statistics in SQL Developer – OTN Appreciation Day

Tim Hall inspired me with his #ThanksOTN (or “OTN Appreciation Day“) campaign to continue my mini-series on leveraging SQL Developer Reports for DBA tasks. Today with visualizing historical System Statistics from Statspack for performance analyses.

#ThanksOTN I have three favourite Oracle features to rave about today:

  1. Analytic SQL
  2. Statspack
  3. SQL Developer (particularly the reports)!

Continue reading