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;
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
Moid Muhammad
by Arshia Jabeen.
Keywords: Moid oracle 19c autoupgrade rac data guard ASM
Arshia Jabeen
Keywords: Moid oracle 19c upgrade Arshia
migration export import data pump tesla MyTravelsPro.com MoidIIT.com
Moid Muhammad
Keywords: .sql run SQL Script multiple databases servers parameter change across
Moid
Keywords: Oracle Listener on 1733 non-default port Register multiple ports on different listeners.
Moid
Keywords: Oracle Listener 1733 non-default port multiple ports on different listeners.
