RMAN: Query to find the last RMAN backup’s log? --Moid

Click here for the document.

How to disable oracle password verification in default profile? --Moid

Click here for the details.

Moid

How to delete duplicate rows from Oracle Table? --Moid

Click here for the document.

Moid

MIITDocID-917: How to find the largest / biggest schema (size wise) in Oracle database? --Moid

Click here for the document.

Moid

How to export (using Data Pump) a schema using parfile? --Moid

Click here for the document.

Moid

How to kill all Oracle foreground connections (without any background processes)?

Click here for document.

Moid Muhammad

MoidIITDocID-550: My notes on SCAN listener --Moid

Click here for the document.

Moid

MIITDocID-886: How to copy / extract a user's Roles and permissions? --Moid

Click here for the link

Moid Muhammad

RMAN: How to automatically purge archivelog using crontab? --Moid

Click here for the link

Moid

How to start Server side GUI (dbca, netca etc) from your laptop using XMING? --Moid

Click here for the document.

Moid

MIITDocID-898: How to expand / Resize Linux Mount Point (Expanding /u01 for oracle) in VMWare? --Moid

Click here for the document.

Moid

MIITDocID-892: How to create 11g or 12c Oracle database on ASM using OMF? --Moid

Click here for the document.

Moid

How to deinstall (uninstall) 12c database home from Windows? --Moid

Click here for the instructions.

Moid

How to use XShell from RDP Servers to start GUI like xclock, dbca, netca etc? --Moid

Click here for details.

Moid

How to run SQL script from Windows Command Prompt? --Moid

Click here for the document.

Moid

MoidIITDocID-504: How to rename or move datafiles (ALL Datafiles) to a new directory? --Moid

Click here for the document.

Moid

How to uninstall Oracle 11g R2 Client from Windows 7? --Moid

Click here for the document.

Moid

Download Oracle 12c R2 Client for 32 or 64-bit Windows --Moid

1. Go to oracle download page
2. Click on "Accept License Agreement"
3. And then start browsing as per your need. Few links to download Oracle client are as follows:

• Click here for 64-bit 12c Client - winx64_12c_client.zip
• Click here for 32-bit 12c Client - winnt_12c_client32.zip

Click here for step-by-step Oracle 12c R1 Client Installation on Windows 8.


--Moid

Constraints: How to disable foreign keys? --Moid

Click here for the document?

Moid

MIITDocID-965: How to purge (or zip) large oracle alert log file? --Moid

Click here for the document

Moid

My notes on Oracle Indexes (Indices) --Moid

Click here for the document.

Moid

MIITDocID-865: Security: How to create read only user on entire oracle database (except default database users)? --Moid

Click here for the document.

Moid

MIITDocID-863: How to delete / purge oracle log and trace files older than 7 days? --Moid

Click here for the document.

Moid

MIITDocID-858: How to name, start, stop, kill an export job using Oracle Data Pump? --Moid

Click here for the document.

Moid

How to enable Text Search in Oracle 11g R2? --Moid

Click here for the details.

Moid

MIITDocID-943: How to build Oracle 12c R2 standby database using Data Guard? --Moid Muhammad

Click here for 12c document.

Click here for 19c document --by Safi Naaz

Moid

MIITDocID-910: How to build, configure, install 12c ASM Database Server on CentOS 7.2 --Moid

Click here for the document (Version 1.0 from 2019)

Click here for the document (Version 2.0 from 2023)

Moid

MIITDocID-930: How to find top running SQLs by elapsed time from Active Sessions? --Moid

Click here for the document.

Moid

MIITDocID-932: What are the top wait events between two times? --Moid

Click here for the document.

Moid

MIITDocID-933: How to find top 10 current SQLs by "elapsed time" and check their explain plan? --Moid

Click here for the document.

Moid

MIITDocID-934: How to identify long running sessions? --Moid

Click here for the document.

Moid

My notes on Oracle Import - Examples --Moid

Click here for the document.

Moid

MIITDocID-952: My notes on Oracle Export - Examples --Moid

Click here for the document.

Moid

How to check underlying tables used by Views? --Moid

Click here for the document.

Moid

How to silent Installation Oracle 11g R2 (11.2.0.4) Grid Infrastructure (Software Only)? --Moid

Click here for the document.

Moid

MoidIITDocID-544: How to delete archivelogs from RMAN? --Moid

Click here for the document

Moid

MIITDocID-878: My notes on Oracle partitioning --Moid

Click here for the document.

Moid

Scenario-30

Scenario-29

Scenario-28

Scenario-27

Scenario-26

Scenario-25

Scenario-24

