第一步、神级脚本snapper看
[oracle@hs-10-20-30-199 yc]$ ./ora snapper
./ora snapper "2023/07/20 09:11" 30
calc average active session
[oracle@hs-10-20-30-199 yc]$ ./ora snapper "2023/07/20 09:11" 30
PL/SQL procedure successfully completed.
Enter value for 4: Sampling SID with interval 5 seconds, taking 1 snapshots...
--------------------------------------------------------------------------------------------------------------------------------------------------
Active% | SID | USERNAME | MACHINE | SERVICE_NAME | SQL_ID | EVENT
--------------------------------------------------------------------------------------------------------------------------------------------------
100% | 10337 | FINDPT | hs-10-20-30-193 | SYS$USERS | 0wcuyc8xnz8q4 | library cache lock
100% | 9395 | FINDPT | hs-10-20-30-193 | SYS$USERS | 1mthwa5wrtha7 | library cache lock
100% | 7517 | FINDPT | hs-10-20-30-193 | SYS$USERS | 1mthwa5wrtha7 | library cache lock
100% | 16904 | FINDPT | hs-10-20-30-193 | SYS$USERS | 0wcuyc8xnz8q4 | library cache lock
100% | 7518 | FINDPT | hs-10-20-30-193 | SYS$USERS | 0wcuyc8xnz8q4 | library cache lock
100% | 4699 | FINDPT | hs-10-20-30-193 | SYS$USERS | 0wcuyc8xnz8q4 | library cache lock
100% | 3 | FINDPT | hs-10-20-30-193 | SYS$USERS | 1mthwa5wrtha7 | library cache lock
100% | 2823 | FINDPT | hs-10-20-30-193 | SYS$USERS | 0wcuyc8xnz8q4 | library cache lock
100% | 27237 | FINDPT | hs-10-20-30-193 | SYS$USERS | 0wcuyc8xnz8q4 | library cache lock
100% | 26297 | FINDPT | hs-10-20-30-193 | SYS$USERS | 1mthwa5wrtha7 | library cache lock
100% | 21599 | FINDPT | hs-10-20-30-193 | SYS$USERS | 1mthwa5wrtha7 | library cache lock
100% | 17845 | FINDPT | hs-10-20-30-193 | SYS$USERS | 0wcuyc8xnz8q4 | library cache lock
100% | 16907 | FINDPT | hs-10-20-30-193 | SYS$USERS | 1mthwa5wrtha7 | library cache lock
100% | 13153 | FINDPT | hs-10-20-30-193 | SYS$USERS | 0wcuyc8xnz8q4 | library cache lock
100% | 12213 | FINDPT | hs-10-20-30-193 | SYS$USERS | 1mthwa5wrtha7 | library cache lock
100% | 8454 | FINDPT | hs-10-20-30-193 | SYS$USERS | 0wcuyc8xnz8q4 | library cache lock
100% | 6582 | FINDPT | hs-10-20-30-193 | SYS$USERS | 0wcuyc8xnz8q4 | library cache lock
100% | 27236 | FINDPT | hs-10-20-30-193 | SYS$USERS | 1mthwa5wrtha7 | library cache lock
100% | 21602 | FINDPT | hs-10-20-30-193 | SYS$USERS | 0wcuyc8xnz8q4 | library cache lock
100% | 1881 | FINDPT | hs-10-20-30-193 | SYS$USERS | 1mthwa5wrtha7 | library cache lock
100% | 18782 | FINDPT | hs-10-20-30-193 | SYS$USERS | 1mthwa5wrtha7 | library cache lock
100% | 946 | FINDPT | hs-10-20-30-193 | SYS$USERS | 0wcuyc8xnz8q4 | library cache lock
100% | 22540 | FINDPT | hs-10-20-30-193 | SYS$USERS | 0wcuyc8xnz8q4 | library cache lock
100% | 11272 | FINDPT | hs-10-20-30-193 | SYS$USERS | 1mthwa5wrtha7 | library cache lock
100% | 10338 | FINDPT | hs-10-20-30-193 | SYS$USERS | 1mthwa5wrtha7 | library cache lock
100% | 10335 | FINDPT | hs-10-20-30-193 | SYS$USERS | 1mthwa5wrtha7 | library cache lock
100% | 7514 | FINDPT | hs-10-20-30-193 | SYS$USERS | 0wcuyc8xnz8q4 | library cache lock
100% | 6577 | FINDPT | hs-10-20-30-193 | SYS$USERS | 1mthwa5wrtha7 | library cache lock
100% | 3761 | FINDPT | hs-10-20-30-193 | SYS$USERS | 0wcuyc8xnz8q4 | library cache lock
100% | 22544 | FINDPT | hs-10-20-30-193 | SYS$USERS | 1mthwa5wrtha7 | library cache lock
100% | 20665 | FINDPT | hs-10-20-30-193 | SYS$USERS | 0wcuyc8xnz8q4 | library cache lock
100% | 1887 | FINDPT | hs-10-20-30-193 | SYS$USERS | 1mthwa5wrtha7 | library cache lock
100% | 15969 | FINDPT | hs-10-20-30-193 | SYS$USERS | 0wcuyc8xnz8q4 | library cache lock
100% | 15031 | FINDPT | hs-10-20-30-193 | SYS$USERS | 1mthwa5wrtha7 | library cache lock
100% | 3762 | FINDPT | hs-10-20-30-193 | SYS$USERS | 1mthwa5wrtha7 | ON CPU
100% | 3760 | FINDPT | hs-10-20-30-193 | SYS$USERS | 0wcuyc8xnz8q4 | library cache lock
100% | 28179 | FINDPT | hs-10-20-30-193 | SYS$USERS | 1mthwa5wrtha7 | library cache lock
100% | 21603 | FINDPT | hs-10-20-30-193 | SYS$USERS | 1mthwa5wrtha7 | cursor: pin S wait on X
100% | 16910 | FINDPT | hs-10-20-30-193 | SYS$USERS | 1mthwa5wrtha7 | library cache lock
100% | 16908 | FINDPT | hs-10-20-30-193 | SYS$USERS | 1mthwa5wrtha7 | library cache lock
100% | 15968 | FINDPT | hs-10-20-30-193 | SYS$USERS | 1mthwa5wrtha7 | library cache lock
100% | 14088 | FINDPT | hs-10-20-30-193 | SYS$USERS | 0wcuyc8xnz8q4 | library cache lock
100% | 12211 | FINDPT | hs-10-20-30-193 | SYS$USERS | 1mthwa5wrtha7 | library cache lock
100% | 7519 | FINDPT | hs-10-20-30-193 | SYS$USERS | 0wcuyc8xnz8q4 | library cache lock
100% | 5638 | FINDPT | hs-10-20-30-193 | SYS$USERS | 1mthwa5wrtha7 | library cache lock
100% | 5 | FINDPT | hs-10-20-30-193 | SYS$USERS | 1mthwa5wrtha7 | library cache lock
100% | 22539 | FINDPT | hs-10-20-30-193 | SYS$USERS | 1mthwa5wrtha7 | library cache lock
100% | 20662 | FINDPT | hs-10-20-30-193 | SYS$USERS | 0wcuyc8xnz8q4 | library cache lock
100% | 18784 | FINDPT | hs-10-20-30-193 | SYS$USERS | 0wcuyc8xnz8q4 | library cache lock
100% | 1880 | FINDPT | hs-10-20-30-193 | SYS$USERS | 1mthwa5wrtha7 | library cache lock
--------------------------------------------------------------------------------------------------------------------------------------------------
PL/SQL procedure successfully completed.
Start From 2023/07/20 09:11 last 30 mintutes dba_hist_active_sess_history
ON CPU User I/O Network Commit Application Concurrency Cluster Configuration Administrative System I/O Scheduler Queueing Other Others for Wait_class%
======================
SQL_ID Active% AAS Wait_class% COMMAND MACHINE PROCEDURE_SQL
------------- ------- ---- --------------------------------------------------------------------------- ------------ ------------------------- -------------
1mthwa5wrtha7 49.95% 5 3% 0% 0% 0% 0% 97% 0% 0% 0% 0% 0% 0% 0% 0% Others hs-10-20-30-193
0wcuyc8xnz8q4 49.95% 5 3% 0% 0% 0% 0% 97% 0% 0% 0% 0% 0% 0% 0% 0% Others hs-10-20-30-193
444n6jjym97zv .03% 0 100% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% SELECT hs-10-20-30-199 fdynksztvf897
dwm8jjtbs6mwt .03% 0 100% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% SELECT hs-10-20-30-199
5zkcbst0m7h8t .03% 0 100% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% SELECT hs-10-20-30-199 fdynksztvf897
Start From 2023/07/20 09:11 last 30 mintutes gv$active_session_history
Show event and sql
======================
INST# EVENT SQL_ID machine@program@module CNT
----- ---------------------------------------- ------------- ------------------------------------------------------------------------------------------ ----
1 library cache lock 0wcuyc8xnz8q4 hs-10-20-30-193@JDBC Thin Client@JDBC Thin Client ####
1 library cache lock 1mthwa5wrtha7 hs-10-20-30-193@JDBC Thin Client@JDBC Thin Client ####
1 ON CPU 0wcuyc8xnz8q4 hs-10-20-30-193@JDBC Thin Client@JDBC Thin Client 48
1 ON CPU 1mthwa5wrtha7 hs-10-20-30-193@JDBC Thin Client@JDBC Thin Client 48
1 cursor: pin S wait on X 0wcuyc8xnz8q4 hs-10-20-30-193@JDBC Thin Client@JDBC Thin Client 47
1 cursor: pin S wait on X 1mthwa5wrtha7 hs-10-20-30-193@JDBC Thin Client@JDBC Thin Client 47
1 ON CPU 5zkcbst0m7h8t hs-10-20-30-199@sqlplus@hs-10-20-30-199 (TNS V1-V3)@sqlplus@hs-10-20-30-199 (TNS V1-V3) 1
1 ON CPU 444n6jjym97zv hs-10-20-30-199@sqlplus@hs-10-20-30-199 (TNS V1-V3)@sqlplus@hs-10-20-30-199 (TNS V1-V3) 1
1 ON CPU dwm8jjtbs6mwt hs-10-20-30-199@sqlplus@hs-10-20-30-199 (TNS V1-V3)@sqlplus@hs-10-20-30-199 (TNS V1-V3) 1
top sql From v$sql_area
======================
I# RC RR RT DB_USER SQL_ID CPU_S ELAP_S WAIT_S wait/elap EXECS ELA_PE TOT_BUFS AVG_BUF READS IOWAIT_S SQL_TEXT
--- ---- ---- ---- ---------- ------------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- -------------------------
1 1 242 1 FINDPT b81bnhj0pp2t3 54 54 0 .2% 4 10.87 94472 23618 17 0 insert all
1 2 755 2 FINDPTLOCA 5b2n64tfznr8a 15 15 0 .5% 309943 0 2169636 7 2 0 select * from proces
1 3 227 3 FINDPT 54aq23q6bsmuk 12 12 0 .2% 1 6.05 10829 10829 19 0 insert all
1 4 7 4 SYS 6pacvqujxrajf 5 5 0 .5% 2 1.53 140749 70374.5 3413 0 SELECT * FROM TABLE(
1 5 2 6 SYS btqubgr940awu 4 4 0 .5% 3 1.03 120158 40052.7 12967 0 BEGIN dbms_workload_
1 20 12 5 SYS b9p45hkcx0pwh 1 4 4 87% 1 2.08 42462 42462 2194 4 select dbms_qopatch.
1 28 1 29 SYS 1j6tnz8fcm4c3 0 0 0 .3% 1 .17 21015 21015 20588 0 delete /* QOSH:PURGE
1 29 4 30 SYS c2p32r5mzv8hb 0 0 0 3.2% 1 .17 42186 42186 6387 0 BEGIN prvt_adviso
1 40 3 42 SYS 30p3mh3brvpt9 0 0 0 .5% 3 .05 24583 8194.3 8062 0 SELECT snap_id , SQL
1 51 5 51 SYS 1jb0rx0tq963n 0 0 0 .7% 1 .07 11462 11462 3981 0 delete /* QOSH:PURGE
Which Object Caused The Library Cache Wait
instance_number=1
snapper group by sql_id,event ,from , last 30 ,top 20 sql with event
./ora snapper <begin_time> <duration> [30]
结论：基本定位insert all语句引起，下一步查看insert all语句
第二步、SQL有点长，我直接投降,一个insert all密密麻麻5000行
### The error may involve com.beiyin.mapper.InitialData.insertAccount-Inline
### The error occurred while setting parameters
### SQL: insert all into account (account_id,account_sjnoid,account_stat,account_custid,account_bale, account_pswd,account_name,account_amrz,account_inmod, account_itrz,account_branchid,account_mdate,account_mtime,account_fld1,account_fld2,account_fld3,account_fld4) values (?,?,?,?, ?,?,?,?,?, ?,?,?,?, ?,?,?,?) into account (account_id,account_sjnoid,account_stat,account_custid,account_bale, account_pswd,account_name,account_amrz,account_inmod, account_itrz,account_branchid,account_mdate,account_mtime,account_fld1,account_fld2,account_fld3,account_fld4) values (?,?,?,?, ?,?,?,?,?, ?,?,?,?, ?,?,?,?) into account (account_id,account_sjnoid,account_stat,account_custid,account_bale, account_pswd,account_name,account_amrz,account_inmod, account_itrz,account_branchid,account_mdate,account_mtime,account_fld1,account_fld2,account_fld3,account_fld4) values (?,?,?,?, ?,?,?,?,?, ?,?,?,?, ?,?,?,?) into account (account_id,account_sjnoid,account_stat,account_custid,account_bale, account_pswd,account_name,account_amrz,account_inmod, account_itrz,account_branchid,account_mdate,account_mtime,account_fld1,account_fld2,account_fld3,account_fld4) values (?,?,?,?, ?,?,?,?,?, ?,?,?,?, ?,?,?,?) into account (account_id,account_sjnoid,account_stat,account_custid,account_bale, account_pswd,account_name,account_amrz,account_inmod, account_itrz,account_branchid,account_mdate,account_mtime,account_fld1,account_fld2,account_fld3,account_fld4) values (?,?,?,?, ?,?,?,?,?, ?,?,?,?, ?,?,?,?) into account (account_id,account_sjnoid,account_stat,account_custid,account_bale, account_pswd,account_name,account_amrz,account_inmod, account_itrz,account_branchid,account_mdate,account_mtime,account_fld1,account_fld2,account_fld3,account_fld4) values (?,?,?,?, ?,?,?,?,?, ?,?,?,?, ?,?,?,?) into account (account_id,account_sjnoid,account_stat,account_custid,account_bale, account_pswd,account_name,account_amrz,account_inmod, account_itrz,account_branchid,account_mdate,account_mtime,account_fld1,account_fld2,account_fld3,account_fld4) values (?,?,?,?, ?,?,?,?,?, ?,?,?,?, ?,?,?,?) into account (account_id,account_sjnoid,account_stat,account_custid,account_bale, account_pswd,account_name,account_amrz,account_inmod, account_itrz,account_branchid,account_mdate,account_mtime,account_fld1,account_fld2,account_fld3,account_fld4) values (?,?,?,?, ?,?,?,?,?, ?,?,?,?, ?,?,?,?) into account (account_id,account_sjnoid,account_stat,account_custid,account_bale, account_pswd,account_name,account_amrz,account_inmod, account_itrz,account_branchid,account_mdate,account_mtime,account_fld1,account_fld2,account_fld3,account_fld4) values (?,?,?,?, ?,?,?,?,?, ?,?,?,?, ?,?,?,?) into account (account_id,account_sjnoid,account_stat,account_custid,account_bale, account_pswd,account_name,account_amrz,account_inmod, account_itrz,account_branchid,account_mdate,account_mtime,account_fld1,account_fld2,account_fld3,account_fld4) values (?,?,?,?, ?,?,?,?,?, ?,?,?,?, ?,?,?,?) into account (account_id,account_sjnoid,account_stat,account_custid,account_bale, account_pswd,account_name,account_amrz,account_inmod, account_itrz,account_branchid,account_mdate,account_mtime,account_fld1,account_fld2,account_fld3,account_fld4) values (?,?,?,?, ?,?,?,?,?, ?,?,?,?, ?,?,?,?) into account (account_id,account_sjnoid,account_stat,account_custid,account_bale, account_pswd,account_name,account_amrz,account_inmod, account_itrz,account_branchid,account_mdate,account_mtime,account_fld1,account_fld2,account_fld3,account_fld4) values (?,?,?,?, ?,?,?,?,?, ?,?,?,?, ?,?,?,?) into account (account_id,account_sjnoid,account_stat,account_custid,account_bale, account_pswd,account_name,account_amrz,account_inmod, account_itrz,account_branchid,account_mdate,account_mtime,account_fld1,account_fld2,account_fld3,account_fld4) values (?,?,?,?, ?,?,?,?,?, ?,?,?,?, ?,?,?,?) into account (account_id,account_sjnoid,account_stat,account_custid,account_bale, account_pswd,account_name,account_amrz,account_inmod, account_itrz,account_branchid,account_mdate,account_mtime,account_fld1,account_fld2,account_fld3,account_fld4) values (?,?,?,?, ?,?,?,?,?, ?,?,?,?, ?,?,?,?) into account (account_id,account_sjnoid,account_stat,account_custid,account_bale, account_pswd,account_name,account_amrz,account_inmod, account_itrz,account_branchid,account_mdate,account_mtime,account_fld1,account_fld2,account_fld3,account_fld4) values (?,?,?,?, ?,?,?,?,?, ?,?,?,?, ?,?,?,?) into account (account_id,account_sjnoid,account_stat,account_custid,account_bale, account_pswd,account_name,account_amrz,account_inmod, account_itrz,account_branchid,account_mdate,account_mtime,account_fld1,account_fld2,account_fld3,account_fld4) values (?,?,?,?, ?,?,?,?,?, ?,?,?,?, ?,?,?,?) into account (account_id,account_sjnoid,account_stat,account_custid,account_bale, account_pswd,account_name,account_amrz,account_inmod, account_itrz,account_branchid,account_mdate,account_mtime,account_fld1,account_fld2,account_fld3,account_fld4) values (?,?,?,?, ?,?,?,?,?, ?,?,?,?, ?,?,?,?) into account (account_id,account_sjnoid,account_stat,account_custid,account_bale, account_pswd,account_name,account_amrz,account_inmod, account_itrz,account_branchid,account_mdate,account_mtime,account_fld1,account_fld2,account_fld3,account_fld4) values (?,?,?,?, ?,?,?,?,?, ?,?,?,?, ?,?,?,?) into account (account_id,account_sjnoid,account_stat,account_custid,account_bale, account_pswd,account_name,account_amrz,account_inmod, account_itrz,account_branchid,account_mdate,account_mtime,account_fld1,account_fld2,account_fld3,account_fld4) values (?,?,?,?, ?,?,?,?,?, ?,?,?,?, ?,?,?,?) into account (account_id,account_sjnoid,account_stat,account_custid,account_bale, account_pswd,account_name,account_amrz,account_inmod, account_itrz,account_branchid,account_mdate,account_mtime,account_fld1,account_fld2,account_fld3,account_fld4) values (?,?,?,?, ?,?,?,?,?, ?,?,?,?, ?,?,?,?) into account (account_id,account_sjnoid,account_stat,account_custid,account_bale, account_pswd,account_name,account_amrz,account_inmod, account_itrz,account_branchid,account_mdate,account_mtime,account_fld1,account_fld2,account_fld3,account_fld4) values (?,?,?,?, ?,?,?,?,?, ?,?,?,?, ?,?,?,?) into account (account_id,account_sjnoid,account_stat,account_custid,account_bale, account_pswd,account_name,account_amrz,account_inmod, account_itrz,account_branchid,account_mdate,account_mtime,account_fld1,account_fld2,account_fld3,account_fld4) values (?,?,?,?, ?,?,?,?,?, ?,?,?,?, ?,?,?,?) into account (account_id,account_sjnoid,account_stat,account_custid,account_bale, account_pswd,account_name,account_amrz,account_inmod, account_itrz,account_branchid,account_mdate,account_mtime,account_fld1,account_fld2,account_fld3,account_fld4) values (?,?,?,?, ?,?,?,?,?, ?,?,?,?, ?,?,?,?) into account (account_id,account_sjnoid,account_stat,account_custid,account_bale, account_pswd,account_name,account_amrz,account_inmod, account_itrz,account_branchid,account_mdate,account_mtime,account_fld1,account_fld2,account_fld3,account_fld4) values (?,?,?,?, ?,?,?,?,?, ?,?,?,?, ?,?,?,?) into account (account_id,account_sjnoid,account_stat,account_custid,account_bale, account_pswd,account_name,account_amrz,account_inmod, account_itrz,account_branchid,account_mdate,account_mtime,account_fld1,account_fld2,account_fld3,account_fld4) values (?,?,?,?, ?,?,?,?,?, ?,?,?,?, ?,?,?,?) into account (account_id,account_sjnoid,account_stat,account_custid,account_bale, account_pswd,account_name,account_amrz,account_inmod, account_itrz,account_branchid,account_mdate,account_mtime,account_fld1,account_fld2,account_fld3,account_fld4) values (?,?,?,?, ?,?,?,?,?, ?,?,?,?, ?,?,?,?) into account (account_id,account_sjnoid,account_stat,account_custid,account_bale, account_pswd,account_name,account_amrz,account_inmod, account_itrz,account_branchid,account_mdate,account_mtime,account_fld1,account_fld2,account_fld3,account_fld4) values (?,?,?,?, ?,?,?,?,?, ?,?,?,?, ?,?,?,?) into account (account_id,account_sjnoid,account_stat,account_custid,account_bale, account_pswd,account_name,account_amrz,account_inmod, account_itrz,account_branchid,account_mdate,account_mtime,account_fld1,account_fld2,account_fld3,account_fld4) values (?,?,?,?, ?,?,?,?,?, ?,?,?,?, ?,?,?,?) into account (account_id,account_sjnoid,account_stat,account_custid,account_bale, account_pswd,account_name,account_amrz,account_inmod,
xxxxxxxxxx 一路下来 5000行
account_itrz,account_branchid,account_mdate,account_mtime,account_fld1,account_fld2,account_fld3,account_fld4) values (?,?,?,?, ?,?,?,?,?, ?,?,?,?, ?,?,?,?) select 1 from dual
### Cause: java.sql.SQLSyntaxErrorException: ORA-01745: invalid host/bind variable name
; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: ORA-01745: invalid host/bind variable name
at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:91)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:82)
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:446)
at com.sun.proxy.$Proxy61.insert(Unknown Source)
at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:278)
at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:57)
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:59)
at com.sun.proxy.$Proxy95.insertAccount(Unknown Source)
at jdk.internal.reflect.GeneratedMethodAccessor111.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:136)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
at com.sun.proxy.$Proxy96.insertAccount(Unknown Source)
at com.beiyin.service.impl.InitialDataServiceImpl$ParallelExecuteAddAccountTask.compute(InitialDataServiceImpl.java:681)
at com.beiyin.service.impl.InitialDataServiceImpl$ParallelExecuteAddAccountTask.compute(InitialDataServiceImpl.java:638)
at java.base/java.util.concurrent.RecursiveTask.exec(RecursiveTask.java:94)
at java.base/java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:290)
at java.base/java.util.concurrent.ForkJoinPool$WorkQueue.topLevelExec(ForkJoinPool.java:1020)
at java.base/java.util.concurrent.ForkJoinPool.scan(ForkJoinPool.java:1656)
at java.base/java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1594)
at java.base/java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:183)
Caused by: java.sql.SQLSyntaxErrorException: ORA-01745: invalid host/bind variable name
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509)
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:461)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1104)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:553)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:655)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:270)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:91)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:970)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1213)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3671)
at oracle.jdbc.driver.T4CPreparedStatement.executeInternal(T4CPreparedStatement.java:1426)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3783)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1081)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxyPreparedStatement.java:989)
at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:46)
at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:74)
at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:50)
at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117)
at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76)
at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:198)
at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:185)
at jdk.internal.reflect.GeneratedMethodAccessor93.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:433)
... 23 common frames omitted
Caused by: oracle.jdbc.OracleDatabaseException: ORA-01745: invalid host/bind variable name
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:513)
... 48 common frames omitted
2023-07-20 09:16:37.804 [ForkJoinPool-2-worker-5] ERROR com.beiyin.service.impl.InitialDataServiceImpl - InitialDataServiceImpl ParallelExecuteAddAccountTask compute exception {}
org.springframework.jdbc.BadSqlGrammarException:
### Error updating database. Cause: java.sql.SQLSyntaxErrorException: ORA-01745: invalid host/bind variable name
SQL改成50一拼接
[oracle@hs-10-20-30-199 yc]$ ./ora snapper
./ora snapper "2023/07/20 09:54" 30
calc average active session
[oracle@hs-10-20-30-199 yc]$ ./ora snapper "2023/07/20 09:54" 30
PL/SQL procedure successfully completed.
Enter value for 4: Sampling SID with interval 5 seconds, taking 1 snapshots...
--------------------------------------------------------------------------------------------------------------------------------------------------
Active% | SID | USERNAME | MACHINE | SERVICE_NAME | SQL_ID | EVENT
--------------------------------------------------------------------------------------------------------------------------------------------------
42% | 26307 | FINDPT | hs-10-20-30-193 | SYS$USERS | 8wv8vf3fku4c2 | buffer busy waits
40% | 13160 | FINDPT | hs-10-20-30-193 | SYS$USERS | 8wv8vf3fku4c2 | buffer busy waits
40% | 17848 | FINDPT | hs-10-20-30-193 | SYS$USERS | 8wv8vf3fku4c2 | buffer busy waits
40% | 27241 | FINDPT | hs-10-20-30-193 | SYS$USERS | 8wv8vf3fku4c2 | buffer busy waits
37% | 21598 | | hs-10-20-30-199 | SYS$BACKGROUND | | log file parallel write
37% | 2823 | FINDPT | hs-10-20-30-193 | SYS$USERS | 8wv8vf3fku4c2 | buffer busy waits
37% | 20665 | FINDPT | hs-10-20-30-193 | SYS$USERS | 8wv8vf3fku4c2 | buffer busy waits
37% | 21606 | FINDPT | hs-10-20-30-193 | SYS$USERS | 8wv8vf3fku4c2 | buffer busy waits
35% | 24430 | FINDPT | hs-10-20-30-193 | SYS$USERS | 8wv8vf3fku4c2 | buffer busy waits
35% | 26306 | FINDPT | hs-10-20-30-193 | SYS$USERS | 8wv8vf3fku4c2 | buffer busy waits
35% | 951 | FINDPT | hs-10-20-30-193 | SYS$USERS | 8wv8vf3fku4c2 | buffer busy waits
35% | 15038 | FINDPT | hs-10-20-30-193 | SYS$USERS | 8wv8vf3fku4c2 | buffer busy waits
33% | 20669 | FINDPT | hs-10-20-30-193 | SYS$USERS | 8wv8vf3fku4c2 | buffer busy waits
33% | 22539 | FINDPT | hs-10-20-30-193 | SYS$USERS | 8wv8vf3fku4c2 | buffer busy waits
33% | 24427 | FINDPT | hs-10-20-30-193 | SYS$USERS | 8wv8vf3fku4c2 | buffer busy waits
33% | 5638 | FINDPT | hs-10-20-30-193 | SYS$USERS | 8wv8vf3fku4c2 | buffer busy waits
30% | 20664 | FINDPT | hs-10-20-30-193 | SYS$USERS | 8wv8vf3fku4c2 | buffer busy waits
30% | 15976 | FINDPT | hs-10-20-30-193 | SYS$USERS | 8wv8vf3fku4c2 | buffer busy waits
30% | 5646 | FINDPT | hs-10-20-30-193 | SYS$USERS | 8wv8vf3fku4c2 | buffer busy waits
30% | 15029 | FINDPT | hs-10-20-30-193 | SYS$USERS | 8wv8vf3fku4c2 | buffer busy waits
30% | 18791 | FINDPT | hs-10-20-30-193 | SYS$USERS | 8wv8vf3fku4c2 | buffer busy waits
28% | 5645 | FINDPT | hs-10-20-30-193 | SYS$USERS | 8wv8vf3fku4c2 | buffer busy waits
28% | 15036 | FINDPT | hs-10-20-30-193 | SYS$USERS | 8wv8vf3fku4c2 | buffer busy waits
28% | 23486 | FINDPT | hs-10-20-30-193 | SYS$USERS | 8wv8vf3fku4c2 | buffer busy waits
28% | 17853 | FINDPT | hs-10-20-30-193 | SYS$USERS | 8wv8vf3fku4c2 | buffer busy waits
28% | 4709 | FINDPT | hs-10-20-30-193 | SYS$USERS | 8wv8vf3fku4c2 | buffer busy waits
28% | 14098 | FINDPT | hs-10-20-30-193 | SYS$USERS | 8wv8vf3fku4c2 | buffer busy waits
28% | 1884 | FINDPT | hs-10-20-30-193 | SYS$USERS | 8wv8vf3fku4c2 | buffer busy waits
26% | 5645 | FINDPT | hs-10-20-30-193 | SYS$USERS | 8wv8vf3fku4c2 | ON CPU
26% | 17849 | FINDPT | hs-10-20-30-193 | SYS$USERS | 8wv8vf3fku4c2 | buffer busy waits
26% | 23487 | FINDPT | hs-10-20-30-193 | SYS$USERS | 8wv8vf3fku4c2 | buffer busy waits
23% | 20665 | FINDPT | hs-10-20-30-193 | SYS$USERS | 8wv8vf3fku4c2 | ON CPU
23% | 18793 | FINDPT | hs-10-20-30-193 | SYS$USERS | 8wv8vf3fku4c2 | buffer busy waits
21% | 4709 | FINDPT | hs-10-20-30-193 | SYS$USERS | 8wv8vf3fku4c2 | ON CPU
21% | 19729 | FINDPT | hs-10-20-30-193 | SYS$USERS | 8wv8vf3fku4c2 | buffer busy waits
21% | 19731 | FINDPT | hs-10-20-30-193 | SYS$USERS | 8wv8vf3fku4c2 | buffer busy waits
19% | 24427 | FINDPT | hs-10-20-30-193 | SYS$USERS | 8wv8vf3fku4c2 | ON CPU
19% | 15038 | FINDPT | hs-10-20-30-193 | SYS$USERS | 8wv8vf3fku4c2 | ON CPU
19% | 23486 | FINDPT | hs-10-20-30-193 | SYS$USERS | 8wv8vf3fku4c2 | ON CPU
16% | 4703 | SYS | hs-10-20-30-199 | SYS$USERS | | ON CPU
16% | 23487 | FINDPT | hs-10-20-30-193 | SYS$USERS | 8wv8vf3fku4c2 | ON CPU
16% | 17853 | FINDPT | hs-10-20-30-193 | SYS$USERS | 8wv8vf3fku4c2 | ON CPU
14% | 5638 | FINDPT | hs-10-20-30-193 | SYS$USERS | 8wv8vf3fku4c2 | ON CPU
14% | 5646 | FINDPT | hs-10-20-30-193 | SYS$USERS | 8wv8vf3fku4c2 | ON CPU
14% | 1884 | FINDPT | hs-10-20-30-193 | SYS$USERS | 8wv8vf3fku4c2 | ON CPU
14% | 19729 | FINDPT | hs-10-20-30-193 | SYS$USERS | 8wv8vf3fku4c2 | ON CPU
12% | 13160 | FINDPT | hs-10-20-30-193 | SYS$USERS | 8wv8vf3fku4c2 | ON CPU
12% | 20664 | FINDPT | hs-10-20-30-193 | SYS$USERS | 8wv8vf3fku4c2 | ON CPU
12% | 26307 | FINDPT | hs-10-20-30-193 | SYS$USERS | 8wv8vf3fku4c2 | ON CPU
12% | 17848 | FINDPT | hs-10-20-30-193 | SYS$USERS | 8wv8vf3fku4c2 | enq: TX - index contention
--------------------------------------------------------------------------------------------------------------------------------------------------
PL/SQL procedure successfully completed.
Start From 2023/07/20 09:54 last 30 mintutes dba_hist_active_sess_history
ON CPU User I/O Network Commit Application Concurrency Cluster Configuration Administrative System I/O Scheduler Queueing Other Others for Wait_class%
======================
SQL_ID Active% AAS Wait_class% COMMAND MACHINE PROCEDURE_SQL
------------- ------- ---- --------------------------------------------------------------------------- ------------ ------------------------- -------------
8wv8vf3fku4c2 80.04% 8 33% 0% 0% 0% 0% 67% 0% 0% 0% 0% 0% 0% 0% 0% INSERT hs-10-20-30-193
Null 18.91% 2 21% 4% 4% 22% 0% 0% 0% 0% 0% 44% 0% 0% 3% 0% Others hs-10-20-30-199
4n3b2c63z58b9 .84% 0 100% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% SELECT hs-10-20-30-199
444n6jjym97zv .21% 0 100% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% SELECT hs-10-20-30-199 fdynksztvf897
Start From 2023/07/20 09:54 last 30 mintutes gv$active_session_history
Show event and sql
======================
INST# EVENT SQL_ID machine@program@module CNT
----- ---------------------------------------- ------------- ------------------------------------------------------------------------------------------ ----
1 buffer busy waits 8wv8vf3fku4c2 hs-10-20-30-193@JDBC Thin Client@JDBC Thin Client 222
1 ON CPU 8wv8vf3fku4c2 hs-10-20-30-193@JDBC Thin Client@JDBC Thin Client 126
1 enq: TX - index contention 8wv8vf3fku4c2 hs-10-20-30-193@JDBC Thin Client@JDBC Thin Client 32
1 log file sync hs-10-20-30-193@JDBC Thin Client@JDBC Thin Client 20
1 log file parallel write hs-10-20-30-199@oracle@hs-10-20-30-199 (LGWR)@ 9
1 ON CPU hs-10-20-30-193@JDBC Thin Client@JDBC Thin Client 7
1 db file async I/O submit hs-10-20-30-199@oracle@hs-10-20-30-199 (DBW3)@ 7
1 db file async I/O submit hs-10-20-30-199@oracle@hs-10-20-30-199 (DBW0)@ 7
1 db file async I/O submit hs-10-20-30-199@oracle@hs-10-20-30-199 (DBW1)@ 7
1 db file async I/O submit hs-10-20-30-199@oracle@hs-10-20-30-199 (DBW2)@ 7
1 ON CPU hs-10-20-30-199@oracle@hs-10-20-30-199 (H001)@GoldenGate 5
1 Disk file operations I/O hs-10-20-30-199@oracle@hs-10-20-30-199 (ARC3)@ 4
1 ON CPU 4n3b2c63z58b9 hs-10-20-30-199@sqlplus@hs-10-20-30-199 (TNS V1-V3)@sqlplus@hs-10-20-30-199 (TNS V1-V3) 4
1 SQL*Net more data from client hs-10-20-30-193@JDBC Thin Client@JDBC Thin Client 4
1 Log archive I/O hs-10-20-30-199@oracle@hs-10-20-30-199 (ARC3)@ 3
1 PGA memory operation hs-10-20-30-193@JDBC Thin Client@JDBC Thin Client 3
1 ON CPU hs-10-20-30-199@oracle@hs-10-20-30-199 (MS02)@GoldenGate 2
1 ON CPU hs-10-20-30-199@oracle@hs-10-20-30-199 (LX00)@GoldenGate 2
1 ON CPU hs-10-20-30-199@oracle@hs-10-20-30-199 (LGWR)@ 2
top sql From v$sql_area
======================
I# RC RR RT DB_USER SQL_ID CPU_S ELAP_S WAIT_S wait/elap EXECS ELA_PE TOT_BUFS AVG_BUF READS IOWAIT_S SQL_TEXT
--- ---- ---- ---- ---------- ------------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- -------------------------
1 1 25 1 FINDPT 8wv8vf3fku4c2 864 2352 1488 63.2% 449742 .01 152317533 338.7 1030 1 insert all
1 2 30 2 FINDPT fsxuu6cavwjfm 549 1230 681 55.3% 199894 .01 99879277 499.7 950 2 insert all
1 3 284 3 FINDPT b81bnhj0pp2t3 54 54 0 .2% 4 10.87 94472 23618 17 0 insert all
1 4 266 4 FINDPT 54aq23q6bsmuk 12 12 0 .2% 1 6.05 10829 10829 19 0 insert all
1 5 368 5 SYS 4n3b2c63z58b9 9 10 0 .4% 29 .32 216 7.4 12 0 select /*+use_nl(a,b
1 6 4 6 SYS btqubgr940awu 6 6 0 3.3% 4 1.17 152559 38139.8 13453 0 BEGIN dbms_workload_
1 32 2 24 SYS 54gjkvrjy0avx 1 1 1 47.3% 1 .66 141928 141928 20321 1 declare cursor c
1 33 3 25 SYS 03qkwzbhz8r2c 1 1 1 47.8% 1 .66 141712 141712 20318 1 SELECT /*+ BEG
1 43 1 44 SYS 1j6tnz8fcm4c3 0 0 0 .3% 1 .17 21015 21015 20588 0 delete /* QOSH:PURGE
1 49 5 52 SYS 30p3mh3brvpt9 0 0 0 .4% 5 .05 40725 8145 8062 0 SELECT snap_id , SQL
Which Object Caused The Library Cache Wait
instance_number=1
snapper group by sql_id,event ,from , last 30 ,top 20 sql with event
./ora snapper <begin_time> <duration> [30]
SQL文本
SQL_ID 8wv8vf3fku4c2, child number 98
--------------------------------------
insert all into account
(account_id,account_sjnoid,account_stat,account_custid,account_bale,
account_pswd,account_name,account_amrz,account_inmod,
account_itrz,account_branchid,account_mdate,account_mtime,account_fld1,a
ccount_fld2,account_fld3,account_fld4) values (:1
,:2 ,:3 ,:4 , :5 ,:6 ,:7 ,:8 ,:9 , :10 ,:11
,:12 ,:13 , :14 ,:15 ,:16 ,:17 ) into
account (account_id,account_sjnoid,account_stat,account_custid,account_b
ale, account_pswd,account_name,account_amrz,account_inmod,
account_itrz,account_branchid,account_mdate,account_mtime,account_f
ld1,account_fld2,account_fld3,account_fld4) values
(:18 ,:19 ,:20 ,:21 , :22 ,:23 ,:24 ,:25 ,:26 ,
:27 ,:28 ,:29 ,:30 , :31 ,:32 ,:33 ,:34 )
into account (account_id,account_sjnoid,account_stat,account_custid,a
ccount_bale, account
Plan hash value: 2939908344
------------------------------------------------------------------------
| Id | Operation | Name | E-Rows | Cost (%CPU)| E-Time |
------------------------------------------------------------------------
| 0 | INSERT STATEMENT | | | 2 (100)| |
| 1 | MULTI-TABLE INSERT | | | | |
| 2 | FAST DUAL | | 1 | 2 (0)| 00:00:01 |
| 3 | INTO | ACCOUNT | | | |
| 4 | INTO | ACCOUNT | | | |
| 5 | INTO | ACCOUNT | | | |
| 6 | INTO | ACCOUNT | | | |
| 7 | INTO | ACCOUNT | | | |
| 8 | INTO | ACCOUNT | | | |
| 9 | INTO | ACCOUNT | | | |
| 10 | INTO | ACCOUNT | | | |
| 11 | INTO | ACCOUNT | | | |
| 12 | INTO | ACCOUNT | | | |
| 13 | INTO | ACCOUNT | | | |
| 14 | INTO | ACCOUNT | | | |
| 15 | INTO | ACCOUNT | | | |
| 16 | INTO | ACCOUNT | | | |
| 17 | INTO | ACCOUNT | | | |
| 18 | INTO | ACCOUNT | | | |
| 19 | INTO | ACCOUNT | | | |
| 20 | INTO | ACCOUNT | | | |
| 21 | INTO | ACCOUNT | | | |
| 22 | INTO | ACCOUNT | | | |
| 23 | INTO | ACCOUNT | | | |
| 24 | INTO | ACCOUNT | | | |
| 25 | INTO | ACCOUNT | | | |
| 26 | INTO | ACCOUNT | | | |
| 27 | INTO | ACCOUNT | | | |
| 28 | INTO | ACCOUNT | | | |
| 29 | INTO | ACCOUNT | | | |
| 30 | INTO | ACCOUNT | | | |
| 31 | INTO | ACCOUNT | | | |
| 32 | INTO | ACCOUNT | | | |
| 33 | INTO | ACCOUNT | | | |
| 34 | INTO | ACCOUNT | | | |
| 35 | INTO | ACCOUNT | | | |
| 36 | INTO | ACCOUNT | | | |
| 37 | INTO | ACCOUNT | | | |
| 38 | INTO | ACCOUNT | | | |
| 39 | INTO | ACCOUNT | | | |
| 40 | INTO | ACCOUNT | | | |
| 41 | INTO | ACCOUNT | | | |
| 42 | INTO | ACCOUNT | | | |
| 43 | INTO | ACCOUNT | | | |
| 44 | INTO | ACCOUNT | | | |
| 45 | INTO | ACCOUNT | | | |
| 46 | INTO | ACCOUNT | | | |
| 47 | INTO | ACCOUNT | | | |
| 48 | INTO | ACCOUNT | | | |
| 49 | INTO | ACCOUNT | | | |
| 50 | INTO | ACCOUNT | | | |
| 51 | INTO | ACCOUNT | | | |
| 52 | INTO | ACCOUNT | | | |
------------------------------------------------------------------------
Query Block Name / Object Alias (identified by operation id):
-------------------------------------------------------------
1 - SEL$F5BB74E1
2 - SEL$F5BB74E1 / DUAL@SEL$2
Outline Data
-------------
/*+
BEGIN_OUTLINE_DATA
IGNORE_OPTIM_EMBEDDED_HINTS
OPTIMIZER_FEATURES_ENABLE('19.1.0')
DB_VERSION('19.1.0')
ALL_ROWS
OUTLINE_LEAF(@"SEL$F5BB74E1")
MERGE(@"SEL$2" >"SEL$1")
OUTLINE_LEAF(@"INS$1")
OUTLINE(@"SEL$1")
OUTLINE(@"SEL$2")
END_OUTLINE_DATA
*/
Note
-----
- Warning: basic plan statistics not available. These are only collected when:
* hint 'gather_plan_statistics' is used for the statement or
* parameter 'statistics_level' is set to 'ALL', at session or system level
Query Block Registry:
---------------------
<q o="18" f="y" h="y"><n><![CDATA[SEL$F5BB74E1]]></n><p><![CDATA[SEL$1]]
></p><i><o><t>VW</t><v><![CDATA[SEL$2]]></v></o></i><f><h><t><![CDATA[DU
AL]]></t><s><![CDATA[SEL$2]]></s></h></f></q>
<q o="2" f="y"><n><![CDATA[INS$1]]></n><f><h><t><![CDATA[ACCOUNT_0001]]>
</t><s><![CDATA[INS$1]]></s></h><h><t><![CDATA[ACCOUNT_0002]]></t><s><![
CDATA[INS$1]]></s></h><h><t><![CDATA[ACCOUNT_0003]]></t><s><![CDATA[INS$
1]]></s></h><h><t><![CDATA[ACCOUNT_0004]]></t><s><![CDATA[INS$1]]></s></
h><h><t><![CDATA[ACCOUNT_0005]]></t><s><![CDATA[INS$1]]></s></h><h><t><!
[CDATA[ACCOUNT_0006]]></t><s><![CDATA[INS$1]]></s></h><h><t><![CDATA[ACC
OUNT_0007]]></t><s><![CDATA[INS$1]]></s></h><h><t><![CDATA[ACCOUNT_0008]
]></t><s><![CDATA[INS$1]]></s></h><h><t><![CDATA[ACCOUNT_0009]]></t><s><
![CDATA[INS$1]]></s></h><h><t><![CDATA[ACCOUNT_000a]]></t><s><![CDATA[IN
S$1]]></s></h><h><t><![CDATA[ACCOUNT_000b]]></t><s><![CDATA[INS$1]]></s>
</h><h><t><![CDATA[ACCOUNT_000c]]></t><s><![CDATA[INS$1]]></s></h><h><t>
<![CDATA[ACCOUNT_000d]]></t><s><![CDATA[INS$1]]></s></h><h><t><![CDATA[A
CCOUNT_000e]]></t><s><![CDATA[INS$1]]></s></h><h><t><![CDATA[ACCOUNT_000
f]]></t><s><![CDATA[INS$1]]></s></h><h><t><![CDATA[ACCOUNT_0010]]></t><s
><![CDATA[INS$1]]></s></h><h><t><![CDATA[ACCOUNT_0011]]></t><s><![CDATA[
INS$1]]></s></h><h><t><![CDATA[ACCOUNT_0012]]></t><s><![CDATA[INS$1]]></
s></h><h><t><![CDATA[ACCOUNT_0013]]></t><s><![CDATA[INS$1]]></s></h><h><
t><![CDATA[ACCOUNT_0014]]></t><s><![CDATA[INS$1]]></s></h><h><t><![CDATA
[ACCOUNT_0015]]></t><s><![CDATA[INS$1]]></s></h><h><t><![CDATA[ACCOUNT_0
016]]></t><s><![CDATA[INS$1]]></s></h><h><t><![CDATA[ACCOUNT_0017]]></t>
<s><![CDATA[INS$1]]></s></h><h><t><![CDATA[ACCOUNT_0018]]></t><s><![CDAT
A[INS$1]]></s></h><h><t><![CDATA[ACCOUNT_0019]]></t><s><![CDATA[INS$1]]>
</s></h><h><t><![CDATA[ACCOUNT_001a]]></t><s><![CDATA[INS$1]]></s></h><h
><t><![CDATA[ACCOUNT_001b]]></t><s><![CDATA[INS$1]]></s></h><h><t><![CDA
TA[ACCOUNT_001c]]></t><s><![CDATA[INS$1]]></s></h><h><t><![CDATA[ACCOUNT
_001d]]></t><s><![CDATA[INS$1]]></s></h><h><t><![CDATA[ACCOUNT_001e]]></
t><s><![CDATA[INS$1]]></s></h><h><t><![CDATA[ACCOUNT_001f]]></t><s><![CD
ATA[INS$1]]></s></h><h><t><![CDATA[ACCOUNT_0020]]></t><s><![CDATA[INS$1]
]></s></h><h><t><![CDATA[ACCOUNT_0021]]></t><s><![CDATA[INS$1]]></s></h>
<h><t><![CDATA[ACCOUNT_0022]]></t><s><![CDATA[INS$1]]></s></h><h><t><![C
DATA[ACCOUNT_0023]]></t><s><![CDATA[INS$1]]></s></h><h><t><![CDATA[ACCOU
NT_0024]]></t><s><![CDATA[INS$1]]></s></h><h><t><![CDATA[ACCOUNT_0025]]>
</t><s><![CDATA[INS$1]]></s></h><h><t><![CDATA[ACCOUNT_0026]]></t><s><![
CDATA[INS$1]]></s></h><h><t><![CDATA[ACCOUNT_0027]]></t><s><![CDATA[INS$
1]]></s></h><h><t><![CDATA[ACCOUNT_0028]]></t><s><![CDATA[INS$1]]></s></
h><h><t><![CDATA[ACCOUNT_0029]]></t><s><![CDATA[INS$1]]></s></h><h><t><!
[CDATA[ACCOUNT_002a]]></t><s><![CDATA[INS$1]]></s></h><h><t><![CDATA[ACC
OUNT_002b]]></t><s><![CDATA[INS$1]]></s></h><h><t><![CDATA[ACCOUNT_002c]
]></t><s><![CDATA[INS$1]]></s></h><h><t><![CDATA[ACCOUNT_002d]]></t><s><
![CDATA[INS$1]]></s></h><h><t><![CDATA[ACCOUNT_002e]]></t><s><![CDATA[IN
S$1]]></s></h><h><t><![CDATA[ACCOUNT_002f]]></t><s><![CDATA[INS$1]]></s>
</h><h><t><![CDATA[ACCOUNT_0030]]></t><s><![CDATA[INS$1]]></s></h><h><t>
<![CDATA[ACCOUNT_0031]]></t><s><![CDATA[INS$1]]></s></h><h><t><![CDATA[A
CCOUNT_0032]]></t><s><![CDATA[INS$1]]></s></h></f></q>
<q o="2"><n><![CDATA[SEL$1]]></n><f><h><t><![CDATA[from$_subquery$_051]]
></t><s><![CDATA[SEL$1]]></s></h></f></q>
<q o="2"><n><![CDATA[SEL$2]]></n><f><h><t><![CDATA[DUAL]]></t><s><![CDAT
A[SEL$2]]></s></h></f></q>
最后修改时间：2023-07-20 10:03:33
「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文章的来源（墨天轮），文章链接，文章作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
