Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • How to collect CPU usage on Linux using Shell script Linux/Unix
  • switchover for primary database Oracle
  • Passing from Unix to PLSQL using bind variables Linux/Unix
  • Rollback force for distributed transactions Oracle
  • tblwopk.sql tablewopk.sql Oracle
  • New OFA for 11g Oracle
  • Sending SQLPLUS output in HTML format Oracle
  • catall.sh Linux/Unix
  • sid_wise_sql.sql Further explaination Oracle
  • ORACLE_SID in sqlplus Oracle
  • Renaming the column name Oracle
  • Building Our Own Namespaces with “Create Context” Oracle
  • good note for shared pool tunnig Oracle
  • Paste command syntax Linux/Unix
  • scripts to take listener.log backup Linux/Unix

Author: Admin

SAT Mathematics 10 questions and answer at the end.

Posted on 30-Apr-2026 By Admin

10 SAT Mathematics Practice Questions to Sharpen Your Skills Preparing for the SAT Mathematics section can feel overwhelming, but targeted practice is one of the most effective ways to build confidence and improve your score. Whether you’re reviewing algebra, problem-solving, or data analysis, working through realistic questions helps reinforce key concepts and familiarize you with…

Read More “SAT Mathematics 10 questions and answer at the end.” »

Uncategorized

top 10 AI news today

Posted on 30-Apr-2026 By Admin

Top 10 AI News Today: Oracle’s Latest Innovations and Industry Shifts Artificial intelligence continues to reshape industries at an unprecedented pace, with major players like Oracle leading the charge in enterprise AI solutions. From groundbreaking partnerships to cutting-edge product launches, today’s AI news highlights how businesses are leveraging AI to drive efficiency, innovation, and competitive…

Read More “top 10 AI news today” »

Uncategorized

Running PDB on single node in RAC

Posted on 09-Apr-2026 By Admin

Configuring a PDB to Listen on a Specific RAC Node in Oracle Database In Oracle Real Application Clusters (RAC) environments, you may need to restrict a Pluggable Database (PDB) to run on specific nodes. Here’s how to configure PDB MYPDB to listen only on node1: Step-by-Step Configuration 1. Configure the PDB State on Node 1…

Read More “Running PDB on single node in RAC” »

Oracle, RAC, SQL scripts

find_arc.sql

Posted on 09-Apr-2026 By Admin

Monitoring Oracle Archive Logs: A Quick Guide As an Oracle DBA, keeping a close eye on your archived redo logs is crucial for maintaining database health and ensuring smooth recovery operations. Today, I’ll share a simple yet powerful script that helps you monitor your archive logs effectively. The Power of v$archived_log The v$archived_log view is…

Read More “find_arc.sql” »

Oracle, SQL scripts

pvm_pre_change.sql

Posted on 08-Apr-2026 By Admin

Automating Oracle Invalid Object Recompilation: A Practical Script As Oracle DBAs, we frequently encounter situations where database objects become invalid after patches, upgrades, or schema changes. Manually recompiling these objects can be time-consuming, especially in large databases. Today I’ll share a practical script that automates the generation of recompilation commands for all invalid objects in…

Read More “pvm_pre_change.sql” »

Oracle, SQL scripts

find_encr_wallet.sql

Posted on 08-Apr-2026 By Admin

Managing Oracle Database Wallets: A Quick Guide Oracle Database provides robust security features to protect sensitive data, and one of the key components in this security framework is the Oracle Wallet. The wallet is a secure container used to store encryption keys, credentials, and certificates, ensuring that sensitive information is protected from unauthorized access. In…

Read More “find_encr_wallet.sql” »

Uncategorized

find_pdbs.sql

Posted on 08-Apr-2026 By Admin

Understanding Oracle Multitenant: Querying PDB Status Across Instances As an Oracle DBA working with Container Databases (CDBs), one of the most common tasks is checking the status of your Pluggable Databases (PDBs). Today I’ll share a useful script that provides a comprehensive view of all PDBs across all instances in your Oracle RAC environment. The…

Read More “find_pdbs.sql” »

Uncategorized

Creating a Container Database using dbaascli

Posted on 08-Apr-2026 By Admin

Creating a Container Database (CDB) in Oracle Database Cloud Service Using dbaascli As a database administrator working with Oracle Database Cloud Service (DBCS), you have powerful command-line tools at your disposal. One of these is dbaascli, which allows you to perform various database operations directly from the server. Today, I’ll walk you through creating a…

Read More “Creating a Container Database using dbaascli” »

Uncategorized

Categories

  • Ansible (0)
  • AWS (2)
  • Azure (1)
  • Django (0)
  • GIT (1)
  • Linux/Unix (149)
  • MYSQL (5)
  • Oracle (403)
  • PHP/MYSQL/Wordpress (10)
  • POSTGRESQL (1)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (18)
  • rman-dataguard (26)
  • shell (150)
  • SQL scripts (350)
  • SQL Server (6)
  • Uncategorized (5)
  • Videos (0)

Recent Posts

  • Key Management in Oracle: The Core Issue: Missing Master Key12-May-2026
  • SAT Mathematics 10 questions and answer at the end.30-Apr-2026
  • top 10 AI news today30-Apr-2026
  • runon_allpdbs_show_conname.sh23-Apr-2026
  • runon_allcdbs_find_pdbs.sql23-Apr-2026
  • Running PDB on single node in RAC09-Apr-2026
  • find_arc.sql09-Apr-2026
  • pvm_pre_change.sql08-Apr-2026
  • find_encr_wallet.sql08-Apr-2026
  • find_pdbs.sql08-Apr-2026

Archives

  • 2026
  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • To see mem usage and CPU usage system wide. Linux/Unix
  • Oracle vs MYSQL Architecture differences (For DBAs) MYSQL
  • Exadata Basics Oracle
  • prepfiles.sh for step by step generating pending statistics files Oracle
  • 339939.1 Running Cluster Verification Utility to Diagnose Install Problems Oracle
  • Good Site for Oracle Internals Oracle
  • PLSQL Table Syntax 1 Oracle
  • avail.sh ( find filesystem spae usage) Linux/Unix

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme