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);
Moid
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
