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…
This script will be useful for tracking progress of GBS copied to Target system. Need to execute it on Target system.
This will provide prompt with session details.
This script, prepfiles.sh, is a powerful utility for Oracle Database Administrators designed to automate the generation of a comprehensive SQL toolkit for managing and testing database statistics. By reading a list of tables from mtx_tablelist.lst, the script creates a sequenced set of SQL files that handle the entire lifecycle of Pending Statistics. This allows DBAs to gather and validate new…
Read More “prepfiles.sh for step by step generating pending statistics files” »
This PL/SQL block identifies recently active SQL queries from a specific application server and provides details on their performance and execution plans. Here is a breakdown of what the script does:
🎯 Table of Contents 🤔 What is Git? Git is a version control system – think of it as a time machine for your code! Real-World Analogy Imagine you’re writing a book: Why Use Git? âś… Track Changes: See what changed and whenâś… Collaborate: Multiple people can work on the same projectâś… Backup: Your code is saved on GitHub (cloud)âś… Undo Mistakes:…
In PostgreSQL on Linux, it is crucial to understand that the OS user and the database user (often both named postgres) are two completely separate entities with separate credentials. Here is the breakdown of how they interact: 1. Are the passwords the same? No. * OS User (postgres): This is a Linux system account created…
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” »
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…
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” »
