Moid Muhammad
My notes on Oracle Database Administration -- Moid
Saturday, August 2, 2025
Sunday, July 20, 2025
Saturday, February 1, 2025
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 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
Friday, August 23, 2024
Monday, August 5, 2024
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 |
Friday, December 15, 2023
Wednesday, September 27, 2023
MoidIITDocID-628: How to upgrade 12c database to 19c using Autoupgrade? --Arshia Jabeen
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
Arshia Jabeen
Keywords: Moid oracle 19c upgrade Arshia
migration export import data pump tesla MyTravelsPro.com MoidIIT.com