TAG: oracle

DBMS_APPLICATION_INFO to manage long-running operation 2017/09/06 19:27 DBMS_APPLICATION_INFO to manage long-running operation oracle debug About Long running operation is defined as longer than three to five seconds. If you execute a long-running command, a dynamic performance view V$SESSION_LONGOPS will be populated with information with the following information : ,
Oracle Olap 2017/09/06 19:38 Oracle Olap olap oracle Documentation * Documentation About An alternative approach to Materialized view and Query Rewrite is to use Oracle OLAP, which has been an option for Oracle Database Enterprise Edition since Oracle 9i. Oracle OLAP allows you to store your data in a special format inside the database using cubes and dimensions that enables fast analysis and query reporting. ,