oradebug / ora-00074 : oradebug dumpvar sga kcbatt_

issue: you got ora-00074 error when run oradebug in sqlplus

solution:
set up debug process

oradebug setmypid

example:

SQL> oradebug dumpvar sga kcbatt_
ORA-00074: no process has been specified
SQL> oradebug dumpvar sga kcbatt_
ORA-00074: no process has been specified
SQL> oradebug setmypid
Statement processed.
SQL> oradebug dumpvar sga kcbatt_
ub4 kcbatt_ [06001BA38, 06001BA3C) = 00000003

reference:
http://tech.e2sn.com/oracle/troubleshooting/hang/how-to-log-on-even-when-sysdba-can-t-do-so
http://blog.tanelpoder.com/2009/08/27/latch-cache-buffers-chains-latch-contention-a-better-way-for-finding-the-hot-block/