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 varchar2
as
l_query long;
l_char varchar2(1);
l_in_quotes boolean default FALSE;
begin
for i in 1 .. length( p_query )
loop
l_char := substr(p_query,i,1);
if ( l_char = '' and l_in_quotes )
then
l_in_quotes := FALSE;
elsif ( l_char = '' and NOT l_in_quotes )
then
l_in_quotes := TRUE;
l_query := l_query || '
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 varchar2
as
l_query long;
l_char varchar2(1);
l_in_quotes boolean default FALSE;
begin
for i in 1 .. length( p_query )
loop
l_char := substr(p_query,i,1);
if ( l_char = '' and l_in_quotes )
then
l_in_quotes := FALSE;
elsif ( l_char = '' and NOT l_in_quotes )
then
l_in_quotes := TRUE;
l_query := l_query || '
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/94317/viewspace-794159/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
最新文章
- Problem to connect as SYSDBA(zt from asktom)
- relation between consistent gets and arraysize(zt from asktom)
- about tune db cache
- DIFFERENCES BETWEEN PROCESSES, SESSIONS AND CONNECTIONS(zt from asktom)
- Calling Export from Pl/sql using C external proc
- sql to get data from flat file(zt from asktom)
- how tom write pagenation sql
- DIAGNOSING AND RESOLVING ORA-04031 ERROR
- about date manipulation(zt asktom)
- 不要和陌生人喝酒(安全警告)
