Nothing but my learning and experience with Oracle..!

While goggling I got a good notes on different state and status of a oracle session .So I thought of sharing it here .  First, we have V$...

Parallel execution enables multiple processes to work simultaneously to refresh the materialized view, resulting in speeding up the refres...

Every time you use a normal view oracle has to execute the sql statement defined for that view (called view resolution), it must be done ea...

Yesterday , I had faced a strange issue while starting up oracle instance after applying PSU4 into our 12.1.0.2 database . Even when my AS...