Hello, I’m Arvind Toorpu, an Oracle Certified Professional (OCP) working as a Database Architect with over 13 years of diverse experience managing, designing, and administering databases. My expertise spans Oracle, SQL Server, MySQL, and PostgreSQL, among others, in both production and non-production environments. As a passionate database professional, I specialize in performance tuning, database migrations, high availability architecture, and implementing disaster recovery solutions.
Mentoring, Speaking opportunities, Co-Authoring Books, Peer Reviews, Journal Reviews, blogging.
Sep 10, 2024 · 3 min read · Summary: Idle sessions connected to an Oracle Database consume various resources, including memory (PGA, UGA), database locks, SGA, session state, network, and system resources. This can degrade performance and reduce available connections. Mitigati...
Join discussionSep 9, 2024 · 3 min read · Yes, even an idle session connected to an Oracle Database can still consume and hold onto certain resources. You can ensure that database connections automatically get snipped and cleared by following the process below. To implement session sniping i...
Join discussionSep 4, 2024 · 7 min read · INTRODUCTION : PostgreSQL is a powerful open-source relational database management system with robust features for handling large datasets and supporting complex queries. While there are many ways you can install the PostgreSQL database on your lapto...
Join discussion