Skip to content
Datahubinsight.com

Datahubinsight.com

  • PostgreSQL
    • PostgreSQLDBA
  • Oracle
    • Performance Tuning

Suresh Parmar

PostgreSQL vs. MySQL: A Comprehensive Comparison

by Suresh Parmar
PostgreSQL vs Mysql

In the world of relational databases, two prominent players have emerged as leading choices for developers and businesses alike – PostgreSQL and MySQL. These database management systems offer powerful features …

Read more

Troubleshooting and Resolving Latch: Cache Buffers Chains

by Suresh Parmar

I received  complaint from one of my client that their application is not able to connect to database and it is hanging!!! On checking the database found that the maximum session …

Read more

Troubleshooting ORA-12535: TNS: operation timed out or kponepms: encountered ora-12535 for location net8 or tns 12535

by Suresh Parmar

Troubleshooting ORA-12535: TNS: operation timed out or kponepms: encountered ora-12535 for location net8 or tns 12535 I received a complaint from one of my clients that they are not able …

Read more

Best practice for gathering oracle statisitcs

by Suresh Parmar

1. Purpose This script is an automated way to deal with stale statistics operations that are required to be done as part DBA activity or time of manual upgrade.Operations of …

Read more

Newer posts
← Previous Page1 Page2

Trending Post

  • Shared poolOptimize Oracle Shared Pool Performance: Top 10 Best Practices
  • Creating Database in PostgreSQLEffortless Database Mastery: Creating Database in PostgreSQL in 1 Step
  • Empowering Strategies: 3 Steps to Resolve Oracle EMON Process Slowness and Eliminate Wait for EMON to Process NTFNs
© 2025 Datahubinsight.com All rights reserved