My notes on Oracle Database Administration -- Moid

Thursday, October 31, 2013

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

Click here for the document.

Moid
Moid Muhammad at 1:27 PM No comments:
Share

Monday, October 28, 2013

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

Click here for the document.

Moid
Moid Muhammad at 3:34 PM No comments:
Share

Saturday, October 26, 2013

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

Click here for the document.

Moid
Moid Muhammad at 4:20 AM No comments:
Share

Friday, October 25, 2013

Performance Tuning: My notes on Library Cache --Moid

Click here for the details.

Moid
Moid Muhammad at 12:56 PM No comments:
Share

Thursday, October 24, 2013

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

Click here for the document.

Moid
Moid Muhammad at 3:21 PM No comments:
Share

My notes on Grid Control Agent --Moid

Click here for the document.

Moid
Moid Muhammad at 12:19 PM No comments:
Share

Wednesday, October 23, 2013

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

Click here for the document.

Moid
Moid Muhammad at 12:47 PM No comments:
Share

Tuesday, October 22, 2013

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

Click here for the document.

Moid
Moid Muhammad at 1:17 PM No comments:
Share

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
Moid Muhammad at 1:13 PM No comments:
Share

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

Click here for the document.

Moid
Moid Muhammad at 1:13 PM No comments:
Share

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

Click here for the link.

Moid
Moid Muhammad at 1:13 PM No comments:
Share

Saturday, October 19, 2013

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
Moid Muhammad at 2:51 AM No comments:
Share

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

Click here for the document.

Moid
Moid Muhammad at 2:49 AM No comments:
Share

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
Moid Muhammad at 2:49 AM No comments:
Share

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

Click here for the document.

Moid
Moid Muhammad at 2:47 AM No comments:
Share

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

Click here for the document.

Moid
Moid Muhammad at 2:46 AM No comments:
Share

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

Click here for the document

Moid
Moid Muhammad at 2:45 AM No comments:
Share

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
Moid Muhammad at 2:44 AM No comments:
Share

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

Click here for the document.

Moid
Moid Muhammad at 2:42 AM No comments:
Share

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

Click here for the document

Moid
Moid Muhammad at 2:40 AM No comments:
Share

Standalone 12c Grid Infrastructure install on CentOS 5.6 - Part 13 [Configure oracleasm] --Moid

Click here for the document.

Moid
Moid Muhammad at 2:39 AM No comments:
Share

Standalone 12c Grid Infrastructure install on CentOS 5.6 - Part 12 [Download and install ASMLib packages] --Moid

Click here for the document.

Moid
Moid Muhammad at 2:38 AM No comments:
Share

Standalone 12c Grid Infrastructure install on CentOS 5.6 - Part 11 [Create Partitions for ASM] --Moid

Click here for the document.

Moid
Moid Muhammad at 2:36 AM No comments:
Share

Standalone 12c Grid Infrastructure install on CentOS 5.6 - Part 10 [Add Hard Drive for ASM] --Moid

Click here for the document.

Moid
Moid Muhammad at 2:36 AM No comments:
Share

Standalone 12c Grid Infrastructure install on CentOS 5.6 - Part 9 [Oracle Software Prereq] --Moid

Click here for the document.

Moid
Moid Muhammad at 2:35 AM No comments:
Share

Standalone 12c Grid Infrastructure install on CentOS 5.6 - Part 8 [Create grid User] --Moid

Click here for the document.

Moid
Moid Muhammad at 2:33 AM No comments:
Share

Standalone 12c Grid Infrastructure install on CentOS 5.6 - Part 7 [Create oracle User] --Moid

Click here for the document.

--Moid
Moid Muhammad at 2:31 AM No comments:
Share

Standalone 12c Grid Infrastructure install on CentOS 5.6 - Part 5 [Add Disk for Oracle software Installation] --Moid

Click here for the document.

--Moid
Moid Muhammad at 2:29 AM No comments:
Share

Standalone 12c Grid Infrastructure install on CentOS 5.6 - Part 6 [Create partitions for Oracle Mount points and label them] --Moid

Click here for the document.

Moid
Moid Muhammad at 2:26 AM No comments:
Share

Standalone 12c Grid Infrastructure install on CentOS 7.2 - Part 4 [CentOS 7.2 OS Installation] --Moid

Click here for the document

Moid
Moid Muhammad at 2:24 AM No comments:
Share

Standalone 12c Grid Infrastructure install on CentOS 7.2- Part 3 [Setup VMWare] --Moid

Click here for the document. 

Moid
Moid Muhammad at 2:22 AM No comments:
Share

Standalone 12c Grid Infrastructure install on CentOS 7.2 - Part 2 [Preparation] --Moid

Click here for the document.

Moid
Moid Muhammad at 2:21 AM No comments:
Share

Standalone 12c Grid Infrastructure install on CentOS 5.6 - Part 1 [Main Document -- How to setup ASM database on VMWare? --Moid

Click here for the document.

--Moid
Moid Muhammad at 2:19 AM No comments:
Share

Thursday, October 17, 2013

MIITDocID-909: How to take VMWare snapshot (from VMWare Server)? --Moid

Click here for the document.

Moid
Moid Muhammad at 11:12 PM No comments:
Share

Wednesday, October 9, 2013

How to create softlink? --Moid

Click here for the document.

--Moid
Moid Muhammad at 12:10 AM No comments:
Share

Friday, October 4, 2013

MoidIITDocID-545: How to restore archivelogs from RMAN Backup? --Moid

Click here for the document.

--Moid
Moid Muhammad at 4:20 PM No comments:
Share

Thursday, October 3, 2013

MIITDocID-953: How to create a data pump directory? --Moid

Click here for the document.

--Moid
Moid Muhammad at 12:27 PM No comments:
Share
‹
›
Home
View web version
Powered by Blogger.