DB Tuning
tech2011
这个作者很懒,什么都没留下…
展开
-
查询正在后台进行的SQL查询
<br />select sid,v$session.username 用户名,last_call_et 持续时间,status 状态,LOCKWAIT 等待锁,machine 用户电脑名,logon_time 开始登入时间,sql_text <br />from v$session,v$process ,v$sqlarea<br />where paddr=addr and sql_hash_value=hash_value<br />and status='ACTIVE' and v$session.u原创 2010-12-01 20:04:00 · 796 阅读 · 0 评论 -
CPU used by this session
<br /> select<br /> a.SID, c.serial#, c.username, c.osuser, c.MODULE, c.status, d.spid AS<br /> "PROCESS_ID", DECODE(c.username, NULL, 0, c.last_call_et) AS<br /> "SCNDS_IDLE", ((SYSDATE - c.logon_time) * 60 * 60 * 24) AS<br />原创 2010-10-26 16:59:00 · 1976 阅读 · 0 评论 -
oradebug
RAC checking - Hanganalyze and System State dump on 9iIf on 9i run the following on one instance 2-3 times - 1 minute apart:<br />------------------------------------------------------------------------------<br />SQL> oradebug setmypid<br />SQL> oradebug原创 2010-10-28 12:15:00 · 334 阅读 · 0 评论 -
接口日志跟踪
<br />create table DBAPROCLOG ( PROCEDURENAME VARCHAR2(60), PARAMS VARCHAR2(500), CALLTIME DATE default sysdate ) <br /> <br />insert into dbaproclog (procedurename, params, calltime) <br />values ('fn_xxx_get', ' Sip=' || sys_context('userenv', 'ip_addres原创 2010-11-08 14:30:00 · 328 阅读 · 0 评论 -
Active Session History at work
Performance Monitoring: Active Session History at work<br />Teaching an Oracle Database 10g Performance Tuning course this week, I introduced the 10g New Feature Active Session History (ASH) to the students. That was one major improvement – together with t原创 2011-02-23 16:49:00 · 286 阅读 · 0 评论 -
raid
RAIDRAID is an acronym for Redundant Arrays of Inexpensive Disks. These provide a mechanism for load balancing and securing your data across multiple disks. In this article I'll give a brief explanation of the most commonly used RAID levels and how they sh转载 2011-03-11 11:54:00 · 538 阅读 · 0 评论