Blog Aggregator - Amardeep Sidhu

  • Tags

  • Archives

  • Meta

  •  

    May 2007
    M T W T F S S
    « Apr   Jun »
     123456
    78910111213
    14151617181920
    21222324252627
    28293031  

Archive for May 24th, 2007

24 May

What is going on in Oracle’s QA department?

I’ve been an Oracle DBA since the days of 7.0.16 (on Netware, but that’s a story for a different day). I’d like to think I have a decent amount of experience with Oracle and it’s nuances. Sure, some things are quirky and don’t work the way you think they should, but that’s just getting used to the software. I can count on one hand the number of one-off patches I had to install over a base patchset in 7.x to 9.2. (I’m talking RDBMS here, not Oracle Apps.)

I specifically waited to move to 10g until it had been out a while. Our move to 10.2.0.3 has been quite disappointing. Sure, we did a lot of testing. But production is different than testing. After about 30 days of one db being live, we’ve had to install three one-off patches. And we just got slammed with two more in the last couple days to bring the total up to five. If we were on 10.2.0.0, I’d understand, but 10.2.0.3? Five freaking one-off patches.

C’mon Oracle, get your act together. We’re trying to run a business here.

24 May

Modifying sprepins.sql for Custom Statspack Reports I

I use STATSPACK extensively for comparing two time periods, comparing a time period to a baseline, monitoring trends and diagnosing performance problems. It provides important data about the database performance. The code producing statspack reports is open and you can modify it to your needs.

You run $ORACLE_HOME/rdbms/admin/spreport.sql to produce statspack reports. spreport.sql calls

© 2008 Blog Aggregator - Amardeep Sidhu | Entries (RSS) and Comments (RSS)

Powered by Wordpress, design by Web4 Sudoku, based on Pinkline by GPS Gazette