Troubleshooting

Oracle 21c: Attention Log – Useful or Superflous?

Attention.log is a feature, which was introduced in Oracle Database 21c, designed to capture high-level summaries of significant database events and activities. It differs from the alert.log in following points: High-Level Summaries: The attention.log focuses on summarizing critical and significant(…)

How I killed my M-Files instance…and brought it back to life!

I work with M-Files since 1 year now, and to be honest the solution is pretty robust.I had really few issues at “Server level”, but sooner and later while playing sorcerer’s apprentice you finish by breaking something. The inevitable happened,(…)

How to delete a resource with the error: failed calling webhook

The original mistake In preparation of the GitLab essentials workshop, I’m using helm to deploy it. After a few tests, I wanted to clean up my cluster, and accidentally deleted the namespace before doing helm uninstall.

ODA and KVM: Debugging of DBsystem creation failure

Debugging errors when working with ODA is not always the easiest thing do... :-P It may become a bit tricky and not a straightforward process. In this blog I wanted to show you and example we faced with the debugging(…)

How to view and change SQL Server Agent properties with T-SQL queries

Few days ago, after a reboot, we had this warning on the Agent Error Logs on many servers: Warning [396] An idle CPU condition has not been defined – OnIdle job schedules will have no effect(…)

Upgrade to Oracle 19c – performance issue

In this blog I want to introduce you to a workaround for a performance issue which randomly appeared during the upgrades of several Oracle 12c databases to 19c I performed for a financial services provider. During the upgrades we ran(…)

Troubleshooting performance on Autonomous Database

By Franck Pachot . On my Oracle Cloud Free Tier Autonomous Transaction Processing service, a database that can be used for free with no time limit, I have seen this strange activity. As I’m running nothing(…)

SQL Server Tips: Path of the default trace file is null

In addition of my precedent blog about this subject “SQL Server Tips: Default trace enabled but no file is active…”, I add a new case where the default path of the trace file was empty. The(…)

SQL Server Tips: Orphan database user but not so orphan…

Beginning of this year, it is good to clean up orphan users in SQL Server databases. Even if this practice must be done regularly throughout the year of course. 😉 During my cleaning day, a new case appears that(…)

What to do in case all active Documentum jobs are no more running ?

The application support informed me that their jobs are not running anymore. When I started the analysis, I found that all activated jobs did not start for a few weeks.