How to find out the which version of sqlplus (32-bit or 64-bit) you are using? --Moid

Click here for the document

--Moid

How to grant permissions on Oracle dictionary views? --Moid

Click here for the document.

--Moid

How to deinstall Oracle 11g client from Linux? ---Moid

Click here for the document.

--Moid

MIITDocID-964: How to find the location of alert log? --Moid

Click here for the document?

--Moid

RAC: Where are logfiles in Oracle RAC? --Moid

Click here for the document.

--Moid

MoidIITDocID-558: How to enable Oracle Flash Recovery Area? --Moid

Click here for the document.

--Moid



Keyword: FRA

MIITDocID-931: How to get DDL of Oracle Schema (Oracle user) with all grants and roles? --Moid

Click here for the document for the answer.

--Moid

MoidIITDocID-527: How to perform Oracle Point-In-Time recovery using RMAN? --Moid

Click here for the document.

--Moid

MoidIITDocID-636: My notes on Oracle database links (DB Links) --Moid

Click here for the document.

--Moid

MIITDocID-926: How to find the size of schemas which are larger than 1 GB? --Moid

Click here for the document.

--Moid

Where is Oracle Forum for GoldenGate? --Moid

Click here for the document.

--Moid

Oracle GoldenGate Master Note Metalink ID --Moid

Click here for the document.

--Moid

Kill sessions - How to create procedure to identify and kill OTHER sessions? --Moid

Click here for the document.

--Moid

How to check Oracle Database Version? --Moid

Click here for the document.

--Moid

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

Click here for the document.

--Moid

SQL Book for class --Moid

Click here for info.

--Moid

Linux -- How to rename multiple files in a directory? --Moid

Click here for the details.

--Moid

Kill sessions - How to create procedure to identify and kill sessions? --Moid

Click here for the document.

--Moid

Kill Sessions - How to create a procedure to kill other terminals of current Oracle user? --Moid

Click here for the document.

--Moid

Data Pump - What is the command to import the data? --Moid

Click here for the document.

--Moid

Data Pump - What is the command to take schema level export? --Moid

Click here for the document.

--Moid

MoidIITDocID-524: How to verify if Redo Apply is ON or OFF on standby database? --Moid

Click here for the document.

--Moid

MIITDocID-951: How to list Data Pump Directories? --Moid

Click here for the document.

--Moid

Data Pump - How to create data pump directory? --Moid

Click here for the document.

--Moid

MIITDocID-924: How to find the size of every table in Oracle schema? --Moid

Click here for the document.

--Moid

How to kill all current Oracle user's sessions except the current one I am logged in? --Moid

Click here for the document.

--Moid

MoidIITDocID-500: My notes on Oracle Password Policy --Moid

Click here for the document.

--Moid

How to silent install Oracle 11g Client on Linux? --Moid

Click here for document.

--Moid

How to kill all connections from an Oracle user? --Moid

Click here for document.

--Moid

What permission do you need to login to Grid Control? --Moid

Click here for the document.

--Moid

How to restore RMAN backup from different location? --Moid

Click here for the document.

--Moid

How to find Oracle tables that are in non-default tablespace? --Moid

Click here for the document.

--Moid

How to check the status of RMAN job?

Click here for the document

--Moid

Data Guard in Images [How to configure Log_Archive_dest_2] --Moid

Click here for the document.

--Moid Muhammad

How to delete archivelogs from RMAN? --Moid

Click here for the document.

--Moid

How to gather table stats on multiple tables in 11g R2? --Moid

Click here for the document.

--Moid

My notes on 11g Automatic Statistics Collection (DBMS_STATS) --Moid

Click here for the documents.

--Moid

MIITDocID-954: How to drop a Oracle Data Pump directory? --Moid

Click here for the document.

--Moid

Oracle Reserved Word --Moid

Click here for the document.

--Moid

How to check for invalid objects in Oracle database? --Moid

Click here for the document.

--Moid

MoidIITDocID-609: My notes about Oracle Explain Plan --Moid

Click here for the document.

--Moid

SQL Server 2005 Installation on Windows 7 Ultimate --Moid

Click here for the document.

--Moid

Homework (Week-10) [How to Install Oracle 11g R2 Database on Windows 7 / Windows 8?] --Moid

Click here for the document on how on install Oracle 11g on Windows 7?
Click here for the document on how on install Oracle 12c on Windows 8?

--Moid

MoidIITDocID-512: How to find the size of oracle table? --Moid

Click here for the document.

--Moid

MIITDocID-918: How to find the size of all tables in Oracle schema? --Moid

Click here for the document.

--Moid

