Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • proper cpu stats Linux/Unix
  • Drop all SPM baselines for SQL handle Oracle
  • Implementing Listener Security Oracle
  • Looping for remote servers and find its database from oratab file. Linux/Unix
  • mutex in Oracle 10.2.0.2 or Oracle 10g Oracle
  • alter database backup controlfile to trace Oracle
  • Finding Oracle Patches with opatch Oracle
  • Process Map for CPU and Memory for OS processes Linux/Unix
  • move_arch_files.ksh Linux/Unix
  • ORA-00064: object is too large to allocate on this O/S during startup Oracle
  • sbind.sql Find Bind variable from sql_id sqlid Oracle
  • Getting started with notebook Python/PySpark
  • scripts to take listener.log backup Linux/Unix
  • Changing the Global Database Name Oracle
  • This is im telling Kishore Oracle

Category: MYSQL

Oracle vs MYSQL Architecture differences (For DBAs)

Posted on 24-Jul-2025 By Admin No Comments on Oracle vs MYSQL Architecture differences (For DBAs)

Here’s a detailed comparison table between Oracle and MySQL architectures, highlighting components, memory structures, process models, transaction behavior, and other key aspects — tailored for an Oracle DBA transitioning to MySQL. 🏗️ Oracle vs MySQL Architecture (Detailed Comparison Table) Component / Area Oracle RDBMS MySQL (with InnoDB) Architecture Type Multi-process architecture (background processes) Single-process, multi-threaded…

Read More “Oracle vs MYSQL Architecture differences (For DBAs)” »

MYSQL

V$INSTANCE of Oracle in MYSQL

Posted on 24-Jul-202524-Jul-2025 By Admin No Comments on V$INSTANCE of Oracle in MYSQL

The Oracle view **V$INSTANCE** provides information about the running Oracle database instance — such as instance name, host, version, status, startup time, etc. ✅ MySQL Equivalent of V$INSTANCE There is no single view in MySQL that maps 1:1 to V$INSTANCE, but you can gather the equivalent details using the following queries: Oracle V$INSTANCE Column MySQL…

Read More “V$INSTANCE of Oracle in MYSQL” »

MYSQL

Day to day MYSQL DBA operations (Compared with Oracle DBA)

Posted on 24-Jul-202524-Jul-2025 By Admin No Comments on Day to day MYSQL DBA operations (Compared with Oracle DBA)

Here is a mapping of commonly used Oracle dynamic performance views (V$ views) and data dictionary views (DBA_*) to their closest equivalents in MySQL. These are especially useful for Oracle DBAs learning how to inspect system-level information in MySQL. 🔄 Oracle V$ and DBA_ Views vs MySQL INFORMATION_SCHEMA / Performance Schema Oracle View MySQL Equivalent…

Read More “Day to day MYSQL DBA operations (Compared with Oracle DBA)” »

MYSQL

MYSQL and Oracle Comparison for Oracle DBA

Posted on 24-Jul-202524-Jul-2025 By Admin No Comments on MYSQL and Oracle Comparison for Oracle DBA

Here’s a practical comparison of MySQL for Oracle DBAs, focusing on key concepts, terminology, architecture, and daily operations so that you can quickly map your Oracle knowledge to MySQL. I’ll structure it in a table format followed by important notes: 🔁 Oracle to MySQL Mapping Table (Essentials for Oracle DBAs) Concept / Task Oracle MySQL…

Read More “MYSQL and Oracle Comparison for Oracle DBA” »

MYSQL

MYSQL for Oracle DBA

Posted on 24-Jul-202524-Jul-2025 By Admin No Comments on MYSQL for Oracle DBA

Excellent! Since you’re already a seasoned Oracle DBA on Linux, transitioning to MySQL will be straightforward — but you’ll need to shift focus to MySQL’s different architecture, tooling, and storage engine model. 🧠 Training Plan: MySQL DBA for Oracle DBAs (Linux-Based) We’ll cover the following areas step-by-step. Each topic will include theory, practical commands, and…

Read More “MYSQL for Oracle DBA” »

MYSQL

Categories

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

Recent Posts

  • Tutornet.US — Source of excellent learning14-Oct-2026
  • OCI Infrastructure Patching14-Oct-2026
  • Free API credits for AI models14-Oct-2026
  • AMC1020-Sep-2026
  • 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.sh23-Apr-2026
  • Running PDB on single node in RAC09-Apr-2026

Archives

  • 2026
  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • CPU speed on solaris Linux/Unix
  • T-SQL Vs PL/SQL Syntax SQL Server
  • How to sort list of files on basis of their sizes. Linux/Unix
  • Important Solaris Commands Linux/Unix
  • Rename Tablespace Oracle
  • Oracle Metalink useful notes Oracle
  • v$event_name Oracle
  • Process Map for CPU and Memory for OS processes Linux/Unix

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme