11.2 AQ – Messages stuck in PROCESESED,WAIT State
I had been working today on AQ issue where messages were not moving from WAIT to READY State.This was on 11.2.0.3 database running on RHEL5u6(64 bit). I thought of quickly…
Read Full RecipeI had been working today on AQ issue where messages were not moving from WAIT to READY State.This was on 11.2.0.3 database running on RHEL5u6(64 bit). I thought of quickly…
Read Full RecipeWhile working with ADRCI , I came to know that we can run normal SQL commands for some of the operation.e.g To display current purge policy , you can run…
Read Full RecipeIt seems Mayan's freaked out lot of people by not making 2013 calendar :) Anyways our world survives and we will be entering 2013 in another 7 hours. So wishing…
Read Full RecipeOracle released 12.1.0.2 Enterprise Manager few days back and have released it for most of platforms. You can directly upgrade Enterprise Manager Cloud Control 12c Release 1 (12.1.0.1) [with or…
Read Full RecipeRecently I was working on using Oracle DBMS_RESOURCE_MANAGER to limit resources usage by read-only queries. This was required to prevent long running ad-hoc and poorly written queries.Instead of writing custom…
Read Full RecipeThis is pretty old comic from geek&Poke . Enjoy :)
Read Full Recipe