Oracle Database Notes and Scripts

Arsh Ltd is a United Kingdom based dba training and consultancy company, run by experienced Oracle database administrators.

Our dbas have written very clear, simple and step by step Oracle notes, Oracle materials and Oracle scripts on very important database administration topics. We clearly demonstrate in our documents how to setup, install and administer a particular Oracle techonology using easy to implement examples. We also show you how to setup testing environment at your home (YES at your home!) and then try entire material practically there. You can even setup Oracle RAC, Oracle Streams, Oracle Advanced Replication etc. at your home for learning purposes... All our notes are English pdf documents.

People who have used our notes have found them very useful to quickly learn a difficult topic following our material as it has complete setup information (e.g. website links etc) all at one place. Moreover, since our DBAs have implemented material given in our notes, in a test environment, so we know it works !!!

To inform you again, all the following are notes from experienced database administrators and will surely reduce your learning and understanding time of these hot topics by many weeks as you will find by clear examples and scripts in our material. Also we are glad to inform you that the following Sets are our most popular material!

Please check out these special discounted sets and what all they cover ...

Set1 - Oracle on Linux, 10g Oracle Clusterware, RAC, ASM, Grid Control and Agents
(Every DBA's dream test environment)
  1. Implement the following on your test computer -
    1. Install Linux (Ubuntu) Operating System.
    2. Setup Firewall & use of System monitoring tools (for CPU, Disk usage).
    3. Install VMware server & web console for Virtulization.
    4. Process of creating Virtual Machines (VMs).
      Note - All these VMs will run on your single home computer.
  2. Install 10g Oracle clusterware, RAC database and RAC database on a 2 node setup.
  3. Install 10g ASM (Automatic Storage Management) for your RAC database storage.
  4. Install 10g Oracle Grid Control (a GUI tool) for monitoring Oracle RAC environment.
  5. Install 10g Grid Control Management Agents on each of RAC node targets.
  6. DBA Queries / Scripts to manage whole environment
    (e.g. start/stop/administer etc).
    Price 5.99
Set2 - Oracle on Linux, Oracle Streams - bi directional and LDC (Local Downward Capture) mode
  1. Implement the following on your test computer -
    1. Install Linux (Ubuntu) Operating System.
    2. Setup Firewall & use of System monitoring tools (for CPU, Disk usage).
    3. Install VMware server & web console for Virtulization.
    4. Process of creating Virtual Machines (VMs).
      Note - All these VMs will run on your single home computer.
  2. Setup of Bi-Directional Streams (transactions transferred from one database to another instantly)
    1. Table mode
    2. Schema mode
  3. Setup Local Downward Capture mode (LDC) by transferring archive redo logs and mining locally at destination database.
  4. Demonstration of various Streams administration tasks e.g. Schema changes, new columns etc.
  5. How to set up streams as of a backdate i.e. mine logs from past and capture/apply transactions.
  6. Streams Performance Tuning methods.
  7. DBA Queries / Scripts to manage Oracle Streams.
    Price 5.99
Set3 - Oracle Database Administration - Most Important DBA Activities
(With Clear examples and scripts - a must for any Oracle DBA!)
  1. SGA and PGA - Really important concepts and queries.
  2. Rename and Relocate Datafile.
  3. Rename and Relocate Controlfile.
  4. Transportable Tablespaces (TTS) - plug tablespaces from one database into another.
  5. Database, Tablespace, Datafile, Object Sizing scripts.
  6. Cloning a database - Copy entire database (e.g. from production to test environment).
  7. Bind Variables - understanding and considerations, also detect SQL's without binds.
  8. Setup and Usage of Resource Manager - set Quota for CPU, Disk usage for various processes.
  9. Extending table partitions as per business requirements automatically thru jobs.
  10. Dynamic SQL technique - on the fly.
  11. SQL - PL/SQL tables handling.
  12. SQL constructs very important for DBAs.
    Price 5.99
Set4 - Oracle Performance Tuning - Most Important Activities
(With Clear examples and scripts - a must for any Oracle DBA!)
  1. Tuning a slow running query or PLSQL code (procedure/function/pacakge) - STEP BY STEP.
    Very clear steps to identify and tune faulty query/process
  2. Reorganization for space reduction and performance - Index Rebuilds & object shrinking.
  3. AWR and ADDM reports - How to read and intrepret it.
  4. Very Handy Performance Tuning scripts / queries applicable is many scenerios.
    Price 5.99


As you can see, the price is nothing compared to the benefits you get out of the material and as you know these are from experienced Oracle dba's.

Please also note that we only accept payment by Paypal - the most widely used way of making payment on the internet. To buy our material -
  1. You need to create a FREE login account on this site, please register here.
    If you already have an account, then please login here.

    After loggin in, you can return to this page by clicking on the [Check our Special Offer here] link on top of our site.

  2. After logging in, select your products and click on the Buy Now button below on this page.
P109 - ALL OF THE ABOVE STUDY MATERIAL !!! Limited time special offer (Step by Step) - This is a limited time special offer where we are offering all of the material sets. As you would know all these topics are very important components of DBA Tasks.

As you can see that this is 43% reduction in our prices! Hurry limited time.

Select Notes Description Price (GBP £)
Total Amount of your purchases
(For purchases within United Kingdom, VAT @ 17.5% will be charged)

If you have any queries or want any help please send us an email here

Go to Home Page here