Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • Search and replace pattern Linux/Unix
  • MYSQL for Oracle DBA MYSQL
  • sid_wise_cursor.sql find open cursor basis on username or SID Oracle
  • Adding or Dropping Online Redo Log Files When Physical Standby in place Oracle
  • shutdown linux Linux/Unix
  • find_pk.sql /* Find Primary Key */ Oracle
  • Good notes for shared pool Oracle
  • Backup and Recovery Scenarios Oracle
  • sess_server.sql Oracle
  • checking connectivity between two servers Linux/Unix
  • MYSQL and Oracle Comparison for Oracle DBA MYSQL
  • Implementing Listener Security Oracle
  • Multiple listeners Oracle
  • How to check current redo log progress redo_progress.sql Oracle
  • sbind.sql Find Bind variable from sql_id sqlid Oracle

T-SQL Vs PL/SQL Syntax

Posted on 25-Jul-202525-Jul-2025 By Admin No Comments on T-SQL Vs PL/SQL Syntax

Below is a side-by-side comparison of Oracle PL/SQL and SQL Server T-SQL for someone coming from a PL/SQL background. This will help you quickly understand the syntax and behavior differences. 🔄 PL/SQL vs T-SQL Syntax Comparison Concept / Operation Oracle PL/SQL Syntax SQL Server T-SQL Syntax Anonymous Block BEGIN … END; BEGIN … END (no…

Read More “T-SQL Vs PL/SQL Syntax” »

SQL Server

Check SQL Server edition

Posted on 25-Jul-202525-Jul-2025 By Admin No Comments on Check SQL Server edition

To check whether you are using SQL Server Standard, Enterprise, or another edition, you can use one of the following methods: 1. Using SQL Query (Recommended) Run this SQL query in SQL Server Management Studio (SSMS): Example Output: 2. Using SQL Server Management Studio (SSMS) 3. Using Command Prompt Run this command in Command Prompt…

Read More “Check SQL Server edition” »

SQL Server

Checking SQL Server Version

Posted on 25-Jul-202525-Jul-2025 By Admin No Comments on Checking SQL Server Version

To check which SQL Server version and edition you are running, you can use the following methods: 1. Using SQL Query (Most Reliable) Run the following SQL query in SQL Server Management Studio (SSMS) or any query tool: This will return a string containing the SQL Server version, edition, and service pack (if any). 2….

Read More “Checking SQL Server Version” »

SQL Server

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

load SPM baseline from cursor cache

Posted on 05-Jun-2025 By Admin No Comments on load SPM baseline from cursor cache

set serveroutput onaccept v_sqlid prompt ‘SQLID:’accept v_phv prompt ‘PHV:’ var pvm numberbegin:pvm := dbms_spm.load_plans_from_cursor_cache(sql_id=>’&v_sqlid’, plan_hash_value=>&v_phv, fixed =>’NO’, enabled=>’YES’);end;/ EXEC dbms_output.put_line(‘Number of plans loaded: ‘ || :pvm);

Oracle, SQL scripts

Drop all SPM baselines for SQL handle

Posted on 05-Jun-202505-Jun-2025 By Admin No Comments on Drop all SPM baselines for SQL handle

declaremyplan pls_integer;beginmyplan:=DBMS_SPM.drop_sql_plan_baseline (sql_handle => ‘&sql_handle’);end;/

Oracle, SQL scripts

Posts pagination

Previous 1 2 3 … 58 Next

Categories

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

Recent Posts

  • track_autoupgrade_copy_progress.sql01-Apr-2026
  • refre.sql for multitenant01-Apr-2026
  • prepfiles.sh for step by step generating pending statistics files10-Mar-2026
  • tracksqltime.sql05-Mar-2026
  • Complete Git Tutorial for Beginners25-Dec-2025
  • Postgres DB user and OS user.25-Dec-2025
  • Trace a SQL session from another session using ORADEBUG30-Sep-2025
  • SQL Server Vs Oracle Architecture difference25-Jul-2025
  • SQL Server: How to see historical transactions25-Jul-2025
  • SQL Server: How to see current transactions or requests25-Jul-2025

Archives

  • 2026
  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • remove archfiles only when it is applied to DR rm_archfiles.sh Linux/Unix
  • Changing Instance Name ( No DB_NAME) Oracle
  • Unix command for system configuration Linux/Unix
  • OPENING A STANDBY DATABASE IN READ-ONLY MODE Oracle
  • rm_backup_arch_file.ksh Linux/Unix
  • Giving Grant on v$DATABASE Oracle
  • Oracle 10g Wait Model Oracle
  • online_ts_bkup.sql Oracle

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme