Limitations in Cognos transformer and work around

Limitations in Cognos transformer and work around

Cognos transformer has limitation, it cannot build cube more than 2GB size, cube gets fails as it exceeds more than 2 GB data while building. We have one of the following workarounds for handling this limitation for Cognos power cubes. Time based Partition: for this...
How to find long running sessions in Oracle database

How to find long running sessions in Oracle database

Introduction: Sessions which are running longer in oracle database can be viewed from v$session_longops view provided by Oracle. For RAC, make sure to use gv$session_longops instead of v$. In this blog, will see how to find long running sessions or long operations in...