BE SHARING

Oracle

Oracle is hanging? Don’t forget hanganalyze and systemstate!

07.02.2014 by Oracle Team

By Franck Pachot . sqlplus / as sysdba oradebug setmypid oradebug unlimit oradebug hanganalyze 3 oradebug dump ashdumpseconds 30 oradebug dump systemstate 266 oradebug tracefile_name Your Oracle database – production DB, of course – is hanging. All users are blocked.

Database Administration & Monitoring

Archivelog deletion policy for Standby Database in Oracle Data Guard

27.01.2014 by Oracle Team

By Franck Pachot . Do you use ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY for your Oracle databases in Data Guard? Maybe you also use the Fast Recovery Area as archive log destination. That’s good practice! But did(…)

Application integration & Middleware

Sockets, Cores, Virtual CPU, Logical CPU, Hyper-Threading: What is a CPU nowadays?

13.01.2014 by Oracle Team

By Franck Pachot . Because people know that I really like Oracle AWR reports, they send them to me from time to time. Here is one I have received for Christmas with the following question: ‘Since our AIX server(…)