数据库版本:10.2.0.5,操作系统为REDHAT 6.0 X86 64的操作系统:
通过几个SQLLDR进行入库操作,经过一段时间后,发现SQLLDR进程中断,其回话信息如下:
SID USERNAME PROGRAM SQL_HASH_VALUE ROW_WAIT_FILE# ROW_WAIT_BLOCK# BLOCKING_SESSION EVENT P1TEXT P1 WAIT_CLASS
----- - ------------------------------------------------------ -------------- --------------- ---------------- - ------------------- -------------- --------------
685 ODSDB sqlldr@etl02 (TNS V1-V3) 2693890915 249 142130 696 row cache lock cache id 5 Concurrency
696 ODSDB sqlldr@etl02 (TNS V1-V3) 0 271 5609 768 row cache lock cache id 5 Concurrency
728 ODSDB sqlplus@etl02 (TNS V1-V3) 626019611 0 0 685 row cache lock cache id 2 Concurrency
768 ODSDB sqlldr@etl02 (TNS V1-V3) 0 246 10868 696 row cache lock cache id 5 Concurrency
837 ODSDB sqlldr@etl02 (TNS V1-V3) 2935951425 201 7557 768 row cache lock cache id 5 Concurrency
查看AWR发现有很多的PARSE CALL
parse count (total) 1,107,514 102.50 283.11 观察PARSES top的sql
Parse Calls Executions % Total Parses SQL Id SQL Module SQL Text
195,248 195,247 17.63 9qgtwh66xg6nz update seg$ set type#=:4, bloc...
157,132 157,132 14.19 bsa0wjtftg3uw select file# from file$ where ...
134,539 134,539 12.15 aq4js2gkfjru8 update tsq$ set blocks=:3, max...
22,079 22,079 1.99 2ym6hhaq30r73 select type#, blocks, extents,...
19,223 19,223 1.74 1mvbtvbqt4z4p delete from sys.cache_stats_1$...
19,210 19,210 1.73 7zx0nu1u7qccz delete from seg$ where ts#=:1 ...
16,739 16,739 1.51 59vjj34vugaav delete from obj$ where obj# = ...
均为ORACLE后台SQL,这种问题如何解决?
通过几个SQLLDR进行入库操作,经过一段时间后,发现SQLLDR进程中断,其回话信息如下:
SID USERNAME PROGRAM SQL_HASH_VALUE ROW_WAIT_FILE# ROW_WAIT_BLOCK# BLOCKING_SESSION EVENT P1TEXT P1 WAIT_CLASS
----- - ------------------------------------------------------ -------------- --------------- ---------------- - ------------------- -------------- --------------
685 ODSDB sqlldr@etl02 (TNS V1-V3) 2693890915 249 142130 696 row cache lock cache id 5 Concurrency
696 ODSDB sqlldr@etl02 (TNS V1-V3) 0 271 5609 768 row cache lock cache id 5 Concurrency
728 ODSDB sqlplus@etl02 (TNS V1-V3) 626019611 0 0 685 row cache lock cache id 2 Concurrency
768 ODSDB sqlldr@etl02 (TNS V1-V3) 0 246 10868 696 row cache lock cache id 5 Concurrency
837 ODSDB sqlldr@etl02 (TNS V1-V3) 2935951425 201 7557 768 row cache lock cache id 5 Concurrency
查看AWR发现有很多的PARSE CALL
parse count (total) 1,107,514 102.50 283.11 观察PARSES top的sql
Parse Calls Executions % Total Parses SQL Id SQL Module SQL Text
195,248 195,247 17.63 9qgtwh66xg6nz update seg$ set type#=:4, bloc...
157,132 157,132 14.19 bsa0wjtftg3uw select file# from file$ where ...
134,539 134,539 12.15 aq4js2gkfjru8 update tsq$ set blocks=:3, max...
22,079 22,079 1.99 2ym6hhaq30r73 select type#, blocks, extents,...
19,223 19,223 1.74 1mvbtvbqt4z4p delete from sys.cache_stats_1$...
19,210 19,210 1.73 7zx0nu1u7qccz delete from seg$ where ts#=:1 ...
16,739 16,739 1.51 59vjj34vugaav delete from obj$ where obj# = ...
均为ORACLE后台SQL,这种问题如何解决?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货