Monthly Archives: January 2007

SQL Server 2005

Posted on 26 January 2007 by Andrew Fraser

SQL Server 2005 doesn’t prompt during install for locations of datafiles and logfiles, meaning they will end up on C:, which you won’t normally want. You can alter the locations during install, but it’s not especially intuitive. Or at least … Continue reading →

Posted in SQL server | 1 Comment

Of Goats and Porsches: A Monty Hall Paradox Simulator

Posted on 17 January 2007 by Andrew Fraser

The Monty Hall Paradox can’t be right, or so I thought. Suppose you’re on a game show, and you’re given the choice of three doors: Behind one door is a car; behind the others, goats. You pick a door, say … Continue reading →

Posted in General musings | 4 Comments

Identify what auditing is on

Posted on 17 January 2007 by Andrew Fraser

Suspect too much auditing is on on a database? This script will show you what auditing is on: set pages 9999 select * from DBA_STMT_AUDIT_OPTS ; select * from DBA_PRIV_AUDIT_OPTS ; set termout off lines 192 spool 1.tmp select * … Continue reading →

Posted in Audit, Scripts | Leave a comment

NID to fix RMAN-20035: invalid high recid

Posted on 16 January 2007 by Andrew Fraser

For errors like: RMAN-03014: implicit resync of recovery catalog failed RMAN-06004: ORACLE error from recovery catalog database: RMAN-20035: invalid high recid You can switch the catalog over to a previous incarnation (before an open resetlogs): RMAN> list incarnation of database … Continue reading →

Posted in Rman | 1 Comment

Pre 9202/9014: Advanced queuing runs away with server memory.

Posted on 15 January 2007 by Andrew Fraser

Using the below memory listing script, I found two databases with large PGAs. That was strange since pga_aggregate_target was unset, sort_area_size was just 64k, and there were very few sessions. Checking PGA at session level showed the QMN sessions had … Continue reading →

Posted in Bugs, Scripts | Leave a comment

Death March

Posted on 15 January 2007 by Andrew Fraser

What is a death march project? What makes IT organizations create such things? Why would anyone in his right mind agree to participate in such a project?To many grizzled IT veterans, these are rhetorical questions. Everything, in their experience, is … Continue reading →

Posted in Book review, General musings | 1 Comment

Tablespace space with sm$ views + database level space

Posted on 15 January 2007 by Andrew Fraser

The sm$ views are an easy way of seeing tablespace space usage. There is also an sm$ts_free view. set pages 9999 col tot_mb form 999,999 col use_mb form 999,999 col pct_used form 999 select t.tablespace_name, t.bytes/1024/1024 tot_mb, u.bytes/1024/1024 use_mb, 100*u.bytes/t.bytes … Continue reading →

Posted in Scripts, Space | Leave a comment

Old c compilers needed for 9i on Red Hat Linux

Posted on 12 January 2007 by Andrew Fraser

9i on Red Hat Linux (with the exception apparently 32-bit on RH3) won’t install unless you revert the c compilers back to old versions. Horrible. But fixed (I am told) with oracle 10g. And its not something you necessarily want … Continue reading →

Posted in Installs, Linux, Old | Leave a comment

rman crosscheck archivelog all

Posted on 12 January 2007 by Andrew Fraser

If archived redo logs are (wrongly) deleted/moved/compressed from disk without being backed up, the rman catalog will not know this has happened, and will keep attempting to backup the missing archived redo logs. That will cause rman archived redo log … Continue reading →

Posted in Rman, Scripts | 4 Comments

useful simple vi commands for DBAs

Posted on 12 January 2007 by Andrew Fraser

These 32 are the only commands I ever seem to use in vi: Command Effect :.= find out the current line number :1 go to line 1 Ctrl-d page down Ctrl-u page up Shift-G go to end of file i … Continue reading →

Posted in Linux | 13 Comments