Oracle

Another little known set of AWR reports are ones that are RAC specific and cluster wide versions, giving the RAC

As many companies judge a DBA’s worth on the uptime of a database, nothing tests a DBA’s mettle like database

I received an email from an obviously annoyed DBA this weekend.  I’m sure many of you are not surprised, I

This is an Apex query and it no longer exists in the environment it once resided in-  When I first

This Statspack bug is an older one, but I ran into it this week again. The work around is very

Any DBA worth the time of day knows how important having solid statistics is to a database.  This is how

*****After much adieu, I’ve finally returned to this post to rewrite what concerned me and befuddled others… :)***** I’ve worked

A follow up to this previous post.  I thought I had this one down-  had followed the standard protocol when

One of the options for cloning an environment with limited disk space  involves creating a parameters file for the RMAN

A common initial resolution to reporting requirements without a reporting database is to utilize materialized views.  Unfortunately, the cost to

In my years as an Oracle and SQL Server DBA and the many technical environments I’ve worked in, there’s almost always one database in each

Sigh….IF I could only live in “Uncle Larry’s” perfect database world where I have more control over what choices are

After upgrading to 10.2.0.5 on Linux, our Oracle Enterprise Manager would report intermittently that the OC4J was down- Target Name=EnterpriseManager0.serve3r

I know I owe a few folks a blog on temp tablespace groups-  THANK YOU for your patience, I know

Let’s say you have a database that everything can be recreated just by re-running a process and no nightly backups

Interesting Issue… I was working on an interrupted distributed, (remote) transaction that I’d come across in one of our smaller