Tanel Poder's blog: IT & Mobile for Geeks and Pros
Oracle, Exadata, Performance, Troubleshooting - Mobile Life and Productivity.
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” so I get the wanted page first in search results.
I’ve added the link into my blogroll.
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 pid: 5490, image: oracle@linux03 (PMON)
SQL>
Even though you probably don’t want to mess around with background processes in production DBs, in demos and just Oracle research it can help you save couple of seconds every now and then.
