(Simon Greener) The article shows how to use the Oracle utl_lms.format_message function.

(mdinh) The project was to migrate database from one DC to another.

(David Fitzjarrell) Oracle Support recently updated what I call a ‘blast from the past’; it involves a subpool memory leak in Oracle 11.2.0.1 and shared cursors. Originally submitted in 2010 this issue was updated the end of last year to reflect the status of ‘Fixed in Product Version 12.1’.

(Hemant K Chitale) Unlike tracing for particular SQL statements, you can also trace by PID (Oracle PID) or Server Process ID (SPID).

(John Hallas) After upgrading to SQL Developer 4.1.2.20 a number of users noticed that some connections in the left hand pane were greyed out. I had the same experience for myself. There did not seem to be any pattern as to why specific connections were chosen and not others. Once greyed out they re

(Frits Hoogland) This is the second blogpost on using PL/SQL inside SQL. If you landed on this page and have not read the first part, click this link and read that first. I gotten some reactions on the first article, of which one was: how does this look like with ‘pragma udf’ in the function?

(connormcdonald) So then… I’ve written a crappy piece of SQL. It wouldn’t be the first time I’ve done it… and it probably wont be the last time I do it Smile

(John Brady) How do you find out what is happening now inside an Oracle database instance when you only have SQL level access to the database instance, and no nice GUI management tool? I’ll cover how to start doing this with some SQL query examples.

(mwidlake) I was going to do a follow-up post to my post on USERENV(‘COMMITSCN’) just to describe the slightly better known but still overlooked (and possibly more useful) ORA_ROWSCN – but I don’t need to!

(Neil Chandler) I had a requirement the other day to understand when some data had been changed, but there was no column on the table which showed this.