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
trantuananh24hg
Messages: 668
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 #407366 is a reply to message #407365] Tue, 09 June 2009 23:24 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
http://www.oracle.com/technology/oramag/oracle/07-jul/o47asktom.html

[Updated on: Tue, 09 June 2009 23:27]

Report message to a moderator

Re: Latch:Library Cache [message #407367 is a reply to message #407366] Tue, 09 June 2009 23:30 Go to previous messageGo to next message
trantuananh24hg
Messages: 668
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 #407368 is a reply to message #407365] Tue, 09 June 2009 23:35 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
From your post
>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 only people who can reduce parses are the developers themselves.
Re: Latch:Library Cache [message #407369 is a reply to message #407367] Tue, 09 June 2009 23:36 Go to previous messageGo to next message
trantuananh24hg
Messages: 668
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
trantuananh24hg
Messages: 668
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

Previous Topic: very simple but very slow query
Next Topic: Performance Tuning in Count(DISTINCT
Goto Forum:
  


Current Time: Thu Dec 08 22:23:28 CST 2016

Total time taken to generate the page: 0.09681 seconds