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 

MoidIITDocID-628: How to upgrade 12c database to 19c using Autoupgrade? --Arshia Jabeen

Click here for the link.

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

Click here for the document.

Arshia Jabeen

Keywords: Moid oracle 19c upgrade Arshia 
migration export import data pump tesla MyTravelsPro.com MoidIIT.com

MoidIITDocID-625: How to load Scott Schema in Oracle database? --Arshia Jabeen

Click here for the document,

Thanks,
Arshia Jabeen.

Keywords: create scott schema, run script

MoidIITDocID-624: How to start xclock (GUI tools) after switching user to oracle in Linux? --Moid Muhammad

Click here for the document.

Moid

MoidIITDocID-623: Shell script that loop through tnsnames.ora to execute SQL script in multiple databases --Moid Muhammad

Click here for the document. 

Moid Muhammad

Keywords: .sql run SQL Script multiple databases servers parameter change across 

MoidIITDocID-622: How to schedule sql script on Linux DB server? --Moid Muhammad

Click here for the link.

Moid Muhammad

Keywords:
crontab execute schedule oracle sqlplus