|
You are here |
karenmorton.blogspot.com | ||
| | | | |
hemantoracledba.blogspot.com
|
|
| | | | | An Oracle Database DBA (Database Administration) Blog. | |
| | | | |
tanelpoder.com
|
|
| | | | | 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. - Linux, Oracle, SQL performance tuning and troubleshooting training & writing. | |
| | | | |
tanelpoder.com
|
|
| | | | | Advanced Oracle SQL Tuning, Troubleshooting and Linux Performance Training by Tanel Poder - Linux, Oracle, SQL performance tuning and troubleshooting training & writing. | |
| | | | |
littlekendra.com
|
|
| | | Kendra Little writes and draws comics about SQL Server, Data Platforms, and Database DevOps. | ||