Tag: Database

Active Session History (ASH) is a time-based sample of session activity in an Oracle database. It is a powerful source of information on how time is spent in the database, however misconceptions about and misuse of ASH data are common. Properly using ASH to understand and diagnose database performance issues requires understanding both its architecture…

Active Session History (ASH) is a time-based sample of session activity in an Oracle database. It is a powerful source of information on how time is spent in the database, however misconceptions about and misuse of ASH data are common. Properly using ASH to understand and diagnose database performance issues requires understanding both its architecture…

Active Session History (ASH) is a time-based sample of session activity in an Oracle database. It is a powerful source of information on how time is spent in the database, however misconceptions about and misuse of ASH data are common. Properly using ASH to understand and diagnose database performance issues requires understanding both its architecture…

Active Session History (ASH) is a time-based sample of session activity in an Oracle database. It is a powerful source of information on how time is spent in the database, however misconceptions about and misuse of ASH data are common. Properly using ASH to understand and diagnose database performance issues requires understanding both its architecture…

Active Session History (ASH) is a time-based sample of session activity in an Oracle database. It is a powerful source of information on how time is spent in the database, however misconceptions about and misuse of ASH data are common. Properly using ASH to understand and diagnose database performance issues requires understanding both its architecture…

Active Session History (ASH) is a time-based sample of session activity in an Oracle database. It is a powerful source of information on how time is spent in the database, however misconceptions about and misuse of ASH data are common. Properly using ASH to understand and diagnose database performance issues requires understanding both its architecture…

How do you defuse screaming, angry, blame-toting clients?—Angry, accusatory letters from their big boss to your big boss? How do you solve a problem or resolve performance issues in a repeatable way? Defuse a literal shouting-match that started between opposing IT service delivery teams? How do you escape this situation you should avoid like the…

How do you defuse screaming, angry, blame-toting clients?—Angry, accusatory letters from their big boss to your big boss? How do you solve a problem or resolve performance issues in a repeatable way? Defuse a literal shouting-match that started between opposing IT service delivery teams? How do you escape this situation you should avoid like the…

How do you defuse screaming, angry, blame-toting clients?—Angry, accusatory letters from their big boss to your big boss? How do you solve a problem or resolve performance issues in a repeatable way? Defuse a literal shouting-match that started between opposing IT service delivery teams? How do you escape this situation you should avoid like the…

Having accurate optimizer statistics for your database is more important than ever. Handling larger volumes of data and benefitting from the ever-increasing number of choices in execution plans generated by the Oracle Optimizer require that the optimizer knows as much as possible about your data. The only reasonable way to gather the statistics is with…