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 
 TO_DATE('2025-10-13 07:45:00', 'YYYY-MM-DD HH24:MI:SS') 
 AND 
TO_DATE('2025-10-13 08:15:00', 'YYYY-MM-DD HH24:MI:SS')
);

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 a35

select snap_id instance_number,  BEGIN_INTERVAL_TIME, END_INTERVAL_TIME
from dba_hist_snapshot
order by instance_number, BEGIN_INTERVAL_TIME;

Click here for the document.

Moid Muhammad

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_PERCENT', '15');

exec dbms_stats.GATHER_DATABASE_STATS(degree => 4, cascade => TRUE);

exec dbms_stats.GATHER_SCHEMA_STATS(ownname => 'SCOTT', degree => 4, cascade => TRUE);

exec dbms_stats.GATHER_TABLE_STATS(ownname => 'SCOTT', tabname => 'EMP', degree => 4, cascade => TRUE);

Click here for the link.

Moid 

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

Click here for the document.

Moid Muhammad 

MoidIITDocID-647: Data Guard in Images

Click here for the document.

Moid Muhammad

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

Click here for the 19c document.

Moid

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 Size_in_GB  

from

v$datafile d,

v$tempfile t

where

d.file#=t.file#(+)

group by 1

union

select

(select 'Space_USED_by_DB' from dual) as Note,

round(sum(size_in_bytes)/1024/1024/1024,2) Size_in_GB

from

(select

     tablespace_name,

     sum(bytes) size_in_bytes

  from

     dba_segments

  group by

     tablespace_name)

group by 1

order by 2 desc;

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 Administration II Exam Number: 1Z0-083

Certification fee for each of the three (Oracle SQL Fundamentals, OCA and OCP) is $245. Only 1 attempt for exam. 

Format: Multiple Choice

Duration: 120 minutes

Number of Questions: 63 or 72

Passing Score: 63%

shop.oracle.com --> sign-in --> Browse Products --> Oracle University --> Exam Subscriptions --> Oracle Technology Exam Subscription --> Add to cart --> $245

Good site to practice: https://www.examtopics.com/exams/oracle/ and then select the following:

1z0-071: Oracle Datbase 12c SQL 

1z0-082: Oracle Database Administration I 

1z0-083: Oracle Database Administration II

Document is here.

Moid Muhammad

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

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

Click here for the document. 

Moid Muhammad

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

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

Click here for the document.

Moid

table size segment size