Please turn JavaScript on
Oracle-dba-help icon

Oracle-dba-help

Follow Oracle-dba-help's news and updates in a matter of seconds! We will deliver any update via email, phone or you can read them from here on the site on your own news page.

You can even combine different feeds with the feed for Oracle-dba-help.

Subscribing and unsubscribing is fast, easy and risk free.

The whole service is free of cost.

Oracle-dba-help: Learn DBA : A Life Long Learning Experience

Is this your feed? Claim it!

Publisher:  Unclaimed!
Message frequency:  0.19 / day

Message History

An update-heavy PostgreSQL table can remain available while quietly becoming more expensive to operate. Transactions continue to commit, application response times initially look acceptable, and no major lock queue is visible. Meanwhile, the table grows, index scans perform more heap fetches, autovacuum runs repeatedly, and storage consumption refuses to settle.

Read full story

  When commit response time suddenly becomes poor, seeing log file sync near the top of an AWR report naturally sends a DBA toward redo I/O, ASM, and the underlying storage path.

That is the right place to start, but not always the right place to stop.

A foreground session waiting on log file ...


Read full story
A database maintenance window had just ended. The instance was open, the listener process was running, and TNSPING returned successfully. Yet the application connection pool continued to report ORA-12514. The first suggestion on the incident bridge was predictable: restart the listener. That would have changed the system before anyone had established what was actually wrong. ...

Read full story

A production database alert arrives at 2:00 a.m. The monitoring platform detects increased commit latency, correlates it with storage response time and suggests several corrective actions. That is useful automation. The difficult part begins when someone must decide whether to wait, change the workload, fail over the database or accept the risk of an eme...


Read full story