Keyword: Table size

MoidIITDocID-517: My notes on Voting Disk --Moid

Click here for the document.

--Moid

MoidIITDocID-897: My notes on OCR (Oracle Cluster Registry) --Moid

Click here for the document.

--Moid

Chapter-6 Lab Activity --Moid

Chapter-5 Lab Activity -Moid

Chapter-4 Lab Activity --Moid

Chapter-3 Lab Activity --Moid

Chapter-2 Lab Activity --Moid

Chapter-1 Lab Activity --Moid

Chapter-8 Lab Acitivity --Moid

Chapter-7 Lab Activity --Moid

Click here for the document.

--Moid Muhammad

MIITDocID-960: My notes on crontab --Moid

Click here for the document.

--Moid

What is the better Career Path? DBA vs Software Engineer?

I think the following discussion is worth reading...

 http://www.coderanch.com/t/32120/Jobs/careers/better-Career-Path-DBA-vs 

 

MoidIITDocID-969: How to restore and rename database on a different server? --Moid

Click here for the document.

--Moid

How to purge trace files using adrci? --Moid

Click here for the document.

--Moid

MIITDocID-968: How to setup putty logs (capture whatever you are doing in putty into a text file)? --Moid

Click here for the document.

--Moid

How to purge trace files using adrci? --Moid

Click here for the document.

--Moid

PrimeDG DBConsole --Moid

Click here for the document.

--Moid

CyclopDB DBConsole --Moid

Click here for the document.

--Moid

Oracle Patchset Release Dates and Numbers --Moid

Click here for the document.

Monitor Instance I/O in 11g --Moid

Click here for the document.

--Moid

How to load data using SQL Loader? --Moid

Click here for the document.

--Moid

MoidIITDocID-551: How to create 11g RMAN Catalog? --Moid

Click here for the document.

--Moid

How to list cronjob from all users? --Moid

Click her for the document.

--Moid

MIITDocID-884: My queries on Oracle Roles --Moid

Click here for the document.

--Moid

MIITDocID-913: How to create a dblink? --Moid

Click here for the document.

--Moid

Test-1 UNIX and vi editor

Click here for the Test.

--Moid

Week-16: Homework on SGA --Moid

Click here for the link.

--Moid

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

Click here for the document.

--Moid

Export / Import Exercise (20) --Moid

Click here for the document.

--Moid

Export / Import Exercise (19) --Moid

Click here for the document.

--Moid

Export / Import Exercise (18) --Moid

Click here for the document.

--Moid

Export / Import Exercise (17) --Moid

Click here for the document.

--Moid

Export / Import Exercise (16) --Moid

Click here for the document.

--Moid

Export / Import Exercise (15) --Moid

Click here for the document.

--Moid

Export / Import Exercise (14) --Moid

Click here for the document.

--Moid

Export / Import Exercise (13) --Moid

Click here from document.

--Moid

Export / Import Exercise (12) --Moid

Click here for the document.

--Moid

Export / Import Exercise (11) --Moid

Click here for the document.

--Moid

Export / Import Exercise (10) --Moid

Click here for the document.

--Moid

Export / Import Exercise (9) --Moid

Click here for the document.

--Moid

Export / Import Exercise (7) --Moid

Click here for the document.

--Moid

Export / Import Exercise (8) [Linux script to take a daily Oracle export of a schema] --Moid

Click here for the document.

--Moid

Export / Import Exercise (6) --Moid

Click here for the document.

--Moid

Export / Import Exercise (5) --Moid

Click here for the document.

--Moid

Export / Import Exercise (4) --Moid

Click here for the document.

--Moid

Export / Import Exercise (3) --Moid

Click here for the document.

--Moid Muhammad

Export / Import Exercise (2) --Moid

Click here for the document.

--Moid

Export / Import Exercise (1) --Moid

Click here for the document.

--Moid

How to force RMAN to write the timestamp? --Moid

Click here for the document.

--Moid

How to Install Oracle 10g on XP? --Moid

Click here for document.

--Moid

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

Click here for the document.

--Moid

How to Install Oracle 11g R2 on Windows 7? --Moid

Click here for the document.

--Moid

MIITDocID-967: How to change the background color in putty? --Moid

Click here for the document.

--Moid

How to find Oracle RAC Cluster name? --Moid

Depending on how you set up environment for CRS home in Linux, one of the following can be used to find the cluster name of you RAC environment.

$ORA_CRS_HOME/bin/cemutlo -n
or
$CRS_HOME/bin/cemutlo -n


--Moid

How to find large Oracle files in Linux DB Server? --Moid

Click here for the document.

--Moid