Trace a SQL session from another session using ORADEBUG

Posted on By Admin No Comments on Trace a SQL session from another session using ORADEBUG

Find the SPID from Oracle’s SID using below SQL. REM **** This is used to get SPID from SID.col username format a30col machine format a20col program format a40accept _sid prompt ‘Enter Oracle Session ID ->’select a.sid, b.pid, b.spid, a.username, a.program,a.machinefrom v$session a,V$process bwhere a.paddr = b.addrand   a.sid = &_sid/ Use ORADEBUG command as below. oradebug…

Read More “Trace a SQL session from another session using ORADEBUG” »

Oracle, SQL scripts

SQL Server Vs Oracle Architecture difference

Posted on By Admin No Comments on SQL Server Vs Oracle Architecture difference

Here’s an expanded and in-depth comparison of SQL Server vs Oracle architecture — organized into major categories with detailed breakdowns. ✅ SQL Server vs Oracle Architecture – In-Depth Comparison Category SQL Server Oracle Database Core Architecture Type Thread-based, single-process architecture. Process-based, multi-process architecture (each background task is a separate OS process). Platform Windows (originally), now…

Read More “SQL Server Vs Oracle Architecture difference” »

SQL Server

SQL Server: How to see historical transactions

Posted on By Admin No Comments on SQL Server: How to see historical transactions

You can determine if a SQL Server database is actively being used by any users, both currently and historically (to some extent). ✅ Part 1: Check Current Active Usage 🔹 1. Who Is Connected Right Now (to a DB)? 🔍 Shows who is currently active in a specific database, with login, host, and command info….

Read More “SQL Server: How to see historical transactions” »

SQL Server

SQL Server: How to see current transactions or requests

Posted on By Admin No Comments on SQL Server: How to see current transactions or requests

To check if there are any active transactions in SQL Server, you have several tools at your disposal depending on how deep you want to inspect. ✅ Option:1 See Transactions via sys.dm_tran_active_transactions Value Type 1 Read/write transaction 2 Read-only transaction 3 System transaction 4 Distributed transaction ✅ Option:2 See Transactions by Session (sp_who2 or sys.dm_exec_requests)…

Read More “SQL Server: How to see current transactions or requests” »

SQL Server

T-SQL Vs PL/SQL Syntax

Posted on 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 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

Oracle vs MYSQL Architecture differences (For DBAs)

Posted on 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 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 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