My notes on Oracle Database Administration -- Moid

Wednesday, November 19, 2025

MoidIITDocID-652: How to install 19c client on Windows 11? --Moid Muhammad

›
 Click here for the document. --Moid
Monday, October 13, 2025

MoidIITDocID-651: Check for resource limits between two times? --Moid Muhammad

›
SELECT * FROM dba_hist_resource_limit   WHERE snap_id IN  (    SELECT snap_id FROM dba_hist_snapshot   WHERE begin_interval_time BETWEEN   T...

MoidIITDocID-650: How to force a snapshot to get flused for AWR report? --Moid

›
EXEC DBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT(); set linesize 200 pages 200 col BEGIN_INTERVAL_TIME format a35 col END_INTERVAL_TIME  format...
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
›
Home
View web version
Powered by Blogger.