Blog

Start Here

Get in touch with a
TriCore Solutions specialist

Blog

Soumya Guha Roy

Recent Posts

Blog | Oct 21, 2015

Advanced Compression - Part 3

Posted by Soumya Guha Roy


It can be easily seen, that the compressed table saves almost 60% on blocks compared to the uncompressed table in practical scenarios, this depends on how the data is structured.

Read More

Blog | Oct 20, 2015

Advanced Compression – Part 2

Posted by Soumya Guha Roy


One significant advantage is Oracle’s ability to read compressed blocks directly without having to first uncompress the block. Therefore, there is no measurable performance degradation for accessing compressed data.
Read More

Blog | Oct 16, 2015

Advanced Compression: Optimizing storage for E-Business Suite-Part 1

Posted by Soumya Guha Roy


Data compression algorithms have been around for nearly a century, but only now they are being put to use within mainstream information systems processing.

Read More

Blog | Nov 11, 2014

Some Uncommon Recovery Scenarios Explained – Tips for DBAs-Part 2

Posted by Soumya Guha Roy


Let’s start with the traditional approach and see how and why it fails to recover the corrupt block, and then we will find our way out.

Read More

Blog | Nov 7, 2014

Some Uncommon Recovery Scenarios Explained – Tips for DBAs

Posted by Soumya Guha Roy


What do you do if some rows from a table in production get deleted. How to get them back? 


Read More