IT programs only teach you the programming and software architecture perspective. In DBA work, even when scripting, you have to consider the data as a tool. I’ll show you what I mean.
Over-the-Top Tales from the Trenches: Bringing order to the chaos of every-day DBA life.
It looks like Oracle has started testing the 10.2.0.3 patchset. A preliminary list of bugs fixed is at in MetaLink note 391116.1. The “important” bug fixes are here.
Log Buffer #11, a compendium of news from the database blogosphere has been published on Mark Rittmanâ€™s Oracle Weblog.
Indeed, while the technique we discuss here is basic, it gives a good overview and is very easy to use. So let get focused… We will use iostat utility. There is much to say about IO monitoring and interpreting results. Perhaps this is only the first of a series of posts about IO statistics. At Pythian we often come across different environments with specific characteristics and various requirements that our clients have. So stay tune — more to come.
Welcome to the tenth edition of Log Buffer, the weekly compendium of blogs for DBAs. Let’s dive right in.
Over the Top Tales from the Trenches: Bringing order to the chaos of every day DBA life.
Typically, we monitor the v$datafile to ensure there are no NOLOGGING operations that will break our standby database. So it is important that we confirm that this mechanism actually works. ut for some reason, it is showing nothing under v$datafile for the YESLOG tablespace. I know this operation will break the standby database (because of a break in archive-log activity). I am just not sure how to confirm in the data dictionary.
The ninth edition of Log Buffer, the weekly review of database blogs, is now available at Daniel Schneller’s Blog.
In this second part , I will outline more details of a new STATSPACK methodology. As I mentioned in previous part , the statspack_setting table is a bridge between the user and Oracle’s STATSPACK.