Oracle DBA Training | Batch-32 | Registrations are now open | Chicago --Moid

Click here to register.

Moid

MoidIITDocID-638: How to purge AWR snapshots? --Moid

Click here for the document.

Moid

MoidIITDocID-639: VMWare - How to solve "No route to host" error? --Moid

Click here for the full page

Moid Muhamad

MIITDocID-946: How to extract DDL of all indexes from an Oracle schema? --Moid

Click here for the document.

Moid

MIITDocID-902: How to get DDL of all tablespaces (by Umer, Zubeen)? --Moid

Click here for the details.

Moid 

MIITDocID-887: My notes on Oracle User Management --Moid

Click here for the link.

Moid

What is the "ps -ef |grep pmon" equivalent command in windows? (Contributed by Talha Siraj) --Moid

Click here for the document.

Moid

MIITDocID-929: How to get info on Oracle Active sessions (contributed by Asad Mohammed)? --Moid

Click here for the document.

Moid

Oracle DBA Checklist --Moid

Click here for the document.

Moid

MIITDocID-928: Oracle script to check the database growth (written by Hadi Bhuya) --Moid

Click here for the document.

Moid

MIITDocID-564: My queries on 12c Multitanent, cdb (container database) and pdb (pluggable databases) --Moid

Click here for the document

How to migrate database from Windows to Linux Using RMAN (Shared by Mariyam Shareef) --Moid

Click here for the document shared by Mariyam Shareef 

Moid

MIITDocID-915: Script to check Tablespace Space Utilization (Shared by Talha Siraj) --Moid

Click here for the page.

Moid

My notes on tablespaces and logical structure of databases --Ahmad Bhutta

My notes on tablespaces and logical structure of databases --Ahmad Bhutta

Moid

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

Document ID-561: My notes on DBMS scheduler (New in 11g instead of dbms_jobs) --Moid

Click here for the document.

Moid

Document ID-560 | RMAN: How to automatically purge archivelog using dbms schedular? --Moid

Week-25 | ASM homework | TASK - ASM100 --Moid

Click here for the document. Moid

Document ID: 558 How to flush shared pool? --Moid

Document ID 557 | How to purge Oracle Audit Files older than 7 days through crontab? --Moid

MIITDocID-873: How to install SQL Developer 4.0.3.16 on Windows 7? --Moid

Click here for the document.

Moid Muhammad

Week-24: Advance Classes: ASM: Managing ASM --Moid

Click here for Task-1
Click here for Task-2
Task-3 How to Create ASM database manually using OMF?
Click here for Task-4
Click here for Task-5

Moid Muhammd

Week-23: Advance Classes: How to build 12c ASM Database Server --Moid

Standalone 12c Grid Infrastructure install on CentOS 5.6

Moid Muhammad

MoidIITDocID-537: How to apply one-off patch using Oracle opatch utility? --Moid

Click here for the document.

Moid

My notes on DBA_jobs (DBA jobs) --Moid

Click here for the full page or see below:

MIITDocID-985: Query to find the last RMAN backup’s log (RMAN logfiles / RMAN output)? --Moid

Click here for the document.

Moid

Performance Tuning: My notes on SQL Plan Management (SPM) --Moid

Click here for details.

Moid

Kill sessios - How to schedule a cronjob to identify and kill oracle session running over 4 hours. --Moid

Click here for the document.

Moid Muhammad

My notes on Oracle Sorts (order by) --Moid

Click here for the document.

Moid Muhammad

MIITDocID-900: How to get Oracle Tablespace Usage History? --Moid

Click here for the document.

Moid

My queries on Oracle Performance Tuning --Moid

Click here for the document.

Moid

How to check Oracle listener's trace level and turn if off? --Moid

Click here for the document.

Moid

MIITDocID-995: My notes on Oracle RAC Commands --Moid

Click here for the document.

Moid

RMAN: How to unregister database from RMAN catalog? --Faisal Hasan

Click here for the document.

Moid

MoidIITDocID-559: How to check the status of Data Pump export? --Moid

Click here for details.

Moid

MoidIITDocID-592: My notes on Oracle RAC Services --Moid

Click here for the document.

Moid

Data Guard: How to remove database from Data Guard Configuration? --Moid

Click here for the document.

Moid

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