We at thecheapdba have often been asked about writing scripts under Windows (.BAT scripts). Most DBAs have grown up in the Unix world and know sh,bash,perl,etc. but when it comes to Windows they sort of throw up their hands and wonder how they can deploy. Often times it means putting some Unix clone on a [...]

[Read more →]

Have you ever had a headache trying to browse through all the Oracle News and blog postings out there.
Well TheCheapDBA has just put up an Oracle News Aggregator to assist you in this.
We are currently cataloging and adding those blogs and news sources we feel are important to you.
But if you feel we have missed [...]

[Read more →]

Being a cheapDBA and wanting to have Oracle 11g to play around with from time to time I just had to get this version installed and running.
A few months ago I decided to also try Oracle’s Enterprise Linux. Hey! it is free. AND I actually decided to purchase the 1-year support for it. This was [...]

[Read more →]

I think it is very important to be able to extract information from the workload repository history tables. After all, who wants to go run a complete report if you are just looking for a specific piece of data. Plus this allows you to become more agile in the way you monitor your database and [...]

[Read more →]

Yesterday we posted a SQL script for the read/write percentages for datafiles. But for those of us that do not have all the disk in the world and have to put temporary tablespace’s physical files on the same disks as regular datafiles we really need to include the reads and writes that occur on those [...]

[Read more →]

In a couple of posts ago we showed you how to extract the IOPS and MBPS from an Oracle database. Well, there isn’t an easy way to equate these to a per datafile or per object basis to determine which datafiles or objects are the blunt of the I/O activity. So we have to revert [...]

[Read more →]

Just in case you are like me, I missed the initial posting of Oracle 11gR1 download out on technet.
I have started my download, as I write, and will be posting here the things I find and play with. I don’t know about you but I am looking forward to finding all those new little features [...]

[Read more →]

This is what it is all About!
Get complete history of IOPS & MBPS from workload repository history and graph it for you management.
This allows you to see total database disk activity.
Compare this against what your disk capacity is.
Just remember these numbers are for ALL disks. You can get average IOPS/MBPS by dividing by your total [...]

[Read more →]

As a followup to vsysstat_ioworkload.sql, here is a script that does the same thing against performance snapthots (workload repository history)
–# ———————————————————————-
–# Script : wrh_sysstat_ioworkload.sql
–# Author : thecheapdba
–# Tested : Oracle 10.2
–# Version : 2007/08/07
–# Purpose : Report on IOPS & MBPS over a period of time as seen by DB.
–# ———————————————————————-
–# NOTES [...]

[Read more →]

This very first script is somewhat unique. It will calculate the IOPS for small and large I/O, the percentage of reads to writes, and the MBPS throughput over a period of time as seen by the database. I have only seen this type of script in one other location but has yet to be put [...]

[Read more →]