Understanding JProfiler Threads
I'm working on a Spring Batch Application where it is fetching data from the Oracle database. It contains around 20L of data. I implemented AsynchronousTaskExecutor with a concurrency limit of 20, the throttle limit is 10. For data source it is - spring.datasource.max-active=50
Following is the Thread Graph (JProfiler) for my application. It shows more threads in a blocked and waiting state. I want to understand why it's like this. Also, how can I improve the performance of the batch?
Solution
You have to use the views in the "Monitors & Locks" section to get more information about locking sections. If you record monitors there, the threads view (in your screen shot) will have tool tips with stack traces on waiting and blocking states.
- Spring Batch FlatFileItemWriter - How to use stepExecution.jobId to generate file name
- Pass filenames dynamically to FlatFileItemWriter through StepBuilderFactory stream() when using ClassifierCompositeItemProcessor in SpringBatch
- Start a spring batch job when already within a transaction
- Generic method to convert List<CustomObject> to Chunk<CustomObject>
- I am getting error Table 'test.batch_job_instance' doesn't exist
- PreparedStatementCallback; bad SQL grammar [SELECT JOB_INSTANCE_ID, JOB_NAME from BATCH_JOB_INSTANCE where JOB_NAME = ? and JOB_KEY =?
- How to execute a Spring batch job which can read data from database on regular interval
- Expecting Spring Batch job to end but continued to next step
- Spring Batch - Skip Record On Process
- Routing data to multiple files in item writer based on item's property as criteria
- Spring batch: Input resource does not exist class path resource
- javax.management.InstanceNotFoundException: org.springframework.boot:type=Admin,name=SpringApplication
- spring batch: required a bean named 'dataSource' that could not be found
- Spring Batch 5.1.1 JdbcItemReader Not Read db (Spring boot 3.2.5 , Kotlin ,progresql)
- JdbcPagingItemReader is missing to read few records when used with SimpleAsyncTaskExecutor
- Spring Batch Job is failing After upgrading to Spring batch5x version with other Spring libs with Java 17
- Failed to configure a DataSource: 'url' attribute is not specified and no embedded datasource could be configured
- How to create Spring Batch separate class implementation for item reader
- Spring Batch FlatFileItemWriter - output customization
- Parameter 0 of constructor in required a bean of type 'java.lang.String' that could not be found
- Spring batch running processor/writer number of times as chunk size
- InvalidDataAccessApiUsageException: Executing an update/delete query in spring batch
- How to disable/avoid linesToSkp(1) from next file onwards in spring batch while processing large csv file
- Stream file in chunks with sftp streaming inbound adapter
- Spring batch job run only one instance at any time
- JDBC driver is mapping date to java.util.Timestamp which is getting converted into datetime2 in sqlserver causing issue in data comparison
- Unknown Http calls in logs
- NoUniqueBeanDefinitionException :expected single matching bean but found 2
- AOP configuration seems to be invalid - Spring batch (Skip Listener)
- Spring Batch : async with AsyncItemProcessor and AsyncItemWriter