Oracle | Obidos Technologies Knowledge Base

Using Server Sent Events (SSE) with Session

Posted on March 13, 2020
/Under Integration, JavaScript, JSON, Lucee, Node.JS, Oracle, PHP, Server, Technology, Windows
/With 0 Comments

The SSE is a very useful method to push data from server to client. This article explains the requirement and implementation of SSE with Session so that each of the connected clients get customized response.

Optimize Oracle Database

Posted on June 3, 2017
/Under Database, Oracle
/With 0 Comments

Overtime, the Oracle DB will become sluggish with the insert/update/deletes. So we need to optimize the DB so that the queries are faster. To optimize a single table, use the following command: exec DBMS_STATS.GATHER_TABLE_STATS (ownname => ‘&schema’ , tabname => ‘&tabname’, cascade => true); To optimize a single schema and...Read more