(Kellyn Pot’Vin-Gorman) I get a lot of questions starting with, “Where do I find…” and end with “in the Oracle Management Repository, (OMR)?”

(Martien van den Akker) Yes, Oracle FMW Integration Insight is available, as I wrote in an earlier post. You can download it here.

(Hemant K Chitale) Following up on my earlier post on 12.1.0.2 Advanced Index Compression, one of my readers asked what would be the difference if I reversed the order of columns in the chosen index.

(Lucas Jellema) Node applications may want to have access to databases – similar to access to the file system, external APIs over HTTP and other resources. Just like Java applications use a JDBC driver to access a relational database, Node.js applications can leverage a database driver for the datab

(connormcdonald) When using strings such as gFREQ=DAILY; BYDAY=MON,TUE,WED,THU,FRI; BYHOUR=9,10 within the scheduler, sometimes its not readily apparent how this will translate to actual dates and times of the day that the scheduled activity will run.

(Natik Ameen) Occasionally there is a need to generate multiple AWR reports for database analysis. In my case, a storage vendor will use a tool to extract data from all time periods from the AWR reports to find IO related specific information. Here is how I generated these reports.

(Dbaharrison) Now this week I’ve really had to think when performing some SQL tuning, my usual trick of just looking at some SQL and just saying ‘add this index’ or do some other clever stuff just wasn’t cutting it – i had to actually start understanding the data and what was actually going on causi

(Svetoslav Gyurov) These days everything goes to the cloud or it has been collocated somewhere in a shared infrastructure. In this post I’ll talk about sessions being disconnected from your databases, firewalls and dead connection detection.

(Emil Pilecki) Our typical setup of Oracle databases consists of a primary RAC cluster along with a standby database, also in RAC configuration. We are taking RMAN database backups from standby, while archivelog are backed up from primary database.

(Kellyn Pot’Vin-Gorman) Since the introduction of Enterprise Manager 12c, folks have been asking for a list of best practices. I know a lot of you have been waiting for this post!