Slow Request Impacted by FULL GC

FROM HTTP Archive file

Slow Request : _adf.ctrl-state=10xqmh5aws_5

#	Result	Protocol	Host	URL	Body	Caching	Content-Type	Process	Comments	Custom	Overall_Elapsed	
80	200	HTTPS	abc.xyzcloud.com	/hcmUI/faces/FndOverview?_adf.ctrl-state=10xqmh5aws_5&fnd=%3B%3B%3B%3Bfalse%3B256%3B%3B%3B&fndGlobalItemNodeId=ASE_FUSE_SECURITY_CONSOLE	4,652	no-cache, no-store, must-revalidate	text/xml;charset=utf-8				0:00:35.672	

~]$ find /podscratch/logs/wlslogs/FADomain/servers/UI*/logs/access* -ctime -10| xargs egrep 10xqmh5aws_ | awk '$3>5'|awk '{print "|" $1"|" $2"|" $3 "|" $7 "|" $8"|"}'
|/podscratch/logs/wlslogs/FADomain/servers/UIServer_as2_02/logs/access.log.20210407:2021-04-06|11:56:22.014|8.786|200|"005jom0EIIZ5i^E_R5k3yd0007q_0002Am"|
|/podscratch/logs/wlslogs/FADomain/servers/UIServer_as2_02/logs/access.log.20210407:2021-04-06|12:02:15.349|32.906|200|"005jomJqCEK5i^E_R5k3yd0007q_00035E"|
select count(*) from dba_hist_active_sess_history where ECID='005jomJqCEK5i^E_R5k3yd0007q_00035E';

  COUNT(*)
----------
         0

2021-04-06T12:00:18.129+0000: 3872540.772: [GC [PSYoungGen: 857683K->5018K(815104K)] 3093000K->2244787K(3092480K), 0.1885310 secs] [Times: user=0.49 sys=0.00, real=0.19 secs]
2021-04-06T12:01:44.340+0000: 3872626.983: [GC [PSYoungGen: 815002K->21687K(795136K)] 3054771K->2264957K(3072512K), 0.2240200 secs] [Times: user=0.50 sys=0.00, real=0.23 secs]
2021-04-06T12:01:59.775+0000: 3872642.418: [GC [PSYoungGen: 794807K->11295K(749568K)] 3038077K->2274698K(3026944K), 0.1730620 secs] [Times: user=0.70 sys=0.00, real=0.17 secs]
2021-04-06T12:01:59.948+0000: 3872642.591: [Full GC [PSYoungGen: 11295K->0K(749568K)] [ParOldGen: 2263403K->2222796K(2317312K)] 2274698K->2222796K(3066880K) [PSPermGen: 691974K->691968K(707584K)], 1.9544890 secs] [Times: user=14.12 sys=0.00, real=1.95 secs]
2021-04-06T12:02:06.244+0000: 3872648.887: [GC [PSYoungGen: 737792K->8866K(863744K)] 2960588K->2231662K(3181056K), 0.1293030 secs] [Times: user=0.45 sys=0.02, real=0.13 secs]
2021-04-06T12:04:33.064+0000: 3872795.707: [GC [PSYoungGen: 863394K->20547K(836096K)] 3086190K->2248357K(3153408K), 0.1609850 secs] [Times: user=0.40 sys=0.00, real=0.16 secs]
2021-04-06T12:06:28.776+0000: 3872911.420: [GC [PSYoungGen: 835651K->11347K(789504K)] 3063461K->2258256K(3106816K), 0.1324430 secs] [Times: user=0.61 sys=0.00, real=0.13 secs]
2021-04-06T12:09:34.192+0000: 3873096.836: [GC [PSYoungGen: 789075K->17763K(760320K)] 3035984K->2268648K(3077632K), 0.1177770 secs] [Times: user=0.37 sys=0.06, real=0.12 secs]

Published by SangramKeshari

Bachelor of Engineering in Information Technology. Oracle Certified Database Administrator.

Leave a comment