Checking Database Feature Usage Stats
Today I came across view DBA_FEATURE_USAGE_STATISTICS (10g) which let's us know whether particular Database Feature has been used till now or not. If yes, then it also let's us know…
Read Full RecipeToday I came across view DBA_FEATURE_USAGE_STATISTICS (10g) which let's us know whether particular Database Feature has been used till now or not. If yes, then it also let's us know…
Read Full RecipeNot sure, how many of you are aware of this alert. Oracle has published an Alert document NOTE:726418.1 -ALERT: The 10.2.0.4 Windows Patchset Overwrites %ORACLE_HOME%\network\admin\sqlnet.ora According to it, Patch 6810189…
Read Full RecipeAfter writing few Case studies and other related articles, I will be sharing my approach for Resolving ORA -4031 error. First we will see what ORA-4031 actually means. 04031, 00000,…
Read Full RecipeI had installed Oracle Database 11g on Solaris 10 few days back. I thought of documenting the steps for easy reference. Please find below steps for the same Installation Pre-Requisite…
Read Full RecipeFew days back, while trying to create a synonym over dblink I experienced following error: SQL> create synonym synonymn_name for dual@DBLINK9i; SP2-0042: unknown command "DBLINK9i" - rest of line ignored…
Read Full RecipeYesterday I was working on issue where our Monitoring system reported increased number of database connections. We were already aware of this issue and application team was asked to look…
Read Full Recipe