MoidIITDocID-614: Why is Oracle DataPump export process slow? --Moid

 Click here for the document.

Moid

MoidIITDocID-613: How to check size of all non oracle_maintained tables and index in oracle database? --Moid

Click here for the document

Moid

MoidIITDocID-612: How to run SQL script in loop? (loop.sql) --Moid

Click here for the document.

Moid 

Keywords: 

loop.sql

Oracle Sqlplus calling sql script repeatedly in a loop

MoidIITDocID-611: How to build two node RAC cluster on Oracle Virtual Box? --Nasreen Fatima

Click here for the link

Nasreen Fatima

Keywords: Build RAC Cluster, 19c

MoidIITDocID-610: How to apply 19c patches on GI and RDBMS home (April 2022)? --Arshia Jabeen

 Click here for the document.

Moid

MoidIITDocID-606: Script to check tablespace usage - tbs0.sql

Click here for tbs0.sql

Moid Muhammad

MoidIITDocID-605: Script to purge Archivelogs in Linux

Click here for the link

Moid Muhammad

MoidIITDocID-604: Script to monitor mount points on Linux --Moid

 

See monitor_mountpoints.sh

Moid Muhammad

MoidIITDocID-601: Database Migration using Transportable tablespace (AIX to Linux) - Database Migration Steps (rough notes) --Moid

Click here for the document. 

Note that this is the first draft of the notes. I will be making it clean as time permits. You can see Oracle Doc ID 2471245.1 for more details. 

MoidIITDocID-600: How to install Oracle SQL Developer? --Moid

Click here for the document.

Moid

MoidIITDocID-599: Query to get count of in-memory active session history --Moid

 Click here for the document.

Moid

MoidIITDocID-596: How to send email from Linux server? --Moid

Example:

echo "My message" | mail -s subject contactmoid@gmail.com

Click here for the document.

Moid

MoidIITDocID-595: How to redirect nohup to a filename? --Moid

Example:

nohup rman @duplicate_db.rman > duplicate_db_`date +%m-%d-%y_%H%M%S`.log &

tail -f `ls -ltrh | awk '{print $9}' |tail -1`

Click here for the document.

Moid

MoidIITDocID-591: How to trim Oracle Datafile's name in Linux? --Moid

Click here for the document. 

Moid 

keywords:

datafile, substr, trim, separate, file name only