Oracle DBA Silver Bullets – Performance Queries

Just thought to share few queries from my repository. It may be useful for all new DBAs. Of course these are quite old ones and you can do most of them through Enterprise Manager, still we DBAs always like command line 🙂 Show sessions that are blocking each other : select ‘SID ‘ || l1.sid […]

Read the rest of this entry »