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….
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)” »
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…
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)” »
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…
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…
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);
declaremyplan pls_integer;beginmyplan:=DBMS_SPM.drop_sql_plan_baseline (sql_handle => ‘&sql_handle’);end;/
accept v_sqlid prompt ‘Enter sqlid ‘accept v_phv prompt ‘Enter PHV ‘set serveroutput on DECLAREv_first_snapid number;v_last_snapid number;v_sqlset varchar2(1000);loaded_plans number; BEGINselect max(ss.snap_id)-3, max(ss.snap_id)into v_first_snapid, v_last_snapidfrom DBA_HIST_SQLSTAT S, DBA_HIST_SNAPSHOT SSwhere sql_id = ‘&v_sqlid’and plan_hash_value = ‘&v_phv’and ss.snap_id = S.snap_idand ss.instance_number = S.instance_numberand executions_delta > 0 ; loaded_plans := dbms_spm.load_plans_from_awr( begin_snap=>v_first_snapid,end_snap=>v_last_snapid,basic_filter=>q’# sql_id=’&v_sqlid’ and plan_hash_value=’&v_phv’ #’ ); dbms_output.put_line(‘loaded-plans= ‘ ||…
set serveroutput onvar res numberexec :res :=DBMS_SPM.DROP_SQL_PLAN_BASELINE (‘&original_sql_handle’,’&original_plan_name’);exec dbms_output.put_line(‘Number of plans dropped: ‘ || :res);