Scenario-23

Scenario-22

Scenario-21

Scenario-20

Scenario-19

Scenario-18

Scenario-17

Scenario-16

Click here for the document

Moid

Scenario-15

Click here for the document

Moid

Scenario-14

Click here for the document

Moid

Scenario-13

Click here for the document

Moid

Scenario-12

Click here for the document

Moid

Scenario-11

Click here for the document

Moid

Scenario-10

Click here for the document

Moid

Scenario-9

Click here for the document

Moid

Scenario-8

Click here for the document

Moid

Scenario-7

Click here for the document

Moid

Scenario-6

Click here for the document

Moid

Scenario-5

Click here for the document

Moid

Scenario-4

Click here for the document

Moid

Scenario-3:

Click here for the document

Moid

Scenario-2:

Click here for the document

Moid

Scenario-1:

Click here for the document:

Moid

My notes on different ways of creating Oracle Database --Moid

Click here for the document.

Moid

MIITDocID-815: My notes on different ways of creating Oracle Database --Moid

Click here for the document.

Moid

How to manually create Oracle database using OMF (10g and 11g)? --Moid

Page moved to --> http://www.mydbanotes.com/2013/06/how-to-manually-create-10g-database-omf.html

Moid

RMAN: Fast Incremental Backups (Block Change Tracking) --Ahsan Mirza

Click here for the document.

Moid

Steps to drop and recreate undo tablespace on RAC (Node-1) -- Ahsan Mirza

Click here for the details.

Moid 

MIITDocID-871: Steps to drop and recreate TEMP Tablespace on RAC --Ahsan Mirza

Click here for the details.

Moid

MoidIITDocID-594: How to backup Oracle database in background using nohup? --Moid

Click here for the document.

Moid

How to check last password change date in Oracle? --Moid

Click here for the document.

Moid

My notes on how to compare two Oracle schema between two databases? --Moid

Click here for the document.

Moid

How to install TOAD 11.0 on Windows 7/8/10? --Moid

Click here for the document.

Moid

How to move a oracle table to a different tablespace? --Moid

Click here for the document.

Moid

MIITDocID-925: How to find the size of Oracle RMAN Backup? --Moid

Click here for the document.

Moid

How to sign up for oracle Metalink account? --Moid

Click here for the document.

Moid

How to find out the sysdate of Oracle Database? --Moid

Click here for the details.

Moid

Document for Students Only: How to create a new schema and load tables? --Moid

Click here for the document.

Moid

URL for Oracle GoldenGate Documentation Library --Moid

Click here for the document.

Moid

My notes on vi editor --Moid

Click here for the document

Moid

How to disable SELinux? --Moid

Click here for the document.

Moid

How to change IP Address of Linux Server (from GUI)? --Moid

Click here for the document.

Moid

MIITDocID-869: How to check the Oracle hidden parameter value? --Moid

Click here for the document.

Moid

Task-391 How to create a READ-ONLY user and how to create an ADMIN user in Oracle?--Moid

Task # 391:

391-A) Please create a Read-Only User called Scott_MM_iuser. This user should be able to read all tables from SCOTT schema.

391-B) Please create a Admin user called Scott_MM_Admin. This user should be able to perform all administrative tasks (Read, Write, Update, Insert) on all tables owned by SCOTT.

Click here for the document.

Note: Before I enable this document, reply with your technical steps that you think will accomplish the above tasks.

--Moid

MIITDocID-927: How to load scripts into the database? --Moid

Click here for the document.

Moid

MIITDocID-920: How to check the size of every schema in Oracle database? --Moid

Click here for the document.

Moid

MoidIITDocID-507: How to deinstall (uninstall) 12c database home from Linux? --Moid

Click here for the document.

Moid

List few basic Dynamic Data Dictionaries views for DBA --Moid

Click here for the document.

Moid

My notes on Oracle Data Dictionary tables for DBA --Moid

Click here for the link.

Moid

MoidIITDocID-:635: Are you a New DBA? How to be prepared for first Day to first few weeks? --Moid

Click here for the document.

Moid

How to check oracle objects owned by different schema? --Moid

Click here for the document.

Moid

MIITDocID-982: How to create mount point in Linux? --Moid

Click here for the document.

Moid

Oracle CASE And DECODE Example -- Moid

Click here for the document.

Moid

MIITDocID-859: My notes on Oracle SQL formatting --Moid

Click here for the details.

Moid

12c Cloud Control - How to add database in 12c Cloud Control (OEM)?

Click here for the document.

Moid Muhammad

MIITDocID-852: How to spool SQL output to a file? --Moid

Click here for the document.