Jira User Session Requests

What is User Session Request value?

I am new, learning Sys Admin on downloaded Jira system connected to Oracle DB. The Oracle DB contains other data besides Jira and other application is having trouble running out of Oracle sessions or processes. Sometimes it appears to overload the physical resources if the machines trying to get to Oracle and sometimes it seems to be Oracle getting confused.

I am trying to rule out Jira application as source for problem. During earlier problems with other application, Jira DB monitoring shows less than 5 in connection pool (active or idle) and spike of Reads/Writes below 20 but the Current User Session Requests.

Thanks

4 answers

1 accepted

Hello Pat,

What you see in JIRA user sessions is related to sessions from users to Tomcat Service

for example, you same user has two browsers (crhome and firefox) conencted to Jira, this user will have 2 sessions on tomcat.

in your database pool you will see session between JIRA and your database server.

0 votes
Renjith Pillai Community Champion Jan 17, 2013

So what is your question? Can you elaborate what you meant by "User Session Requests"

I have one user that has been logged on for 1h 18h and has 733 requests and another user with 1043 requests logged in for 4d 19h.

The user @ 1043 is up from 843 this time yesterday.

Is a request any activity that connects to DB and not necessarily related to Reads or Writes?

Could this level of requests be possibly causing problems in Oracle DB?

Thanks

0 votes
Renjith Pillai Community Champion Jan 18, 2013

Where are you seeing these request counts?

If it is from JIRA page access, it can be due to many factors. Many plugins and pages does refresh automatically behind the scenes - dashboard gadgets, GreenHopper boards,view issue screen with Tempo plugin.

And what problems are you seeing int eh Oracle DB?

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

2,775 views 11 18
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot