ORACLE: Required permissions for v$mystat

Long time: no post. Busy. Working. Travelling. Excuses. Excuses.

Too many net resources point you to GRANT SELECT ANY DICTIONARY TO {user/role}' but I like a more granulated approach.

If you want to give just enough permissions for a user to v$mystat;

C:\> "sqlplus sys/passwd@tnsname as sysdba"

SQL> GRANT SELECT ON v_$mystat TO {user/role};


[Listening to: Marilyn Manson - Apple of Sodom]

Finding memory leaks without buying a memory profiler

Another winner from Eran Sandler: Finding memory leaks without buying a memory profiler.

[Listening to: Guns N' Roses - Rocket Queen]

Advanced .NET Debugging with PerfMon

Fellow Blogspotter Eran Sandler gives a nice overview on some PerfMon performance counters, what they mean and how to use them to detect some common issues such as leaks, fragmentation and lousy (my word not his) allocation patterns. It's nice having this all in one spot.

[Listening to: Ted Nugent - Free for all]