If you haven’t seen Dan Morgan’s Oracle library yet at http://www.psoug.org/library.html then now it’s time to do so!
I think what he’s done is awesome and I use his library almost every day when I don’t remember some syntax off the top of my head. I normally just google for keywords like “create hash cluster psoug” [...]
There’s a command called: ORADEBUG SETORAPNAME in 11g.
It allows you to attach to a named background process as shown below, so you don’t need to figure out what’s the PID or SPID of the target process.
SQL> oradebug setorapname dbw0
Oracle pid: 9, Unix process pid: 5506, image: oracle@linux03 (DBW0)
SQL>
SQL> oradebug setorapname pmon
Oracle pid: 2, Unix process [...]
I have mentioned ORADEBUG SHORT_STACK command in my blog posts before - it’s an easy way to get and see target processes stack backtrace directly in sqlplus. No need to log on to the Unix/Windows server and use OS tools for extracting the stack.
I have also written few tools which allow you to post-process stack [...]
I recently saw a fellow OakTable member mentioning a section in Oracle documentation where it’s said that:
“When a database contains tablespaces that have been plugged in (from other databases), the ROWIDs in that database are no longer unique. A ROWID is guaranteed unique only within a table.”
It’s a well known fact that the old Oracle7 [...]
I will be speaking at Austrian Oracle User Group event in Vienna this Wednesday (15. Oct) with Christian Antognini
I will deliver an 1 hour version of my Advanced Oracle Troubleshooting presentation there, so if you’re in Austria and want to see what’s coming in my full length seminar I deliver on 3.-4. Nov also in [...]
My today morning’s Advanced Oracle Troubleshooting presentation was quite a success. The 400 people room was fully pre-booked and over 300 people showed up. This is a pretty good result considering that a) my presentation was an 9 am one on the last day of conference and b) there was a big party last night [...]
I’ve been too busy lately to write anything serious here (and still am).
I noticed that that Oracle 11g patchset 11.1.0.7 for Linux 32/64bit is available, so that’s what I’ll be dealing with during my 20 hour flight from Singapore to San Francisco tomorrow 
See you at Oracle OpenWorld and thanks for all the people who [...]
If you’re interested in leading edge database research, the VLDB 2008 proceedings are publicly available now.
Multiple Oracle-specific presentations are available on the industry track page
Here are direct links to them:
Oracle SecureFiles System
Optimizer Plan Change Management: Improved Stability and Performance in Oracle 11g
Closing The Query Processing Loop in Oracle 11g (this one is about adaptive cursor [...]
I have written two posts in one, about a performance issue with writes in system tablespace and introduction of a little DTrace stack sampling script.
Have you noticed that DML on tables residing in SYSTEM tablespace is slower than tables in other tablespaces?
Here’s an example, I’ll create two similar tables, one in USERS tablespace, other in [...]
I haven’t written a non-Oracle post into my blog yet, so here’s one for you I recently developed a little web service with a friend. Shortly, check out http://n.otepad.com and any feedback is appreciated (especially about the parts which suck, so we could improve those The longer story is that for years I used to [...]