Monthly Archives: April 2007

And on the seventh day, God fiddled with His NLS settings

Posted on 25 April 2007 by Andrew Fraser

This would seem to be pretty authoritative: “And on the seventh day God ended his work which He had made; and he rested on the seventh day from all his work which He had made. And God blessed the seventh … Continue reading →

Posted in Bugs, Character sets | 4 Comments

What SQL and sessions are running?

Posted on 20 April 2007 by Andrew Fraser

GUIs like TOAD and Enterprise Manager can show this better, but they’re not always to hand. Every session active now or within the last minute is shown. set pages 9999 lines 132 col username form a20 col osuser form a20 … Continue reading →

Posted in Performance tuning, Scripts | 3 Comments

Data block corruption cleared with alter system flush buffer_cache

Posted on 19 April 2007 by Andrew Fraser

So I had: ORA-08103: object no longer exists being reported on SQL affecting one application table. But that table existed ok in dba_tables, could be described ok, and selects restricted to its indexed columns returned data ok. Suspicion was some … Continue reading →

Posted in Bugs, Rman | 2 Comments

Free X windows emulator for running Oracle Installer

Posted on 19 April 2007 by Andrew Fraser

It’s often a pain getting X windows GUIs like the Oracle Installer and DBCA to run on Micrsoft Windows PC clients. Emulators like Reflection-X, KEA-Term, and Exceed work ok, but they cost money to licence and require source media and … Continue reading →

Posted in Installs, Linux | 7 Comments