Optimize Oracle Database

Optimize Oracle Database

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
*FIXED* Setting you Railo / Lucee server to use TLS 1.2 by setting to use Java 1.8 instead of Java 1.7.

*FIXED* Setting you Railo / Lucee server to use TLS 1.2 by setting to use Java 1.8 instead of Java 1.7.

TLS 1.0 support is being dropped by more and more platforms. If you are using your Railo / Lucee server to communicate with the service that have dropped the support using TLS 1.0, the request will not be honored. Here are the steps to have your Railo/Lucee server to use...Read more
Backup Third Party Drivers in Windows 10

Backup Third Party Drivers in Windows 10

To back up your current collection of drivers, open File Explorer and go to C:\Windows\System32\DriverStore. Copy the FileRepository subfolder to a backup location. Reference: http://www.zdnet.com/article/windows-10-tip-back-up-your-third-party-hardware-drivers/Read more