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

MoidIITDocID-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.

How to check number of processors on Linux Server? --Moid

Click here for the document.

Moid

How to check Oracle Database uptime? --Moid

Click here for the document.

Moid

MIITDocID-994: How to disable / drop Oracle redo log thread? --Moid

Click here for the document.

Moid

My queries on Oracle connection count --Moid

Click here for the document.

Moid

MIITDocID-882: How many permissions are assigned to a USER or ROLE?

Click here for the document.

Moid

MIITDocID-852: How to extract synonym's DDL from an Oracle schema? --Moid

Click here for the document.

Moid

How to verify Oracle Database Patchset? --Moid

Click here for the document

--Moid Muhammad




Keywords:
opatch,
patch version,
opatch version,
patcheset version

My notes on Oracle High Availability Services (OHAS) --Moid

Click here for the document.

Moid 

MIITDocID-937: How to check the status of RMAN backup? --Moid

Click here for the document.

Moid

Performance Tuning: How does the optimizer know about stale or missing statistics on the table? --Moid

Click here for the document.

Moid

Sessions: How to count number of sessions connected to Oracle database? --Moid

Click here for the document.

Moid

MIITDocID-871: How to install Oracle 12c R1 Client on Windows 8/10? --Moid

Click here for the document.

Moid

Performance Tuning: My notes on Library Cache --Moid

Click here for the details.

Moid

How to move all oracle datafiles to a new directory? --Moid

Click here for the document.

Moid

My notes on Grid Control Agent --Moid

Click here for the document.

Moid

MoidIITDocID-530: How to find Top 10 current SQLs by elapsed time and check their explain plan? --Moid

Click here for the document.

Moid

What features of Oracle database are in use? --Moid

Click here for the document.

Moid

Standalone 12c Grid Infrastructure install on CentOS 5.6 - Part 24 [How to Manage Cluster Resources using HAS] --Moid

Click here for the document.

Moid

Standalone 12c Grid Infrastructure install on CentOS 5.6 - Part 25

Click here for the document.

Moid

Standalone 12c Grid Infrastructure install on CentOS 5.6 - Part 23

Click here for the link.

Moid

Standalone 12c Grid Infrastructure install on CentOS 5.6 - Part 22 [Install 12c R1 Datababase Software (Part-2)] --Moid

Click here for the document.

Moid

Standalone 12c Grid Infrastructure install on CentOS 5.6 - Part 21 [Install 12c R1 Database (Part-1)] --Moid

Click here for the document.

Moid

Standalone 12c Grid Infrastructure install on CentOS 5.6 - Part 20 [Download and Unzip 12c R1 Database Software] --Moid

Click here for the document.

Moid

Standalone 12c Grid Infrastructure install on CentOS 5.6 - Part 19 [Create Diskgroups from sqlplus prompt] --Moid

Click here for the document.

Moid

Standalone 12c Grid Infrastructure install on CentOS 5.6 - Part 18 [Install Grid Infrastructure (Part-2)] --Moid

Click here for the document.

Moid

Standalone 12c Grid Infrastructure install on CentOS 5.6 - Part 17 [Install Grid Infrastructure (Part-1)] --Moid

Click here for the document

Moid

Standalone 12c Grid Infrastructure install on CentOS 5.6 - Part 16 [Download and unzip 12c Grid Infrastructure software] --Moid

Click here for the document. 

Moid

Standalone 12c Grid Infrastructure install on CentOS 5.6 - Part 15 [Permissions] --Moid

Click here for the document.

Moid

Standalone 12c Grid Infrastructure install on CentOS 5.6 - Part 14 [Create and load ASM Disks] --Moid

Click here for the document

Moid