Performance Troubleshooting from Performance Tester Perspective !

Performance Troubleshooting using 1) Jvisualvm 2) MAT 3) JMC

by Tobias Geyer

1) MAT : Memory Analyzer Tool from IBM , to find out cause of out of memory

Lines to generate heap dump for your java program.

-XX:+HeapDumpOnOutOfMemoryError

-XX:HeapDumpPath=C:\heapdumps

2) Jvisualvm : Live Monitoring of java instance with CPU & memory utilization.

3) Java Mission Control : JMC : Capturing java profiling snapshot & analyze it. for more information please refer link : How to Produce Flight Recording

-XX:+UnlockCommercialFeatures

-XX:FlightRecorder

Comments

Oracle Part

Process Increase due to error sometimes : SQL> connect / as sysdba ERROR: ORA-00020: maximum number of processes (300) exceeded or java.sql.SQLException: Listener refused the connection with the following error: ORA-12519, TNS:no appropriate service handler found Steps to increase the number for processes/sessions at database level in Oracle is as follows 1. Log on to the database as system administrator In SQL Plus enter: " connect / as sysdba " 2. Set the number of processes to be desired value In SQL Plus " alter system set processes= scope=spfile " 3. Unset the number of sessions to remove the default session limit In SQLPlus " alter system reset sessions scope=spfile sid='*' " 4. Shutdown the database In SQL Plus " shutdown immediate " 5. Startup the database In SQL Plus " startup " 6. Check the changes have taken effect. In SQL Plus...

Explain Plan Vs Execution Plan

Explain Plan DELETE PLAN_TABLE EXPLAIN PLAN FOR SELECT COUNT(*) FROM ARADMIN80.T3293 WHERE ((((T3293.C230000009 = 'MAINCHANGE') AND ((T3293.C301813800 = '20001-Test') OR (T3293.C1000000337 = '20001-Test')) AND (T3293.C1000003561 >= 1) AND (T3293.C1000003561 <= 9)) OR ((T3293.C230000009 = 'MAINHELPDESK') AND (T3293.C301813800 = '20001-Test') AND (T3293.C1000003561 >= 0) AND (T3293.C1000003561 <= 3)) OR ((T3293.C230000009 = 'MAINWORKORDER') AND (T3293.C301813800 = '20001-Test') AND ((T3293.C1000003561 = 0) OR (T3293.C1000003561 = 1) OR (T3293.C1000003561 = 2) OR (T3293.C1000003561 = 3) OR (T3293.C1000003561 = 4))) OR ((T3293.C230000009 = 'MAINKNOWLEDGEDATABASE') AND (T3293.C301813800 = '20001-Test') AND (T3293.C1000003561 >= 4) AND (T3293.C1000003561 <= 4)) OR ((T3293.C230000009 = 'MAINKNOWNERROR') AND (T3293.C301813800 = '20001-Test') AND (T3293.C1000003561 >=...

Ansible - Agentless Architecture DevOps

Ansible Ansible is an open source IT configuration management, deployment, and orchestration tool. It is unique from other management tools in many respects, aiming to provide large productivity gains to a wide variety of automation challenges. Example From YouTube - Short Videos - Quick to learn about Ansible :)

Gorakshnath

Search This Blog