Detecting dead Oracle database connections
Detecting dead Oracle database connections In my 20+ years of working with Oracle databases, I have heard the same question asked many times: “When does the Oracle database clean up…
Oracle SQL injections and Oracle database security
Oracle SQL injections and Oracle database security In this article, I would like to describe one of the most dangerous and sophisticated ways of hacking databases based on the implementation…
Parallel processing in Oracle Database 12c
Parallel processing in Oracle Database 12c Improving performance (and by this, we usually mean query performance) is always a hot item with database administrators and users. One of the best…
Excerpt from Oracle analytic functions: tips and tricks
Excerpt from Oracle analytic functions: tips and tricks Infolob’s lead Oracle DBA, Ravi Kumar, recently co-authored an article in OraWorld with Mari Kupatadze of FlashGrid detailing some tips for utilizing analytic functions…
