Saturday, August 23, 2025

MoidIITDocID-649: How to collect stats in Oracle?

›
Few examples: exec dbms_stats.SET_GLOBAL_PREFS('AUTOSTATS_TARGET', 'AUTO'); exec dbms_stats.SET_DATABASE_PREFS('STALE_PE...
Saturday, August 2, 2025

MoidIITDocID-648: Data Guard in Pictures --Moid Muhammad

›
Click here for the document. Moid Muhammad 
Sunday, July 20, 2025

MoidIITDocID-647: Data Guard in Images

›
Click here for the document. Moid Muhammad
Saturday, February 1, 2025

MoidIITDocID-646: How to create 19c database using “create database” command? --Moid

›
Click here for the 19c document. Moid
Tuesday, November 12, 2024

Dynamic

›
select (select 'Space_GIVEN_to_DB' from dual) as Note, round(sum(d.bytes)/1024/1024/1024 + (sum(t.bytes)/1024/1024/1024),2) as Siz...

MoidIITDocID-640: Steps to get Oracle Certified (SQL Fundamentals, OCA / OCP)? --Moid Muhammad

›
As of 11/12/2024 Oracle Database SQLExam Number: 1Z0-071 Oracle Database Administration I Exam Number: 1Z0-082 Oracle Database Administratio...
Friday, August 23, 2024

MoidIITDocID-634: How to start GUI tools on Linux when you sudo to other user? --Moid Muhammad

›
Click here for the document. Moid Muhammad kewords: GUI, xclock, xming, dbca
Monday, August 5, 2024

MoidIITDocID-633: How to check the patch level of an oracle database? --Moid

›
Click here for the document.   Moid Muhammad
Sunday, July 7, 2024

MoidIITDocID-632: How to use tmux (instead of screen) in Linux? --Arshia Jabeen

›
tmux list-sessions tmux new-session -s MMpatching tmux attach-session -t  MMpatching Click here for the full document Thanks, Arshia Jabeen
Friday, December 15, 2023

MoidIITDocID-629: How To Get Table Growth History Information? --Moid Muhammad

›
Click here for the document. Moid table size segment size 
Wednesday, September 27, 2023

MoidIITDocID-628: How to upgrade 12c database to 19c using Autoupgrade? --Arshia Jabeen

›
Click here for the link. by Arshia Jabeen. Keywords: Moid oracle 19c autoupgrade rac data guard ASM

MoidIITDocID-627: How to upgrade 12c standalone database to 19c using DBUA? --Arshia Jabeen

›
Click here for the document. Arshia Jabeen Keywords: Moid oracle 19c upgrade Arshia  migration export import data pump tesla MyTravelsPro.co...