发布时间:2005-03-28 13:43:16

Lbrary cache latch contention is typically caused by NOT using bind variables.  It is due to excessive parsing of statements.One way to see if this might be the case in your situation is to run a script like:create table t1 as select sql_text from v$sqlarea;alter table t1 add sql_text_wo_constants varchar2(1000);create or replace function remove_constants( p_query in varchar2 ) return varchar2as    l_query long;    l_char  varchar2(1);    l_......【阅读全文】

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

发布时间:2005-03-27 17:29:58

The finaly question becomes what is worse for perforamnce,is simple -- "doing things to protect programmers, who are paid to write code for money and do it right, is the worst thing you can do for performance"In my world -- views are implemented for single use things. When I build a view, it is for an application. I tend to not use a generic view for everything. I create a view much like people create subroutines -- for a PURPOSE.So, i will pick neither of 1 or 2 from your first l......【阅读全文】

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

发布时间:2005-03-24 01:07:43

Setting up multiple Listeners I. Setting up Two Listeners for one Instance Same Machine Main Listener file is located in %ORACE_HOME%networkADMIN directory. Default listener filename is listener.ora. To add multiple listeners, listener name, ie must first add in the listener.ora file. Then start the listerner from listerner.ora. In this example, listeners are located in the same machine. Sample two listeners configuration ......【阅读全文】

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

发布时间:2005-03-23 11:17:56

http://www.mail-archive.com/oracle-l@fatcity.com/msg90348.htmlThis makes sense if you think about where the various v$ dynamic performance views get their info from, and which Oracle background process is responsible for each task. First, note that: 1. v$log.status gets its redo log info from the *control file* 2. v$datafile_header.checkpoint_change# and checkpoint_time get their info from the *datafile headers*. Here's the sequence of events when a log switch happens: 1. ......【阅读全文】

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

发布时间:2005-03-22 23:29:59

You Asked (Jump to Tom's latest followup)Hi Tom,We have a busy OLTP database that shares many schemas for many applications. A workflow application has a dbms job that runs every 5 minutes. Here is what it does:1. delete from <a wide de-normalized summary table>;2. insert into <this de-normalized summary table> select * from <a code table>, < inline view with sum(case when..) as period1,... ... sum(case when ...) as period10, c......【阅读全文】

阅读(1834) | 评论(0) | 转发(0)
给主人留下些什么吧!~~

jametong2014-06-27 16:58

http://lvyou.elong.com/laogt2/tour/a2r0cnvf.html
http://lvyou.elong.com/laogt2/tour/a2rfco0f.html
http://lvyou.elong.com/laogt2/tour/a2r7co1c.html
http://lvyou.elong.com/laogt2/tour/a2r0co27.html

回复  |  举报
留言热议
请登录后留言。

登录 注册