(amitzil) My previous post that showed a real life troubleshooting was a hit. I guess people like to hear these kind of things, so I decided to write another post, this time a real life SQL tuning.

(John Hallas) Security asked to determine when certain passwords were last changed and I used the ptime column in user$ table to find out.

(Lucas Jellema) The Oracle Storage Cloud Service is an IaaS offering that underpins [almost]every other PaaS Cloud Service from Oracle. I have been using this service – largely indirectly – with DBaaS, JCS, Application Container Cloud (ACCS) and SOA CS.

(Martin Bach) Prompted by comments made by readers about my posts describing how to add a second SCAN in 12c Release 1 and problems regarding the listener_networks parameter I thought it was time to revisit the situation. I’m still running Oracle Linux 7.1/UEK3 (although that should not matter) but

(Hemant K Chitale) It is generally accepted that service definition is required in RAC environments.

(Oren Nakdimon) In Part 1 we saw that the SQL function COLLECT with the DISTINCT option is not natively supported in PL/SQL.

(Andrejus Baranovskis) LOV is popular component in ADF, it allows to seach for data entry in the list, select it and assign to the attribute. I was researching, how similar concept can be implemented in Oracle JET, based on data from ADF BC REST service.

(Michael McLaughlin) While SQL Developer installs with a dbms_output view, some organizations close it before they distribute images or virtual machine (VM) instances. This post shows you how to re-enable the Dbms Output view for SQL Developer.

(Oren Nakdimon) Almost every valid SQL statement (i.e., that is executed successfully by the SQL engine) can be embedded successfully as a static SQL in PL/SQL. Almost, but not every statement. One example is the COLLECT aggregate function with the DISTINCT option.

(David Fitzjarrell) With the introduction of Auto Degree Of Parallelism (Auto DOP) in version 11 Oracle made it necessary to run a DBMS_RESOURCE_MANAGER procedure named CALIBRATE_IO.