Home » RDBMS Server » Performance Tuning » Latch:Library Cache (Solaris 10, 10.2.0.1 DB)
Latch:Library Cache [message #407365] |
Tue, 09 June 2009 23:14 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
trantuananh24hg
Messages: 744 Registered: January 2007 Location: Ha Noi, Viet Nam
|
Senior Member |
|
|
Hi all!
I need your advice to resolve my problem
Latch Library Cache, the latching need to be resolved..
First time, I give you some information about our Database, OS and Server:
OS and Server are:
Last login: Wed Jun 10 09:01:01 2009 from 10.149.33.17
Sun Microsystems Inc. SunOS 5.10 Generic January 2005
You have new mail.
$ cat /etc/release
Solaris 10 11/06 s10s_u3wos_10 SPARC
Copyright 2006 Sun Microsystems, Inc. All Rights Reserved.
Use is subject to license terms.
Assembled 14 November 2006
$ psrinfo -v
Status of virtual processor 0 as of: 06/10/2009 10:29:54
on-line since 04/14/2009 17:19:07.
The sparcv9 processor operates at 1800 MHz,
and has a sparcv9 floating point processor.
Status of virtual processor 2 as of: 06/10/2009 10:29:54
on-line since 04/14/2009 17:19:03.
The sparcv9 processor operates at 1800 MHz,
and has a sparcv9 floating point processor.
Status of virtual processor 16 as of: 06/10/2009 10:29:54
on-line since 04/14/2009 17:19:07.
The sparcv9 processor operates at 1800 MHz,
and has a sparcv9 floating point processor.
Status of virtual processor 18 as of: 06/10/2009 10:29:54
on-line since 04/14/2009 17:19:07.
The sparcv9 processor operates at 1800 MHz,
and has a sparcv9 floating point processor.
$ prtconf | grep "Memory size"
Memory size: 16384 Megabytes
$
Database is:
logvnp@VNP> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bi
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for Solaris: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production
logvnp@VNP> show parameter sga
NAME TYPE VALUE
------------------------------------ -------------------------------- ----------
lock_sga boolean FALSE
pre_page_sga boolean FALSE
sga_max_size big integer 9G
sga_target big integer 9G
logvnp@VNP> show parameter pga
NAME TYPE VALUE
------------------------------------ -------------------------------- ----------
pga_aggregate_target big integer 4G
logvnp@VNP>
Second, please review TopEvents in Statspack:
Quote: |
06-Jun-09 11:57 10.2.0.1.0 NO
Host Name: database Num CPUs: 4
Phys Memory (MB): 16,301
~~~~
Snapshot Snap Id Snap Time Sessions Curs/Sess Comment
~~~~~~~~ ---------- ------------------ -------- --------- -------------------
Begin Snap: 121 09-Jun-09 13:00:03 128 184.7
End Snap: 125 09-Jun-09 17:00:02 143 125.5
Elapsed: 239.98 (mins)
Cache Sizes Begin End
~~~~~~~~~~~ ---------- ----------
Buffer Cache: 6,240M Std Block Size: 8K
Shared Pool Size: 2,912M
Log Buffer: 13,994K
Load Profile Per Second Per Transaction
~~~~~~~~~~~~ --------------- ---------------
Redo size: 28,827.77 12,134.33
Logical reads: 5,655.32 2,380.47
Block changes: 152.09 64.02
Physical reads: 25.17 10.60
Physical writes: 27.52 11.58
User calls: 104.05 43.80
Parses: 58.22 24.51
Hard parses: 18.21 7.66
Sorts: 19.46 8.19
Logons: 0.11 0.05
Executes: 157.95 66.48
Transactions: 2.38
% Blocks changed per Read: 2.69 Recursive Call %: 85.62
Rollback per transaction %: 0.40 Rows per Sort: 310.53
Instance Efficiency Percentages
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Buffer Nowait %: 100.00 Redo NoWait %: 100.00
Buffer Hit %: 99.88 In-memory Sort %: 100.00
Library Hit %: 94.76 Soft Parse %: 68.73
Execute to Parse %: 63.14 Latch Hit %: 99.52
Parse CPU to Parse Elapsd %: 21.65 % Non-Parse CPU: 72.84
Shared Pool Statistics Begin End
------ ------
Memory Usage %: 97.32 92.16
% SQL with executions>1: 38.33 45.09
% Memory for SQL w/exec>1: 72.91 74.94
Top 5 Timed Events Avg %Total
~~~~~~~~~~~~~~~~~~ wait Call
Event Waits Time (s) (ms) Time
----------------------------------------- ------------ ----------- ------ ------
latch: library cache 213,626 23,478 110 46.6
CPU time 11,499 22.8
latch: shared pool 123,523 7,200 58 14.3
latch: row cache objects 4,873 2,763 567 5.5
enq: TM - contention 554 1,619 2923 3.2
-------------------------------------------------------------
Host CPU (CPUs: 4)
~~~~~~~~ Load Average
Begin End User System Idle WIO WCPU
------- ------- ------- ------- ------- ------- --------
0.40 0.88
22.31 1.95 75.74 0.00 1.42
Instance CPU
~~~~~~~~~~~~
% of total CPU for Instance:
19.92
% of busy CPU for Instance:
82.11
%DB time waiting for CPU - Resource Mgr:
0.00
Memory Statistics Begin End
~~~~~~~~~~~~~~~~~ ------------ ------------
Host Mem (MB): 16,301.5 16,301.5
SGA use (MB): 9,216.0 9,216.0
PGA use (MB): 925.0 793.2
% Host Mem used for SGA+PGA: 62.2 61.4
-------------------------------------------------------------
|
I had 23478(s) for latching (library cache), 11499(s) for CPU activity, and 7200(s) with latch shared pool. Now, I post one by one step to detect.
1. _cursors_ parameter
logvnp@VNP> show parameter session_cach
NAME TYPE VALUE
------------------------------------ -------------------------------- ----------
session_cached_cursors integer 200
logvnp@VNP> show parameter cursor
NAME TYPE VALUE
------------------------------------ -------------------------------- ----------
cursor_sharing string SIMILAR
cursor_space_for_time boolean FALSE
open_cursors integer 4000
session_cached_cursors integer 200
logvnp@VNP>
How many cursors have been being opened?
logvnp@VNP> select max(a.value) "highest_open_cur",
2 p.value "max_open_cur"
3 from v$sesstat a, v$statname b, v$parameter p
4 where a.statistic#=b.statistic#
5 and b.name='opened cursors current'
6 and p.name='open_cursors'
7 group by p.value
8 /
highest_open_cur max_open_cur
---------------------- -----------------------------------
4000 505
logvnp@VNP>
2. Finding literal SQL
logvnp@VNP> col "SQL" format a50
logvnp@VNP> select substr(sql_text,1,80) "SQL", count(*), sum(executions) "TotEx
ecs"
2 from v$sqlarea
3 where executions<5
4 group by substr(sql_text,1,80)
5 having count(*)>30
6 order by 2
7 /
SQL COUNT(*) TotExecs
-------------------------------------------------- ---------- ----------
begin :1:=CCS_ADMIN.pttb_thtoan.laytt_hdld('thuatn 31 62
t_pyn','PYN','CCS_PYN.','PYN-L
begin :1 := CCS_ADMIN.pttb_dhanh.phan_dvth_hdld('m 31 31
aittt_qbh','QBH','CCS_QBH.','A
begin :1 := CCS_ADMIN.pttb_thtoan.gachno_hdld('mai 32 32
ttt_qbh','QBH','CCS_QBH.','QBH
begin :1:=CCS_ADMIN.pttb_thtoan.laytt_hdld('maittt 32 32
_qbh','QBH','CCS_QBH.','QBH-LD
begin :1:= CCS_ADMIN.pttb_capnhat.capnhat_kh_pttb1 32 32
('chau_tpu_bte','BTE','CCS_BTE
UPDATE CCS_BTE.khachhangs_pttb SET ma_cq = :1 34 34
,coquan = :2 ,ten_t
begin :1:= CCS_ADMIN.pttb_capnhat.layds_thuebao('c 34 38
hau_tpu_bte','BTE','CCS_BTE.',
begin :1 := CCS_ADMIN.PTTB_LAPHD.capnhat_hdphatsin 34 34
h('ngall_hcm','HCM','CCS_HCM.'
begin :1 := CCS_ADMIN.pttb_laphd.laytt_tb_ps('ngal 34 41
l_hcm','HCM','CCS_HCM.',0,'','
begin :1 := CCS_ADMIN.pttb_laphd.laytt_tb_ps('ngal 35 36
l_hcm','HCM','CCS_HCM.',0,'HCM
begin :1 :=CCS_ADMIN.pttb_hthd.hoanthanhhd_ps('nga 35 35
ll_hcm','HCM','CCS_HCM.','HCM-
begin :1 := CCS_ADMIN.pttb_laphd.laytt_tb_ps('huon 36 43
gntn_hcm','HCM','CCS_HCM.',0,'
begin :1:=CCS_ADMIN.pttb_thtoan.layds_tbld('maittt 38 73
_qbh','QBH','CCS_QBH.','QBH-LD
begin :1:= CCS_ADMIN.pttb_capnhat.laytt_kh('chau_t 39 41
pu_bte','BTE','CCS_BTE.','ma_k
begin :1:=CCS_ADMIN.pttb_thtoan.laytt_hdld_theo_ma 39 45
tb('maittt_qbh','QBH','CCS_QBH
begin :1:= CCS_ADMIN.qltn_baocao.cuoingay_huy( '05 40 54
2009', '10/06/2009', '10/06/20
UPDATE CCS_PYN.HOPDONG_LDS SET TRANGTHAIHD_ID =:1, 40 40
ngay_tt=:2 WHERE MA_HD = 'PYN
begin :1 := CCS_ADMIN.baocao.thuebaoda_tc('CCS_BLU 44 44
.','bdt_nttam_blu','052009','1
begin :1:= CCS_ADMIN.qltn_baocao.cuoingay( '052009 44 58
', '10/06/2009', '10/06/2009',
UPDATE CCS_PYN.THUEBAO_LDS SET phieu_id =:1,Trang 44 44
Thai = :2,ngay_tt=:3,Tien_DaTT
INSERT INTO LICHSU_DULIEU_CT (THAYDOI_ID,TEN_TRUON 45 121
G,GIATRI_CU,GIATRI_MOI) VALUES
UPDATE CCS_QBH.THUEBAO_LDS SET phieu_id =:1,Trang 49 49
Thai = :2,ngay_tt=:3,Tien_DaTT
UPDATE CCS_QBH.HOPDONG_LDS SET TRANGTHAIHD_ID =:1, 49 49
ngay_tt=:2 WHERE MA_HD = 'QBH
begin :1:=CCS_ADMIN.qltn.laytt_tienphieu_gachno('0 50 93
52009','10/06/2009','CCS_HNI.'
begin :1 := CCS_ADMIN.pttb_hthd.chuyendb_hdld('hts 55 55
uong_dng','DNG','CCS_DNG.','DN
begin :1:=CCS_ADMIN.pttb_thtoan.laytt_hdld('htsuon 59 119
g_dng','DNG','CCS_DNG.','DNG-L
select count(*) from CCS_GLI.khachhangs_052009 69 110
where ma_kh in ('
begin :1:=CCS_ADMIN.util.layds_thamso_hethong_rows 70 117
et('DONVI_CHUQUAN,DONVI_THUCHI
begin :1:=CCS_ADMIN.qltn.laytt_tienphieu_gachno('0 73 152
52009','10/06/2009','CCS_HCM.'
select 0 phieu_id, hd.MA_NV, hd.MA_HD,hd.MA_KH , 78 131
hd.TEN_TT ,hd.DIACHI_TT,hd.TA
select count(*) from CCS_HGG.khachhangs_042009 86 203
where ma_kh in ('
SELECT * FROM ( SELECT c.PHO_ 86 160
ID dieukien, c.TENPHO ten
select no.* from (select to_char(nogoc_dk+thue_dk, 91 155
qltn.lay_fm(ct.loaitien_id)) n
select rownum row_stt, c.* from (select * from (SE 95 125
LECT kh.ten_tt, tra.ma_tb soma
select * from (select MA_HD,MA_KH,trim(hd.TEN_TT) 112 192
TEN_TT,trim(hd.NGUOI_DD) NGUOI
select DISTINCT no.*,kh.ma_cq,replace(kh.ten_tt,:" 120 251
SYS_B_00",:"SYS_B_01") ten_tt,
select max(ten_tt) ten_tt, 199 281
max(diachi_tt) diachi_tt,
select distinct qltn_tamthu.chuanhoa_string(kh.ten 252 329
_tt) ten_tt, qlt
select count(*) from CCS_HNI.khachhangs_052009 280 559
where ma_kh in ('
select lower('user_'||al.name) name, nvl(cf.ATT 1061 1692
RIBUTE_VALUE,' ') value from
40 rows selected.
3. Checking hash chain lengths
logvnp@VNP> select hash_value, count(*)
2 from v$sqlarea
3 group by hash_value
4 having count(*)>5
5 /
no rows selected
logvnp@VNP>
4. Finding the Library Cache Hit Ratio
logvnp@VNP> select sum(pins) "Executions", sum(reloads) "Cache misses while executing"
2 from v$librarycache
3 /
Executions Cache misses while executing
---------- ----------------------------
71404979 1230709
logvnp@VNP> select 1230709/71404979 "LibCacheHitRatio"
2 from dual;
LibCacheHitRatio
----------------
.017235619
logvnp@VNP>
5. Measuring Library Cache Efficiency
logvnp@VNP> select namespace, pins, pinhits, reloads
2 from v$librarycache
3 order by namespace
4 /
NAMESPACE PINS PINHITS RELOADS
--------------- ---------- ---------- ----------
BODY 8750994 8738328 11392
CLUSTER 47207 47182 10
INDEX 35737 29659 119
JAVA DATA 629 625 0
JAVA RESOURCE 24 0 0
JAVA SOURCE 40 0 0
OBJECT 0 0 0
PIPE 989 987 0
SQL AREA 32959741 30343455 1164736
TABLE/PROCEDURE 29486202 29349337 50212
TRIGGER 190702 181836 7758
11 rows selected.
logvnp@VNP>
6. Version count
logvnp@VNP> spool version_count.lst replace
logvnp@VNP> spool off
logvnp@VNP> host cat version_count.lst
logvnp@VNP> select address, hash_value, version_count, users_opening, users_executing,
2 substr(sql_text,1,80) "SQL"
3 from v$sqlarea
4 where version_count>10
5 /
ADDRESS HASH_VALUE VERSION_COUNT USERS_OPENING USERS_EXECUTING SQL
---------------- ---------- ------------- ------------- --------------- --------------------------------------------------
00000005234165C8 3502506059 405 24 0 select * from (select hinhthuctt_ids,qltn_tamthu.l
aytt_ngaycuocnong(:"SYS_B_0")
0000000505617760 4185391734 25 0 0 select DISTINCT no.*,kh.ma_cq,replace(kh.ten_tt,:"
SYS_B_00",:"SYS_B_01") ten_tt,
00000005230D0440 2072773545 11 1 0 INSERT INTO LICHSU_DULIEU_CT (THAYDOI_ID,TEN_TRUON
G,GIATRI_CU,GIATRI_MOI) VALUES
000000051CAFB340 1342702645 12 0 0 SELECT rownum stt,x.* FROM ( SELECT tennganhang_u
ser, ten_dv_user, ten_rpt_user
00000005258D7088 4096132442 90 22 0 select count(*) from all_tables where owner=:"SYS_
B_0" and table_name=:"SYS_B_1"
00000005126645A8 1567622849 11 0 0 select DISTINCT no.*,kh.ma_cq,replace(kh.ten_tt,:"
SYS_B_00",:"SYS_B_01") ten_tt,
0000000525FBE148 3996518564 528 79 0 select * from (SELECT Phuong_ID dieukien, TenPhuo
ng ten FROM CCS_COMMON.Phuongs
000000050FAD4EC8 2376599727 1315 17 0 SELECT a.loai,a.so_tb,MA_TINH, trang_thai FROM cc
s_common.thue_bao a WHERE a.s
0000000525C64478 213387525 15 0 0 INSERT INTO CCS_BNH.thuebao_lds (NGUOI_CN,DONVIQL_
ID,SO_NHA,THUTU_IN,SOSIM,MA_TB
0000000525D564D0 1012534846 19 0 0 INSERT INTO LICHSU_DULIEU_CT (THAYDOI_ID,TEN_TRUON
G,GIATRI_CU,GIATRI_MOI) VALUES
0000000523E52718 373427890 12 1 0 INSERT INTO LICHSU_DULIEU_CT (THAYDOI_ID,TEN_TRUON
G,GIATRI_CU,GIATRI_MOI) VALUES
00000005230CF900 3443527674 11 0 0 INSERT INTO LICHSU_DULIEU_CT (THAYDOI_ID,TEN_TRUON
G,GIATRI_CU,GIATRI_MOI) VALUES
0000000525CC6F08 3772911657 772 5 0 SELECT MA_KH,TEN_TB,LOAITB_ID,TEN_DB, INCHITIET, k
ieubc_id FROM (SELECT db.ma_k
0000000508415320 2618168360 13 0 0 select :"SYS_B_000" STT, null ma_hd, null somay,
null ma_kh, null ten_tt
0000000523D9ED58 2143294840 266 1 0 select count(:"SYS_B_0") from CCS_TNH.danhba_dds_
pttb where ma_kh=:"SYS_B_1"
0000000525B7DB60 1154356767 506 0 0 select nvl(count(:"SYS_B_0"),:"SYS_B_1") from CCS_
BNH.khachhangs_pttb where ma_k
0000000511B25FD0 3063027617 230 1 0 select count(:"SYS_B_0") from CCS_LSN.danhba_dds_p
ttb a where a.somay=:"SYS_B_1
000000050383B6B8 838473822 44 0 0 select DISTINCT no.*,kh.ma_cq,replace(kh.ten_tt,:"
SYS_B_00",:"SYS_B_01") ten_tt,
0000000525D33F98 1406278106 615 2 0 select count(:"SYS_B_0") from CCS_QNH.danhba_dds_
pttb where ma_kh=:"SYS_B_1"
00000005113E5BE0 912792142 12 0 0 select null ngay_goi, null bigoi, null gio_goi,nu
ll ten_vung, null tg_goi, null
0000000511593478 1547705148 195 0 0 select DISTINCT no.*,kh.ma_cq,replace(kh.ten_tt,:"
SYS_B_00",:"SYS_B_01") ten_tt,
0000000503D09298 2734562357 102 0 0 select DISTINCT no.*,kh.ma_cq,replace(kh.ten_tt,:"
SYS_B_00",:"SYS_B_01") ten_tt,
000000051C914EE8 1011752322 11 0 0 select count(:"SYS_B_0") from CCS_LAN.danhba_dds_
pttb where ma_kh=:"SYS_B_1"
00000005233FDAA8 2939297427 70 2 0 select donviql_id from CCS_HCM.users where name=:"
SYS_B_0"
0000000509D09E48 655630039 987 12 0 select a.ma_tinh from ccs_common.thue_bao a where
a.so_tb=:"SYS_B_0"
0000000525F70498 2477138001 12 3 0 INSERT INTO LICHSU_DULIEU_CT (THAYDOI_ID,TEN_TRUON
G,GIATRI_CU,GIATRI_MOI) VALUES
00000005166E4D68 2104107198 14 0 0 select DISTINCT no.*,kh.ma_cq,replace(kh.ten_tt,:"
SYS_B_00",:"SYS_B_01") ten_tt,
00000005252B3108 4256309482 80 3 0 SELECT MA_TN FROM CCS_HNI.NGUOIGACHNOS WHERE NGUO
IGACH=:"SYS_B_0"
0000000513263B18 1906846155 94 1 0 UPDATE CCS_QTI.hopdong_lds SET trangthaihd_id=:"SY
S_B_0",ngay_cn=sysdate WHERE m
00000005010F07A0 3950520927 15 0 0 SELECT count(*) FROM ccs_common.ls_cuoc
WHERE so_tb = :
0000000506762190 1571433303 11 0 0 UPDATE CCS_QNI.hopdong_lds SET trangthaihd_id=:"SY
S_B_0",ngay_cn=sysdate WHERE m
0000000503E1B120 3166973127 19 0 0 select DISTINCT no.*,kh.ma_cq,replace(kh.ten_tt,:"
SYS_B_00",:"SYS_B_01") ten_tt,
00000005255E6E60 1263414491 12 0 0 select * from (SELECT a.ROWID || :"SYS_B_0" rid, a
.thuebao_id, a.ma_tb,a.ma_hd,
00000005239E8B20 441462027 14 3 0 SELECT A.NGAY_KH FROM SUBADMIN.ACTIVE@DB_2_NSA A W
HERE A.SO_TB =:B1 AND ROWNUM<2
0000000508DDED68 2215784252 11 1 0 select * from (select chuky_km, chuky from (select
substr(table_name,:"SYS_B_00"
0000000525B40188 2040541498 20 0 0 SELECT MA_BC FROM CCS_BNH.NGUOIGACHNOS WHERE (MOD
(FLOOR(NVL(GACHHT,:"SYS_B_0")/
000000050826D738 3312071098 82 0 0 select ma_tb from CCS_QNI.thuebao_lds a where a.ma
_hd=:"SYS_B_0"
000000050E38EA28 2940744182 19 0 0 select DISTINCT no.*,kh.ma_cq,replace(kh.ten_tt,:"
SYS_B_00",:"SYS_B_01") ten_tt,
000000050E720050 2720281152 11 1 0 SELECT COUNT(:"SYS_B_0") FROM CCS_THA.hopdong_pss
WHERE ma_tb= :"SYS_B_1" and tr
000000051C3E2E98 3256365659 13 0 0 INSERT INTO CCS_HNI.HOPDONG_PSS (ma_hd,NGAY_LAPHD,
trangthaihd_id,coquan,ten_tt,d
00000005253A5890 3844879105 12 0 0 select nvl(count(:"SYS_B_0"),:"SYS_B_1") from CCS_
LSN.danhba_dds_pttb where soma
0000000512D195C0 405550490 564 0 0 select distinct ct.ma_tb from CCS_HCM.ct_tra_05200
9 ct, CCS_
00000005253C77A8 1939486454 17 5 0 INSERT INTO CCS_HCM.HOPDONG_PSS (ma_hd,NGAY_LAPHD,
trangthaihd_id,coquan,ten_tt,d
000000051652F2B0 3673045430 595 0 0 SELECT :"SYS_B_00" kieulay, :"SYS_B_01" ten_db, ma
_kh, :"SYS_B_02" ma_tb,:"SYS_B
00000005BE463EB0 882654042 730 0 0 select count(:"SYS_B_0") from CCS_BNH.danhba_dds_p
ttb a where a.somay=:"SYS_B_1
0000000525D55990 3999939594 19 0 0 INSERT INTO LICHSU_DULIEU_CT (THAYDOI_ID,TEN_TRUON
G,GIATRI_CU,GIATRI_MOI) VALUES
0000000517B75F98 2460761716 11 0 0 select tb.rowid||:"SYS_B_00" rid,tb.kieuld_id kieu
ld_id,trim(tb.MA_TB) MA_TB,tb.
0000000525D58960 146685796 19 0 0 INSERT INTO LICHSU_DULIEU_CT (THAYDOI_ID,TEN_TRUON
G,GIATRI_CU,GIATRI_MOI) VALUES
0000000523E8FC38 1207189366 31 2 0 INSERT INTO LICHSU_DULIEU_CT (THAYDOI_ID,TEN_TRUON
G,GIATRI_CU,GIATRI_MOI) VALUES
00000005BE4E78C0 3658760292 155 1 0 select * from (SELECT a.ROWID || :"SYS_B_0" rid, a
.thuebao_id, a.ma_tb,a.ma_hd,
00000005259CF1A0 3867426930 19 0 0 Update CCS_BNH.QUANLYPHIEUS Set SOPHIEU = :"SYS_B_
0" WHERE (MA_TN = :"SYS_B_1")
000000050650A6E8 3088597127 211 72 0 select ma_tb from CCS_BTE.thuebao_lds a where a.ma
_hd=:"SYS_B_0"
0000000525E9B870 1930051819 177 0 0 select count(:"SYS_B_0") from CCS_HCM.khachhangs
_pttb a where a.ma_cq =:"SYS_B
0000000525B444C8 1751138999 19 0 0 SELECT MA_TN FROM CCS_BNH.NGUOIGACHNOS WHERE NGUO
IGACH=:"SYS_B_0"
00000005BE14BF98 1262502843 13 0 0 select mc.cuoc_tb from CCS_NAN.bangcuoc_tbs bc
,CCS_NAN.muccuoc_tbs mc wher
000000051F9ACB30 3152692223 19 2 0 select count(:"SYS_B_0") from CCS_QTI.danhba_dds_p
ttb a where a.somay=:"SYS_B_1
0000000516754530 1016611852 545 1 0 select nvl(count(:"SYS_B_0"),:"SYS_B_1") from CCS_
PYN.danhba_dds_pttb where soma
0000000525198340 4106372866 42 2 0 Update CCS_HNI.QUANLYPHIEUS Set SOPHIEU = :"SYS_B_
0" WHERE (MA_TN = :"SYS_B_1")
0000000516A3B438 934168839 431 1 0 select count(:"SYS_B_0") from CCS_PYN.danhba_dds_
pttb where ma_kh=:"SYS_B_1"
0000000505A373B0 3723774286 11 0 0 select DISTINCT no.*,kh.ma_cq,replace(kh.ten_tt,:"
SYS_B_00",:"SYS_B_01") ten_tt,
000000051AF36820 2736146898 55 0 0 select count(:"SYS_B_0") from CCS_DNG.danhba_dds_
pttb where ma_kh=:"SYS_B_1"
0000000509B030D8 2322221641 12 0 0 select nvl(count(:"SYS_B_0"),:"SYS_B_1") from CCS_
SLA.khachhangs_pttb where ma_k
00000005BE7D71B0 4125641360 20 164 0 select obj#,type#,ctime,mtime,stime,status,dataobj
#,flags,oid$, spare1, spare2 f
00000005BE7C44E0 1682066536 13 6 0 select user#,type# from user$ where name=:1
00000005118BD3F8 1433554498 54 0 0 select DISTINCT no.*,kh.ma_cq,replace(kh.ten_tt,:"
SYS_B_00",:"SYS_B_01") ten_tt,
0000000525BF0518 403459781 11 0 0 INSERT INTO LICHSU_DULIEU_CT (THAYDOI_ID,TEN_TRUON
G,GIATRI_CU,GIATRI_MOI) VALUES
000000051A547FB8 1575243622 154 0 0 SELECT nvl(TBTT,:"SYS_B_0"), nvl(KHAC,:"SYS_B_1")
FROM (
0000000513CD0B90 2904445029 27 0 0 select rownum row_stt, c.* from (SELECT ph.ma_kh,
kh.sodaidien, kh.ms_thue, kh.t
000000052525CAA8 2985185388 1129 0 0 select max(ten_tt) ten_tt,
max(diachi_tt) diachi_tt,
0000000525375DD8 3467400244 11 0 0 INSERT INTO LICHSU_DULIEU_CT (THAYDOI_ID,TEN_TRUON
G,GIATRI_CU,GIATRI_MOI) VALUES
0000000506AE9180 114185472 277 0 0 select count(:"SYS_B_0") from CCS_THA.danhba_dds_p
ttb a where a.somay=:"SYS_B_1
000000051D84FD00 4223030572 14 0 0 select * from (select hinhthuctt_ids,qltn_tamthu.l
aytt_ngaycuocnong(:"SYS_B_0")
00000005161B80B8 4259075612 11 0 0 SELECT ph.Ma_kh, ph.Ma_tb, Kh.Ten_tt, ph.soseri ph
ieu_Id, to_char(ph.Ngaynhap,:"
000000050FB15A98 2936952367 43 1 0 select * from (SELECT a.ROWID || :"SYS_B_0" rid, a
.thuebao_id, a.ma_tb,a.ma_hd,
0000000525D5B0C0 2330613420 19 0 0 INSERT INTO LICHSU_DULIEU_CT (THAYDOI_ID,TEN_TRUON
G,GIATRI_CU,GIATRI_MOI) VALUES
0000000525BFFE18 3378797646 59 0 0 Update CCS_HCM.QUANLYPHIEUS Set SOPHIEU = :"SYS_B_
0" WHERE (MA_TN = :"SYS_B_1")
00000005129B62F0 1084907013 14 0 0 select count(*) from all_tables@DBL_2_BILLING wher
e owner=:"SYS_B_0"
000000051A7A3F70 3098041923 12 0 0 UPDATE CCS_LAN.hopdong_lds SET trangthaihd_id=:"SY
S_B_0",ngay_cn=sysdate WHERE m
0000000506E302F8 2548588137 14 0 0 select db.ma_kh,db.somay,kh.donviql_id from CCS_HC
M.khachhangs_pttb kh,
00000005258E0858 2596429911 13 0 0 select mc.cuoc_tb from CCS_BNH.bangcuoc_tbs bc
,CCS_BNH.muccuoc_tbs mc wher
00000005255F72D8 950689938 14 1 0 INSERT INTO CCS_HNI.hopdong_lds (ma_hd,
ma_kh, loaikh_id, dichvuvt_id
000000050382AF38 1479304802 26 0 0 select DISTINCT no.*,kh.ma_cq,replace(kh.ten_tt,:"
SYS_B_00",:"SYS_B_01") ten_tt,
0000000523E25838 946497352 93 50 0 update sequences set max_id=:"SYS_B_0" where tense
q=:"SYS_B_1"
0000000523B3E8E0 3584059631 11 0 0 SELECT nvl(TBTT,:"SYS_B_0"), nvl(KHAC,:"SYS_B_1")
FROM (
00000005258E6F38 2059430557 506 0 0 select count(:"SYS_B_0") from CCS_BNH.danhba_dds_
pttb where ma_kh=:"SYS_B_1"
000000050C1DDEF8 874671194 97 1 0 select nvl(count(:"SYS_B_0"),:"SYS_B_1") from CCS_
QTI.khachhangs_pttb where ma_k
000000052316AF20 4110576874 11 0 0 INSERT INTO LICHSU_DULIEU_CT (THAYDOI_ID,TEN_TRUON
G,GIATRI_CU,GIATRI_MOI) VALUES
000000050C6B4F78 668888493 21 0 0 select * from (select hinhthuctt_ids,qltn_tamthu.l
aytt_ngaycuocnong(:"SYS_B_0")
00000005121D9C00 3311168960 27 0 0 select tenquay,maquay from CCS_HCM.quaythus where
:"SYS_B_0"=:"SYS_B_1" and inst
000000051CC5E7C0 3609751036 11 0 0 SELECT ld.ten_tb ,SUBSTR(ld.diachi,:"SYS_B_00",le
ngth(ld.diachi)-:"SYS_B_01") d
00000005231F79F0 695889811 113 13 0 select * from (select seri,quyen,soseri from CCS_H
NI.nguoigachnos where nguoigac
0000000523793AE8 2923720806 16 0 0 select bct.tenbuucuc,bct.donviql_id ,ng.
hovaten ,ng.seri,ng.quyen,
000000051DCA23D0 930378058 43 3 0 select text,line from sys.dba_source where owner=:
"SYS_B_0" and name=:"SYS_B_1"
0000000525F93080 1274049687 65 1 0 select * from (select hinhthuctt_ids,qltn_tamthu.l
aytt_ngaycuocnong(:"SYS_B_0")
00000005090F9600 2884400290 25 0 0 select rownum row_stt, c.* from (SELECT a.ma_t, a.
ten_t,a.ma_nv, b.ten_nv,a.ma_b
0000000503C1A6B8 2294707945 879 21 0 SELECT nvl(TBTT,:"SYS_B_0"), nvl(KHAC,:"SYS_B_1")
FROM (
0000000523856658 117733557 700 1 0 select upper(al.name) name, cf.ATTRIBUTE_VALUE
from sys_attribute_config
0000000505A0BBE0 2058648122 14 0 0 SELECT count(:"SYS_B_0") FROM CCS_BDG.nhanvien_tc
s WHERE ma_nv=:"SYS_B_1"
0000000523C6E310 1397259169 81 7 0 SELECT count(:"SYS_B_0") FROM CCS_PYN.nhanvien_tc
s WHERE ma_nv=:"SYS_B_1"
00000005230D0170 359169005 11 1 0 INSERT INTO LICHSU_DULIEU_CT (THAYDOI_ID,TEN_TRUON
G,GIATRI_CU,GIATRI_MOI) VALUES
000000051F86BB20 509115831 23 0 0 SELECT count(:"SYS_B_0") FROM CCS_BTE.tuyens WHE
RE ma_t=:"SYS_B_1"
0000000513F1D670 1959558743 33 0 0 select trim(to_char(nvl(sum(nogoc+thue-hoahong),:"
SYS_B_0"),:"SYS_B_1")) ||:"SYS
000000050893DE50 3020718254 11 0 0 select DISTINCT no.*,kh.ma_cq,replace(kh.ten_tt,:"
SYS_B_00",:"SYS_B_01") ten_tt,
00000005251C1620 2799730866 12 1 0 INSERT INTO CCS_HNI.thuebao_lds (NGUOI_CN,DONVIQL_
ID,SO_NHA,THUTU_IN,SOSIM,MA_TB
000000052580A888 903643912 49 0 0 SELECT CASE WHEN a.inchitiet = :"SYS_B_0" THEN b.
NAME WHEN a.inchitiet = :"SYS_
000000051230A210 904038020 15 0 0 select DISTINCT no.*,kh.ma_cq,replace(kh.ten_tt,:"
SYS_B_00",:"SYS_B_01") ten_tt,
00000005BE452158 2463794891 138 1 0 select * from (select hd.MA_HD, hd.MA_CQ ,hd.TEN_T
T,hd.DIACHI_TT,hd.DICHVUVT_ID,
0000000523F56520 1168148356 14 0 0 select donviql_id from CCS_NAN.users where name=:"
SYS_B_0"
0000000525D5BED0 3665201101 18 0 0 INSERT INTO LICHSU_DULIEU_CT (THAYDOI_ID,TEN_TRUON
G,GIATRI_CU,GIATRI_MOI) VALUES
0000000525D5A2B0 240814571 19 1 0 INSERT INTO LICHSU_DULIEU_CT (THAYDOI_ID,TEN_TRUON
G,GIATRI_CU,GIATRI_MOI) VALUES
000000052528F150 2093779454 51 0 0 select distinct qltn_tamthu.chuanhoa_string(kh.ten
_tt) ten_tt, qlt
0000000512D77AB0 1147702214 48 0 0 select nvl(count(:"SYS_B_0"),:"SYS_B_1") from CCS_
BPC.khachhangs_pttb where ma_k
0000000525BDB500 2925825295 86 1 0 SELECT MA_TN FROM CCS_HCM.NGUOIGACHNOS WHERE NGUO
IGACH=:"SYS_B_0"
0000000523E52CB8 3349319290 36 2 0 INSERT INTO LICHSU_DULIEU_CT (THAYDOI_ID,TEN_TRUON
G,GIATRI_CU,GIATRI_MOI) VALUES
000000051F86B6D0 2891354086 12 0 0 select donviql_id from CCS_BTE.users where name=:"
SYS_B_0"
000000050FE058F0 3407253848 87 0 0 select decode(grouping(muc),:"SYS_B_00",muc) muc,
sum(dec
000000050FEE7980 877564732 17 1 0 Update CCS_TNN.phieu_032009 ph set tiengiao = nvl(
tiengiao,sotien) Where luotgia
0000000525D55C60 3155202994 19 0 0 INSERT INTO LICHSU_DULIEU_CT (THAYDOI_ID,TEN_TRUON
G,GIATRI_CU,GIATRI_MOI) VALUES
0000000525D669E0 161387568 22 0 0 INSERT INTO LICHSU_DULIEU_CT (THAYDOI_ID,TEN_TRUON
G,GIATRI_CU,GIATRI_MOI) VALUES
000000052514C7E8 1471714603 13 0 0 INSERT INTO CCS_QBH.hopdong_lds (ma_hd,
ma_kh, loaikh_id, dichvuvt_id
0000000509806E70 1141675381 97 1 0 select ma_kh,trangthaihd_id from CCS_QTI.hopdong_l
ds where ma_hd=:"SYS_B_0"
0000000525C61E50 1593481136 61 40 0 INSERT INTO LICHSU_DULIEU (THAYDOI_ID,TEN_BANG,ID,
NGAY_CN,THAOTAC_ID,NGUOI_CN,MA
00000005BEB10CF0 417503201 11 25 0 SELECT agent_id from ccs_common.AGENT where schema
= :a
0000000525BAABD0 3513686088 449 3 0 select count(:"SYS_B_0") from CCS_HPG.danhba_dds_p
ttb a where a.somay=:"SYS_B_1
0000000525595760 283679941 19 0 0 select DISTINCT no.*,kh.ma_cq,replace(kh.ten_tt,:"
SYS_B_00",:"SYS_B_01") ten_tt,
0000000503BAA400 2729090521 11 0 0 select DISTINCT no.*,kh.ma_cq,replace(kh.ten_tt,:"
SYS_B_00",:"SYS_B_01") ten_tt,
0000000523E904A8 2268651 49 20 0 INSERT INTO LICHSU_DULIEU (THAYDOI_ID,TEN_BANG,ID,
NGAY_CN,THAOTAC_ID,NGUOI_CN,MA
000000051ADEA4C0 1055956759 32 2 0 SELECT MA_KH,TEN_TB,LOAITB_ID FROM (SELECT db.ma_k
h,TRIM(db.ten_tb) ten_tb,db.lo
000000050FF36780 267952369 18 0 0 select DISTINCT no.*,kh.ma_cq,replace(kh.ten_tt,:"
SYS_B_00",:"SYS_B_01") ten_tt,
000000051261FCE8 1390587851 48 0 0 select count(:"SYS_B_0") from CCS_BPC.danhba_dds_
pttb where ma_kh=:"SYS_B_1"
000000051D8E56A0 1774628854 11 0 0 SELECT MA_TN FROM CCS_SLA.NGUOIGACHNOS WHERE NGUO
IGACH=:"SYS_B_0"
0000000525EDB580 1654829211 132 1 0 SELECT (cuoc_ld-nvl(tien_km,:"SYS_B_0")), vat_l
d, nvl(cuoc_dv,:"SYS_B_1"), nv
0000000515871B60 1335669267 11 0 0 select rownum row_stt, c.* from (SELECT a.phieu_id
, a.ma_kh, a.ma_tb, TO_CHAR (a
000000051AC79A80 1208400585 341 0 0 select count(:"SYS_B_0") from CCS_HUE.danhba_dds_p
ttb a where a.somay=:"SYS_B_1
00000005116F9388 3194666038 24 0 0 select :"SYS_B_00" ten_nv,:"SYS_B_01" ten_t, TO_C
HAR (SUM (NVL (tiengiao, sotie
0000000523E8F698 2834480928 31 2 0 INSERT INTO LICHSU_DULIEU_CT (THAYDOI_ID,TEN_TRUON
G,GIATRI_CU,GIATRI_MOI) VALUES
0000000523E57038 1361101143 38 2 0 INSERT INTO LICHSU_DULIEU_CT (THAYDOI_ID,TEN_TRUON
G,GIATRI_CU,GIATRI_MOI) VALUES
00000005135EEF90 2481505759 24 0 0 select DISTINCT no.*,kh.ma_cq,replace(kh.ten_tt,:"
SYS_B_00",:"SYS_B_01") ten_tt,
0000000525071BC0 2339817004 12 1 0 INSERT INTO CCS_QNH.thuebao_lds (NGUOI_CN,DONVIQL_
ID,SO_NHA,THUTU_IN,SOSIM,MA_TB
0000000525C182C0 3650406136 31 0 0 select * from (select CCS_ADMIN.qltn.lay_ckn_hient
ai(:"SYS_B_0",:"SYS_B_1") chuk
000000051A762DB0 2203502376 30 2 0 SELECT MA_BC FROM CCS_BDG.NGUOIGACHNOS WHERE (MOD
(FLOOR(NVL(GACHHT,:"SYS_B_0")/
000000051D8A7910 2025899962 11 0 0 SELECT :"SYS_B_0" MA_HD,TRIM(DB.DIACHI_TT) DIACHI
_TT_CU,TRIM(DB.MA_KH) MAKH_CU,
00000005257ECBE0 1119275051 973 1 0 select count(:"SYS_B_0") from CCS_BDG.danhba_dds_p
ttb a where a.somay=:"SYS_B_1
00000005238A0088 2596456709 19 1 0 select count(:"SYS_B_0") from all_tables
where table_name =:"
0000000525610B48 3163867562 329 3 0 select MA_KH FROM CCS_HCM.danhba_dds_pttb where so
may=:"SYS_B_0"
000000051C35D2B0 348834283 16 1 0 SELECT rpad(RPAD(SUBSTR (table_name, :"SYS_B_00",:
"SYS_B_01"),:"SYS_B_02",:"SYS_
00000005234FEF38 837995388 155 1 0 select * from (select a.USERID, a.LDAP_CHECK, a.US
ER_NAME, to_char(a.DOB,:"SYS_B
0000000525FC4DB0 1534905683 90 38 0 select * from (SELECT a.tenquan ten, a.quan_id die
ukien FROM CCS_COMMON.quans a
00000005233AB7D8 3226652335 25 4 0 select donviql_id from CCS_QNH.users where name=:"
SYS_B_0"
00000005BE5573F0 1290325911 702 0 0 select count(:"SYS_B_0") from CCS_TNH.danhba_dds_p
ttb a where a.somay=:"SYS_B_1
000000052566D630 3020345395 189 15 0 update CCS_HCM.khachhangs_pttb a set co
quan = (select coquan_m
000000051CE63F18 155504699 13 4 0 SELECT ten,cd.chucdanh_id FROM ccs_common.danhmuc
_tenseps dm,CCS_BDG.chucdanhs
0000000525BDBCD8 2048447184 86 1 0 SELECT MA_BC FROM CCS_HCM.NGUOIGACHNOS WHERE (MOD
(FLOOR(NVL(GACHHT,:"SYS_B_0")/
000000050E9EE4B0 2422266054 13 0 0 SELECT ph.ma_kh, ph.ma_tb, qltn.c
font_utokhongdau(kh.ten_tt) te
000000051D44A570 1768741815 166 0 0 select nvl(count(:"SYS_B_0"),:"SYS_B_1") from CCS_
BDG.danhba_dds_pttb where soma
0000000525E563E0 2439044090 94 32 0 select * from (SELECT a.ten_htkm ,a.khuyenmai_id
FROM ccs_common.hinhthuc_km_t
00000005BE296250 345956420 13 1 0 SELECT MA_TN FROM CCS_QTI.NGUOIGACHNOS WHERE NGUO
IGACH=:"SYS_B_0"
00000005231B2330 80406021 770 5 0 SELECT nvl(count(:"SYS_B_0"),:"SYS_B_1") from ccs
_common.KETNOI_CATMO KC WHERE
00000005236B8F70 616883850 23 1 0 SELECT count(:"SYS_B_0") FROM CCS_TQG.nhanvien_tc
s WHERE ma_nv=:"SYS_B_1"
0000000525B42C60 2982471354 324 1 0 select nvl(count(:"SYS_B_0"),:"SYS_B_1") from CCS_
TNH.danhba_dds_pttb where soma
0000000525E87FA0 3022972670 141 0 0 SELECT count(:"SYS_B_0") FROM CCS_BNH.nhanvien_tc
s WHERE ma_nv=:"SYS_B_1"
0000000525780E28 2515855285 105 0 0 Select :"SYS_B_0" from CCS_HCM.QUYENLV a where H
UY = :"SYS_B_1" AND name =
000000051D1BA598 3715950572 37 7 0 select donviql_id from CCS_BDG.users where name=:"
SYS_B_0"
00000005133EB208 4128303666 13 0 0 SELECT ma_kh, MAX (ma_tb) ma_tb,
to_char(SUM (DECODE (kieuno,
00000005BE587180 4238928581 605 1 0 select count(:"SYS_B_0") from CCS_QNH.danhba_dds_p
ttb a where a.somay=:"SYS_B_1
000000050111AA60 1384180497 45 0 0 select to_char(a.ngay_ld,:"SYS_B_0") thang_ld from
CCS_BTE.danhba_dds_pttb a whe
0000000525D35078 179760616 16 3 0 select mc.cuoc_tb from CCS_QNH.bangcuoc_tbs bc
,CCS_QNH.muccuoc_tbs mc wher
0000000523164D28 765652599 284 52 0 Select :"SYS_B_0" from CCS_HCM.QUYENLV a where H
UY = :"SYS_B_1"
000000050F6B2578 157740793 14 0 0 SELECT count(:"SYS_B_0") FROM CCS_BDG.tuyens WHE
RE ma_t=:"SYS_B_1"
00000005230D0CB0 3739938731 11 1 0 INSERT INTO LICHSU_DULIEU_CT (THAYDOI_ID,TEN_TRUON
G,GIATRI_CU,GIATRI_MOI) VALUES
00000005052015D8 4225167383 11 0 0 select DISTINCT no.*,kh.ma_cq,replace(kh.ten_tt,:"
SYS_B_00",:"SYS_B_01") ten_tt,
0000000525BEF708 3199791641 11 1 0 INSERT INTO LICHSU_DULIEU_CT (THAYDOI_ID,TEN_TRUON
G,GIATRI_CU,GIATRI_MOI) VALUES
00000005230CFEA0 35320668 11 1 0 INSERT INTO LICHSU_DULIEU_CT (THAYDOI_ID,TEN_TRUON
G,GIATRI_CU,GIATRI_MOI) VALUES
00000005255A5078 2144662411 156 0 0 select tb.rowid||:"SYS_B_00" rid,tb.kieuld_id kieu
ld_id,trim(tb.MA_TB) MA_TB,tb.
000000052312ECA0 1900868698 291 34 0 select * from (select seri,quyen,soseri from CCS_H
CM.nguoigachnos where nguoigac
0000000525D5D550 2768696674 19 0 0 INSERT INTO LICHSU_DULIEU_CT (THAYDOI_ID,TEN_TRUON
G,GIATRI_CU,GIATRI_MOI) VALUES
0000000525D5AB20 2488596424 19 0 0 INSERT INTO LICHSU_DULIEU_CT (THAYDOI_ID,TEN_TRUON
G,GIATRI_CU,GIATRI_MOI) VALUES
00000005051215D8 2882467905 12 0 0 SELECT (cuoc_ld-nvl(tien_km,:"SYS_B_0")), vat_l
d, nvl(cuoc_dv,:"SYS_B_1"), nv
0000000508586DF8 3565092686 16 0 0 select DISTINCT no.*,kh.ma_cq,replace(kh.ten_tt,:"
SYS_B_00",:"SYS_B_01") ten_tt,
000000050516A470 3640065917 2305 214 0 select * from (SELECT nvl(display_main,:"SYS_B_0")
display_main from user_info a
00000005BE344008 3072786993 129 0 0 update CCS_QTI.hopdong_lds set sodaidien=:"SYS_B_0
" where ma_hd = :"SYS_B_1"
000000051A4D26C8 559612981 15 0 0 select mc.cuoc_tb from CCS_BDG.bangcuoc_tbs bc
,CCS_BDG.muccuoc_tbs mc wher
0000000505BFFBE8 723846242 13 0 0 select distinct decode(a.thao_tac,:"SYS_B_00",:"S
YS_B_01",:"SYS_B_02") dat,deco
000000050662CDD8 1847002620 829 5 0 select count(:"SYS_B_0") from CCS_HCM.danhba_dds_p
ttb a where a.somay=:"SYS_B_1
0000000505F12528 3980462340 69 0 0 select DISTINCT no.*,kh.ma_cq,replace(kh.ten_tt,:"
SYS_B_00",:"SYS_B_01") ten_tt,
000000051C56D988 3689351712 16 0 0 SELECT MA_KH,TEN_TB,LOAITB_ID FROM (SELECT db.ma_k
h,TRIM(db.ten_tb) ten_tb,db.lo
0000000525B95598 2836597347 35 0 0 select * from (select userid id,userid name from C
CS_ADMIN.user_info a where a.a
0000000525185678 1371605668 313 1 0 select * from (SELECT to_char(a.ngay_laphd,:"SYS_B
_00") ngay, to_char(a.ngay_lap
00000005BE69A378 3275427458 11 5 0 select name,password,datats#,tempts#,type#,defrole
,resource$, ptime, exptime, lt
00000005179DE560 3529445548 17 1 0 UPDATE CCS_TNN.phieu_032009 cp SET cp.ngaygiao =
TO_DATE (:"SYS_B_00", :"SYS_B
0000000512E44F68 1214452344 11 0 0 SELECT nvl(count(:"SYS_B_0"),:"SYS_B_1") from CCS_
LAN.THUEBAO_LDS WHERE trangtha
00000005251D05A0 732107616 78 2 0 select donviql_id from CCS_HNI.users where name=:"
SYS_B_0"
0000000525D5ADF0 302323713 19 0 0 INSERT INTO LICHSU_DULIEU_CT (THAYDOI_ID,TEN_TRUON
G,GIATRI_CU,GIATRI_MOI) VALUES
0000000525E87C28 1690507967 22 2 0 select donviql_id from CCS_BNH.users where name=:"
SYS_B_0"
00000005116C80F0 623713090 11 0 0 select distinct to_char(ngay_thuc,:"SYS_B_0") from
CCS_BDG.bangphieutra_052009 w
00000005250783F0 3245153311 42 2 0 select mc.cuoc_tb from CCS_HNI.bangcuoc_tbs bc
,CCS_HNI.muccuoc_tbs mc wher
0000000517820B10 1642536261 40 0 0 select DISTINCT no.*,kh.ma_cq,replace(kh.ten_tt,:"
SYS_B_00",:"SYS_B_01") ten_tt,
00000005054EF9C8 23141781 94 0 0 SELECT TRANGTHAIHD_ID From CCS_QTI.hopdong_lds Whe
re ma_hd =:"SYS_B_0"
0000000523302460 3017088647 625 4 0 update CCS_HCM.khachhangs_pttb a set te
n_tt = (select ten_tt_m
0000000523930CB0 3330613108 237 17 0 select * from (select hinhthuctt_ids,qltn_tamthu.l
aytt_ngaycuocnong(:"SYS_B_0")
ADDRESS HASH_VALUE VERSION_COUNT USERS_OPENING USERS_EXECUTING SQL
---------------- ---------- ------------- ------------- --------------- --------------------------------------------------
00000005238EFD88 3695910970 12 5 0 select nguoigach,nguoigach ten from CCS_HCM.nguoig
achnos where
00000005112E0AF8 876159169 99 0 0 select ma_tb from CCS_HCM.thuebao_lds a where a.ma
_hd=:"SYS_B_0"
0000000525F6C740 1925652852 12 0 0 UPDATE CCS_DNI.tuyens SET ten_t=:"SYS_B_0", ma_nv=
:"SYS_B_1", ma_bc=:"SYS_B_2",
000000051AE0AF30 551101421 50 0 0 SELECT COUNT(:"SYS_B_0") FROM CCS_DNI.tuyens WHERE
ma_t=:"SYS_B_1"
000000051CA2DB68 3885311519 18 0 0 select DISTINCT no.*,kh.ma_cq,replace(kh.ten_tt,:"
SYS_B_00",:"SYS_B_01") ten_tt,
000000051ACC46D8 87893972 68 5 0 select * from (select hinhthuctt_ids from CCS_HNI.
nguoigachnos where nguoigach=:
00000005114EEAD8 1277765874 17 0 0 select count(:"SYS_B_0") from CCS_PYN.danhba_dds_p
ttb a where a.somay=:"SYS_B_1
000000052316BA60 214903139 66 34 0 INSERT INTO LICHSU_DULIEU_CT (THAYDOI_ID,TEN_TRUON
G,GIATRI_CU,GIATRI_MOI) VALUES
000000050955D508 3727503977 17 0 0 select DISTINCT no.*,kh.ma_cq,replace(kh.ten_tt,:"
SYS_B_00",:"SYS_B_01") ten_tt,
0000000501894350 2084516700 17 0 0 select DISTINCT no.*,kh.ma_cq,replace(kh.ten_tt,:"
SYS_B_00",:"SYS_B_01") ten_tt,
0000000525D55F30 2402628546 22 0 0 INSERT INTO LICHSU_DULIEU_CT (THAYDOI_ID,TEN_TRUON
G,GIATRI_CU,GIATRI_MOI) VALUES
00000005230CF360 1644902656 11 0 0 INSERT INTO LICHSU_DULIEU_CT (THAYDOI_ID,TEN_TRUON
G,GIATRI_CU,GIATRI_MOI) VALUES
00000005BE296758 901856039 12 1 0 SELECT MA_BC FROM CCS_QTI.NGUOIGACHNOS WHERE (MOD
(FLOOR(NVL(GACHHT,:"SYS_B_0")/
000000051CBE0E80 3784129375 30 2 0 SELECT MA_TN FROM CCS_BDG.NGUOIGACHNOS WHERE NGUO
IGACH=:"SYS_B_0"
000000051F9CB8C8 1129397095 1092 0 0 select distinct qltn_tamthu.chuanhoa_string(kh.ten
_tt) ten_tt, qlt
000000052316B790 756891145 12 2 0 INSERT INTO LICHSU_DULIEU_CT (THAYDOI_ID,TEN_TRUON
G,GIATRI_CU,GIATRI_MOI) VALUES
0000000525CA2B80 1970749808 20 1 0 select bct.tenbuucuc,bct.donviql_id ,ng.
hovaten ,ng.seri,ng.quyen,
000000051A93AD78 3579396671 11 0 0 select no.* from (select to_char(nogoc_dk+thue_dk,
qltn.lay_fm(ct.loaitien_id)) n
000000050337DBB8 2231190390 12 0 0 select DISTINCT no.*,kh.ma_cq,replace(kh.ten_tt,:"
SYS_B_00",:"SYS_B_01") ten_tt,
000000052316B1F0 1755137632 12 4 0 INSERT INTO LICHSU_DULIEU_CT (THAYDOI_ID,TEN_TRUON
G,GIATRI_CU,GIATRI_MOI) VALUES
0000000525D6F978 2095007368 70 3 0 select * from (select hinhthuctt_ids,qltn_tamthu.l
aytt_ngaycuocnong(:"SYS_B_0")
00000005132605E8 440616709 19 0 0 SELECT ma_kh, :"SYS_B_0" ma_tb,:"SYS_B_1" loaitb_i
d, :"SYS_B_2" ma_hd,:"SYS_B_3"
00000005230CF630 380716975 11 0 0 INSERT INTO LICHSU_DULIEU_CT (THAYDOI_ID,TEN_TRUON
G,GIATRI_CU,GIATRI_MOI) VALUES
0000000525374FC8 2550351857 11 0 0 INSERT INTO LICHSU_DULIEU_CT (THAYDOI_ID,TEN_TRUON
G,GIATRI_CU,GIATRI_MOI) VALUES
0000000523C6E040 2613136108 21 11 0 select donviql_id from CCS_PYN.users where name=:"
SYS_B_0"
000000051C6FFCE0 1655393055 12 0 0 select sum(cuoc_ld-nvl(tien_km,:"SYS_B_0")+vat_ld
+nvl(VAT_DV,:"SYS_B_1")+nvl(CU
0000000513F64630 695815115 17 0 0 select DISTINCT no.*,kh.ma_cq,replace(kh.ten_tt,:"
SYS_B_00",:"SYS_B_01") ten_tt,
0000000523E575D8 438783055 14 1 0 INSERT INTO LICHSU_DULIEU_CT (THAYDOI_ID,TEN_TRUON
G,GIATRI_CU,GIATRI_MOI) VALUES
000000052322E2D0 4127149168 168 8 0 Select :"SYS_B_0" from CCS_HNI.QUYENLV a where H
UY = :"SYS_B_1"
0000000525375568 1955024245 11 0 0 INSERT INTO LICHSU_DULIEU_CT (THAYDOI_ID,TEN_TRUON
G,GIATRI_CU,GIATRI_MOI) VALUES
00000005178ADDF8 691883385 33 0 0 select DISTINCT no.*,kh.ma_cq,replace(kh.ten_tt,:"
SYS_B_00",:"SYS_B_01") ten_tt,
00000005036656A8 3479654742 11 1 0 SELECT MA_KH,TEN_TB,LOAITB_ID,TEN_DB, INCHITIET, k
ieubc_id FROM (SELECT db.ma_k
00000005255FC888 3326431810 76 2 0 SELECT count(:"SYS_B_0") FROM CCS_HNI.nhanvien_tc
s WHERE ma_nv=:"SYS_B_1"
000000051A9D6650 672486022 11 0 0 select sum(cuoc_ld-nvl(tien_km,:"SYS_B_0")+vat_ld
+nvl(VAT_DV,:"SYS_B_1")+nvl(CU
000000050C181F30 1942573796 877 0 0 select ma_bc from CCS_HNI.user_buucuc where userid
=:"SYS_B_0"
00000005BE203890 3180025847 133 0 0 select sodaidien from CCS_QTI.hopdong_lds where ma
_hd = :"SYS_B_0"
0000000525819B60 2441697933 17 2 0 Update CCS_QNH.QUANLYPHIEUS Set SOPHIEU = :"SYS_B_
0" WHERE (MA_TN = :"SYS_B_1")
0000000505CFC400 4251409161 73 0 0 select qltn.chukyno_dangchu(chukyno,null,null)||:"
SYS_B_0"||to_char(sum(tragoc+t
0000000525F72388 3988740989 29 11 0 INSERT INTO LICHSU_DULIEU (THAYDOI_ID,TEN_BANG,ID,
NGAY_CN,THAOTAC_ID,NGUOI_CN,MA
0000000525D57880 325933961 20 0 0 INSERT INTO LICHSU_DULIEU_CT (THAYDOI_ID,TEN_TRUON
G,GIATRI_CU,GIATRI_MOI) VALUES
00000005BE1DEE38 3271908678 201 0 0 select count(:"SYS_B_0") from ccs_common.thue_bao
a where a.so_tb=:"SYS_B_1" and
0000000523791FF0 139681896 132 1 0 select sum(cuoc_ld-nvl(tien_km,:"SYS_B_0")+vat_ld
+nvl(VAT_DV,:"SYS_B_1")+nvl(CU
00000005090F30D0 655057060 98 1 0 select nvl(count(:"SYS_B_0"),:"SYS_B_1") from CCS_
QTI.danhba_dds_pttb where soma
00000005258DD828 2621662213 507 0 0 select nvl(count(:"SYS_B_0"),:"SYS_B_1") from CCS_
BNH.danhba_dds_pttb where soma
00000005134E0580 1000696813 244 0 0 select count(*) tongsobl, to_char(
sum(nvl(replace(sotienhuy,:"SY
0000000525375298 3105320132 11 0 0 INSERT INTO LICHSU_DULIEU_CT (THAYDOI_ID,TEN_TRUON
G,GIATRI_CU,GIATRI_MOI) VALUES
000000050FD2EDC8 1722511488 728 18 0 select nvl(count(:"SYS_B_0"),:"SYS_B_1") from ccs
_common.KETNOI_CATMO KC where
0000000525D58C30 484668042 19 0 0 INSERT INTO LICHSU_DULIEU_CT (THAYDOI_ID,TEN_TRUON
G,GIATRI_CU,GIATRI_MOI) VALUES
00000005BE737EE0 3159716790 17 91 0 select i.obj#,i.ts#,i.file#,i.block#,i.intcols,i.t
ype#,i.flags,i.property,i.pctf
0000000525375B08 3666179400 11 0 0 INSERT INTO LICHSU_DULIEU_CT (THAYDOI_ID,TEN_TRUON
G,GIATRI_CU,GIATRI_MOI) VALUES
0000000523E54608 3141106001 13 6 0 INSERT INTO LICHSU_DULIEU_CT (THAYDOI_ID,TEN_TRUON
G,GIATRI_CU,GIATRI_MOI) VALUES
000000051AD245C0 256867576 222 0 0 select count(:"SYS_B_0") from CCS_TNN.danhba_dds_p
ttb a where a.somay=:"SYS_B_1
000000051DBC5350 3717956441 11 0 0 SELECT (cuoc_ld-nvl(tien_km,:"SYS_B_0")), vat_l
d, nvl(cuoc_dv,:"SYS_B_1"), nv
00000005237A1638 2648277887 235 3 0 SELECT MA_KH,TEN_TB,LOAITB_ID FROM (SELECT db.ma_k
h,TRIM(db.ten_tb) ten_tb,db.lo
0000000523E55C88 1305445571 41 11 0 INSERT INTO LICHSU_DULIEU_CT (THAYDOI_ID,TEN_TRUON
G,GIATRI_CU,GIATRI_MOI) VALUES
000000051F3DCF78 3915744955 18 0 0 select rownum row_stt, c.* from (SELECT a.phieu_id
, a.ma_kh, a.ma_tb, TO_CHAR (c
0000000506338450 2970847580 11 0 0 select to_char(sum(replace(sotien,:"SYS_B_00",:"SY
S_B_01") ),:"SYS_B_02") sotien
00000005259A4590 3576793708 19 0 0 select bct.tenbuucuc,bct.donviql_id ,ng.
hovaten ,ng.seri,ng.quyen,
00000005231BFC98 2292419844 13 1 0 SELECT a.loai,b.tra_sau, MA_TINH, trang_thai, a.g
oi_di, a.goi_den
000000052316B4C0 1405717793 11 2 0 INSERT INTO LICHSU_DULIEU_CT (THAYDOI_ID,TEN_TRUON
G,GIATRI_CU,GIATRI_MOI) VALUES
0000000503831408 3344404716 24 0 0 select DISTINCT no.*,kh.ma_cq,replace(kh.ten_tt,:"
SYS_B_00",:"SYS_B_01") ten_tt,
00000005253C91C8 4159017462 21 2 0 SELECT MA_TN FROM CCS_QNH.NGUOIGACHNOS WHERE NGUO
IGACH=:"SYS_B_0"
00000005BE2C86B0 746295884 26 0 0 SELECT DECODE (TRANG_THAI, 'SP', '1', '0'), DECODE
(GOI_DI, 'A', '1', '0'), DECO
000000051ACB4410 4214986466 13 3 0 Update CCS_PYN.QUANLYPHIEUS Set SOPHIEU = :"SYS_B_
0" WHERE (MA_TN = :"SYS_B_1")
0000000513CD25F0 1296537712 27 22 0 select * from (select a.luotgiao_id name,a.luotgia
o_id id from CCS_TNN.phieu_032
0000000516A3C118 3155138857 431 1 0 select nvl(count(:"SYS_B_0"),:"SYS_B_1") from CCS_
PYN.khachhangs_pttb where ma_k
0000000511979E40 3588725518 48 0 0 select nvl(count(:"SYS_B_0"),:"SYS_B_1") from CCS_
BPC.danhba_dds_pttb where soma
0000000523E8F968 3979320302 13 1 0 INSERT INTO LICHSU_DULIEU_CT (THAYDOI_ID,TEN_TRUON
G,GIATRI_CU,GIATRI_MOI) VALUES
000000051F5CEA90 1065328309 27 0 0 select tenbuucuc,ma_bc from CCS_HCM.buucucthus whe
re :"SYS_B_0"=:"SYS_B_1" and m
000000051A0EE9B0 357408522 191 0 0 select rownum row_stt, c.* from (select phieu_id,s
oseri,loaitien_id,httt_id,ma_k
00000005252B3D40 3114508562 84 3 0 SELECT MA_BC FROM CCS_HNI.NGUOIGACHNOS WHERE (MOD
(FLOOR(NVL(GACHHT,:"SYS_B_0")/
00000005BE3C29A8 3094848354 207 4 0 select * from (SELECT a.ROWID || :"SYS_B_0" rid, a
.thuebao_id, a.ma_tb,a.ma_hd,
00000005257FF550 1014342830 21 2 0 SELECT ten,cd.chucdanh_id FROM ccs_common.danhmuc
_tenseps dm,CCS_HNI.chucdanhs
0000000505F89188 42968673 31 0 0 select bct.tenbuucuc,bct.donviql_id ,ng.
hovaten ,ng.seri,ng.quyen,
0000000523E57308 2909645901 14 1 0 INSERT INTO LICHSU_DULIEU_CT (THAYDOI_ID,TEN_TRUON
G,GIATRI_CU,GIATRI_MOI) VALUES
0000000503405F60 3033640114 21 0 0 select DISTINCT no.*,kh.ma_cq,replace(kh.ten_tt,:"
SYS_B_00",:"SYS_B_01") ten_tt,
00000005087C3D90 174174484 23 0 0 select null ngay_goi, null bigoi, null gio_goi,nu
ll ten_vung, null tg_goi, null
000000052383D3F0 1082372748 12 1 0 INSERT INTO CCS_HCM.hopdong_lds (ma_hd,
ma_kh, loaikh_id, dichvuvt_id
0000000525374CF8 1272034047 11 0 0 INSERT INTO LICHSU_DULIEU_CT (THAYDOI_ID,TEN_TRUON
G,GIATRI_CU,GIATRI_MOI) VALUES
00000005BE4D78F8 2857743347 12 1 0 select mc.cuoc_tb from CCS_TNH.bangcuoc_tbs bc
,CCS_TNH.muccuoc_tbs mc wher
0000000523E8EE28 215463382 29 6 0 INSERT INTO LICHSU_DULIEU_CT (THAYDOI_ID,TEN_TRUON
G,GIATRI_CU,GIATRI_MOI) VALUES
000000051F274180 4112234416 55 0 0 select nvl(count(:"SYS_B_0"),:"SYS_B_1") from CCS_
DNG.khachhangs_pttb where ma_k
000000051C7FCFD0 1306245526 96 1 0 INSERT INTO CCS_QTI.khachhangs_pttb (CHUKY_ID,CHUY
ENNO,SO_GT,COQUAN,DANGKY_DB,DA
0000000525B00D38 2405808661 11 1 0 INSERT INTO LICHSU_DULIEU_CT (THAYDOI_ID,TEN_TRUON
G,GIATRI_CU,GIATRI_MOI) VALUES
0000000525D34808 1759230584 711 2 0 select nvl(count(:"SYS_B_0"),:"SYS_B_1") from CCS_
QNH.danhba_dds_pttb where soma
0000000525606F18 3251223327 33 13 0 select a.donviql_id from CCS_HNI.buucucthus a
where a.ma
000000050859B020 409975744 12 0 0 SELECT COUNT(:"SYS_B_0") FROM CCS_QNH.hopdong_pss
WHERE ma_tb= :"SYS_B_1" and tr
0000000523E8D4D8 2980166760 26 0 0 INSERT INTO LICHSU_DULIEU_CT (THAYDOI_ID,TEN_TRUON
G,GIATRI_CU,GIATRI_MOI) VALUES
00000005162E8410 1639169371 40 0 0 select rownum row_stt, c.* from (select * from (se
lect rownum stt,a.* from ( se
0000000523E54BA8 3084893571 36 3 0 INSERT INTO LICHSU_DULIEU_CT (THAYDOI_ID,TEN_TRUON
G,GIATRI_CU,GIATRI_MOI) VALUES
0000000525BD6700 1729347018 31 2 0 select donviql_id from CCS_TNH.users where name=:"
SYS_B_0"
0000000513E7F210 3319120363 40 0 0 select DISTINCT no.*,kh.ma_cq,replace(kh.ten_tt,:"
SYS_B_00",:"SYS_B_01") ten_tt,
000000050C1DE348 118342403 97 1 0 SELECT trim(sodaidien) FROM CCS_QTI.hopdong_lds W
HERE ma_hd=:"SYS_B_0"
000000052327A348 1293402920 12 28 0 SELECT COUNT (a.trigger_name) FROM all_triggers a,
all_objects b WHERE a.owner =
000000051D38DE88 2071708628 13 0 0 select * from (select hinhthuctt_ids,qltn_tamthu.l
aytt_ngaycuocnong(:"SYS_B_0")
0000000525D136A8 2891040371 96 0 0 select * from (select tenbuucuc,ma_bc from CCS_HCM
.buucucthus where donviql_id=
0000000525D59FE0 2555365101 19 0 0 INSERT INTO LICHSU_DULIEU_CT (THAYDOI_ID,TEN_TRUON
G,GIATRI_CU,GIATRI_MOI) VALUES
0000000525715388 306301106 14 0 0 SELECT ten,cd.chucdanh_id FROM ccs_common.danhmuc
_tenseps dm,CCS_NAN.chucdanhs
000000051F5CE5F8 3018443137 25 0 0 select count(:"SYS_B_0") from CCS_QNM.danhba_dds_p
ttb a where a.somay=:"SYS_B_1
0000000523256270 1126157643 21 1 0 select count(:"SYS_B_0") from CCS_BDH.danhba_dds_p
ttb a where a.somay=:"SYS_B_1
000000052577FD48 840421311 117 0 0 SELECT count(*) FROM CCS_HCM.bangphieutra_052009
where phi
00000005166698B0 1828050118 12 0 0 select donviql_id from CCS_SLA.users where name=:"
SYS_B_0"
00000005255F8870 2223363659 32 4 0 select a.donviql_id from CCS_HNI.buucucthus a w
here a.ma_bc=:"SYS_B_0"
000000052564AA20 1321064122 173 0 0 select count(:"SYS_B_0") from CCS_BPC.danhba_dds_p
ttb a where a.somay=:"SYS_B_1
000000050F0E56E0 3799767492 11 1 0 SELECT ten,cd.chucdanh_id FROM ccs_common.danhmuc
_tenseps dm,CCS_TNH.chucdanhs
000000052505CB80 1474157146 15 4 0 select donviql_id from CCS_QBH.users where name=:"
SYS_B_0"
0000000525375838 2889210487 11 0 0 INSERT INTO LICHSU_DULIEU_CT (THAYDOI_ID,TEN_TRUON
G,GIATRI_CU,GIATRI_MOI) VALUES
0000000525D5B390 2651708261 19 0 0 INSERT INTO LICHSU_DULIEU_CT (THAYDOI_ID,TEN_TRUON
G,GIATRI_CU,GIATRI_MOI) VALUES
0000000509417680 1285675936 23 0 0 select MA_KH FROM CCS_HCM.khachhangs_pttb where ma
_kh=:"SYS_B_0"
000000051F1AFDA8 2902580778 11 0 0 select DISTINCT no.*,kh.ma_cq,replace(kh.ten_tt,:"
SYS_B_00",:"SYS_B_01") ten_tt,
0000000525FE8380 1367990282 17 0 0 select ma_tb from CCS_HTH.thuebao_lds a where a.ma
_hd=:"SYS_B_0"
000000051C8D5A58 986571106 13 0 0 select * from (select thang, thangnam from ( selec
t substr(table_name,:"SYS_B_00
0000000513167348 1772348445 129 2 0 select round(sum(tien+vat)) from CCS_HCM.thdd_2009
06@DBL_2_BILLING where :"SYS_B
0000000523DA7218 3831752053 20 2 0 SELECT * FROM ( SELECT * FROM (SE
LECT RPAD (RPAD (SUBSTR (tab
00000005253E0670 3198674464 13 1 0 INSERT INTO CCS_QNH.hopdong_lds (ma_hd,
ma_kh, loaikh_id, dichvuvt_id
000000051A2A9F98 2186798917 13 3 0 update CCS_HNI.chuyenkhoans set phieu_id=null,ngay
_tt=null,trangthai=:"SYS_B_0"
00000005151BA2B0 2011162649 39 0 0 select nvl(count(:"SYS_B_0"),:"SYS_B_1") from CCS_
DLC.khachhangs_pttb where ma_k
000000050E4B9228 726526081 299 2 0 SELECT a.ma_kh,a.somay,a.khoanmuctc_id, b.ten_km,
a.cuoc, a.phut,a.tien tien_,a.
0000000525E86FE8 2011949295 22 0 0 INSERT INTO CCS_BNH.hopdong_lds (ma_hd,
ma_kh, loaikh_id, dichvuvt_id
0000000523E3C1D8 3853511006 194 0 0 Select decode(a.loai,:"SYS_B_00",:"SYS_B_01",:"SY
S_B_02",:"SYS_B_03",:"SYS_B_04
000000051397E3E8 3330796127 97 1 0 UPDATE CCS_QTI.HOPDONG_LDS SET trangthaihd_id =:"S
YS_B_0" WHERE ma_hd =:"SYS_B_1
000000051AEBA500 1800661821 22 2 0 Update CCS_BDG.QUANLYPHIEUS Set SOPHIEU = :"SYS_B_
0" WHERE (MA_TN = :"SYS_B_1")
000000051A7DB2C8 3998084194 290 2 0 select * from (SELECT a.ROWID || :"SYS_B_0" rid, a
.thuebao_id, a.ma_tb,a.ma_hd,
000000051AEEA140 1723330803 16 1 0 insert into CCS_COMMON.THUHO_052009 (
PHIEU_ID, LOAITIEN_ID, HTTT_ID
0000000523E29A50 1628566031 95 57 0 SELECT max_id FROM sequences where tenseq =:"SYS_B
_0"
0000000517D0E810 147977218 350 15 0 UPDATE ccs_common.ketnoi_catmo SET trangthaith_id
=:"SYS_B_0" WHERE ma_hd=:"SY
00000005094B4EC0 2241590448 21 0 0 select bct.tenbuucuc,bct.donviql_id ,ng.
hovaten ,ng.seri,ng.quyen,
00000005253C9498 532149769 26 2 0 SELECT MA_BC FROM CCS_QNH.NGUOIGACHNOS WHERE (MOD
(FLOOR(NVL(GACHHT,:"SYS_B_0")/
000000051CD68AB0 612104170 16 7 0 select :"SYS_B_00" ten_nv,:"SYS_B_01" ten_t, TO_C
HAR (SUM (NVL (tiengiao, sotie
000000052316C5A0 616299220 39 1 0 INSERT INTO LICHSU_DULIEU (THAYDOI_ID,TEN_BANG,ID,
NGAY_CN,THAOTAC_ID,NGUOI_CN,MA
00000005255D0E08 3789421838 96 1 0 select count(:"SYS_B_0") from CCS_QTI.danhba_dds_
pttb where ma_kh=:"SYS_B_1"
0000000525D34268 1906703771 615 2 0 select nvl(count(:"SYS_B_0"),:"SYS_B_1") from CCS_
QNH.khachhangs_pttb where ma_k
332 rows selected.
logvnp@VNP> spool off
6. Finding shared_pool memory & statements which use lot of memory
logvnp@VNP> select sum(bytes/1024/1024) "SharedPool by MB"
2 from v$sgastat
3 where pool='shared pool'
4 /
SharedPool by MB
----------------
2804.3588
1 row selected.
logvnp@VNP> select substr(sql_text,1,80) "Stmt", count(*),
2 sum(sharable_mem) "Mem",
3 sum(users_opening) "Open",
4 sum(executions) "Exec"
5 from v$sql
6 group by substr(sql_text,1,80)
7 having sum(sharable_mem)>2147483648
8 /
no rows selected
logvnp@VNP>
7. Parse
logvnp@VNP> select name, value
2 from v$sysstat
3 where name in ( 'parse time cpu', 'parse time elapsed','parse count (hard)'
, 'CPU used by this session' )
4 order by name desc
5 /
NAME VALUE
-------------------- ----------
parse time elapsed 9901039
parse time cpu 1570152
parse count (hard) 1986168
CPU used by this ses 9033009
sion
4 rows selected.
logvnp@VNP>
I attached the AWR in this post.
Thank you for any advice!
|
|
|
|
Re: Latch:Library Cache [message #407367 is a reply to message #407366] |
Tue, 09 June 2009 23:30 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
trantuananh24hg
Messages: 744 Registered: January 2007 Location: Ha Noi, Viet Nam
|
Senior Member |
|
|
First time, thank you for your reply, BlackSwan!
Second, some results which are LibraryCacheHitRatio, LibraryCacheEfficient.. was measured after I flush Shared_pool.
But..version count is still. Please keep a keen on your eyes to my AWR.
Thank you again!
|
|
|
|
Re: Latch:Library Cache [message #407369 is a reply to message #407367] |
Tue, 09 June 2009 23:36 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
trantuananh24hg
Messages: 744 Registered: January 2007 Location: Ha Noi, Viet Nam
|
Senior Member |
|
|
Yes, BlackSwan, I've read the article long time ago. One part in this article, Sr Thomas Kyte retrieved from his book "Effective Oracle by Design".
Anyway, thank you!
|
|
|
Re: Latch:Library Cache [message #407372 is a reply to message #407368] |
Tue, 09 June 2009 23:54 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
trantuananh24hg
Messages: 744 Registered: January 2007 Location: Ha Noi, Viet Nam
|
Senior Member |
|
|
Quote: |
>Parses: 58.22 24.51
From asktom:
This is a system that parses a lot of SQL--your system is parsing about 390 times per second. The good news is that the parses are mostly soft.
|
The good news may be not hard parses, but soft parses will be the evil if many, many sessions executes concurrently, am I wrong?
Quote: |
The only people who can reduce parses are the developers themselves.
|
Yes, I knew the problem was many parses to executions. Almost the statement in this AWR was parsed and executed through by Package/Procedure/Function. I've noted them and sent to our developers, but still 2 events made me wondering:
1. Why did the statement
SELECT sql_id, sql_text from v$sql WHERE sql_id in (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10)
caused the latch?
This statement belonged to OEM, retrieve top session, top sql and displayed into the Web.
13.93(s) per elapsed time. -->> very slow. It was apart from latch, wasn't it?
2. The developers told me: "Oap, our statement was pinned in packages, we though every variable were soft parse, we do not need to keep every thing in bind variable, would you prove the differences?"
Yes, I can use tkprof, dbms_monitor.session_trace_enable(xxx) to trace any statements, but I can not explain what it latch to them. They saw into the cpu_time,elasped_time, and said "0.02s, what's the hell you want from us more?"
Thank you for your advice!
[Updated on: Tue, 09 June 2009 23:58] Report message to a moderator
|
|
|
Goto Forum:
Current Time: Fri Aug 30 11:05:21 CDT 2024
|