• 博客访问: 132478
  • 博文数量: 68
  • 用 户 组: 普通用户
  • 注册时间: 2008-05-04 11:19
个人简介

暂无介绍

ITPUB论坛APP

ITPUB论坛APP



APP发帖 享双倍积分

文章分类
文章存档

2010年(35)

2009年(32)

2008年(1)

我的朋友
微信关注

IT168企业级官微



微信号:IT168qiye



系统架构师大会



微信号:SACC2013

订阅
热词专题

发布时间:2010-11-29 10:24:05

http://jobs.zhaopin.com/P2/CC2856/3311/J902/500/CC285633119J90250000000.htm?f=sshttp://jobs.zhaopin.com/P2/CC3377/7991/J902/500/CC337779913J90250015000.htm?f=sshttp://jobs.zhaopin.com/P2/CC2822/7761/J902/500/CC282277614J90250009000.htm?f=sshttp://jobs.zhaopin.com/P2/CC2770/1991/J902/500/CC277019912J90250005000.htm?f=sshttp://jobs.zhaopin.com/P2/CC2584/1471/J902/500/CC258414710J90250005000.htm?f=sshttp://jobs.zhaopin.com/P10/CC0001/8449/J900/001/CC000184490J90000147000.htm?f=ss[@more@]......【阅读全文】

阅读(851) | 评论(0) | 转发(0)

发布时间:2010-07-20 10:49:19

1:触发日志参数文件设置 EVENT "942 trace name ERRORSTACK level 3"当任何错误产生都会产生相应错误TRACE文件2:跟踪其他会话SQLObtain the Oracle process identifier or the Operating System process identifier (SPID) from v$process in an MTS environment: sqlplus /nolog SQL> connect / as sysdba SQL> select pid, spid from v$process p, v$shared_server s 2 where p.addr = s.paddr; PID SPID---------- ------------ 14 6976 2. Attach to t......【阅读全文】

阅读(831) | 评论(0) | 转发(0)

发布时间:2010-07-16 10:11:38

SUMMARY:First determine which latch id(ADDR) are interesting by examining the number of sleeps for this latch. The higher the sleep count, the more interesting the latch id(ADDR) is:SQL> select CHILD# "cCHILD" , ADDR "sADDR" , GETS "sGETS" , MISSES "sMISSES" , SLEEPS "sSLEEPS" from v$latch_children where name = 'cache buffers chains' order by 5, 1, 2, 3;Run the above query a few times ......【阅读全文】

阅读(3985) | 评论(0) | 转发(0)

发布时间:2010-07-07 16:58:16

If you've been developing applications on Oracle for a while, you've no doubt come across the concept of «Bind Variables». Bind variables are one of those Oracle concepts that experts frequently cite as being key to application performance, but it's often not all that easy to pin down exactly what they are and how you need to alter your programming style to use them. To understand bind variables, consider an application that generates thousands of SELECT statements against a table; f......【阅读全文】

阅读(1777) | 评论(0) | 转发(0)

发布时间:2010-07-07 11:36:59

Trevor -- Thanks for the question regarding "Parse CPU to Parse Elapsed", version 8.1.7Submitted on 1-Jun-2003 20:12 Central time zoneTom's latest followup | Bookmark | BottomLast updated 26-May-2010 7:38You Asked Hi Tom, I got given a statspack report to check out. The Parse CPU to Parse Elapsed seems terrible. In you book Expert 1 on 1 page 481 your example was 87.88% and you say for every CPU second it spent about 1.13 seconds of wall clock time. How did you work out 1.13 ......【阅读全文】

阅读(2300) | 评论(0) | 转发(0)
给主人留下些什么吧!~~
留言热议
请登录后留言。

登录 注册