Scenario: Concurrent Requests are in Running Normal state for longer time than normal duration of the Program.
Analysis:
Step 1: Navigate to System Administrator Responsibility : Concurrent Manager –> Administer
Identify the Concurrent Requests which are in Running Status.
Get the Database Session Details of the currently running concurrent requests using the below Query:
SELECT DISTINCT a.request_id,C.INST_ID, d.sid, d.serial# ,d.osuser,d.process , c.SPID ,d.inst_id
FROM apps.fnd_concurrent_requests a,
apps.fnd_concurrent_processes b,
gv$process c,
gv$session d
WHERE a.controlling_manager = b.concurrent_process_id
AND c.pid = b.oracle_process_id
AND b.session_id=d.audsid
AND a.phase_code = ‘R’ and a.status_coDe=’R’;
Step 2: Verify if the database sessions are active/Inactive at the database level using the below query.
select inst_id,sid,serial#,program,module,status,last_call_et,sql_id from gv$session where sid=&sid;
— sid value to be taken from output of Sql Query in Step 1
If Database session is INACTIVE And Running no sql for more than an Hour, we can Terminate the Concurrent Requests.
If the Database session is ACTIVE and has an SQL_ID attached with it, Need to check on tuning the sql being run by the database session.
I will cover more details about SQL Tuning in another post.
naturally like your web site however you need to take a look at the spelling on several of your posts. A number of them are rife with spelling problems and I find it very bothersome to tell the truth on the other hand I will surely come again again.
This should be featured everywhere.
It was a pleasure reading this.
I’d like to find out more? I’d love to find out more details. http://www.kayswell.com
Another thing I have really noticed is for many people, poor credit is the consequence of circumstances above their control. Such as they may be really saddled by having an illness so they really have large bills for collections. Maybe it’s due to a occupation loss or inability to work. Sometimes breakup can send the funds in the wrong direction. Thanks for sharing your opinions on this blog.
This article is a gem.
Super insightful and fresh perspective.
Thank you for providing me with these article examples. May I ask you a question? http://www.kayswell.com
Thank you for providing me with these article examples. May I ask you a question? http://www.kayswell.com
I’ll definitely be coming back for more.
Thank you for your articles. They are very helpful to me. May I ask you a question? http://www.kayswell.com
It’s in point of fact a great and useful piece of info.I am glad that you just shared this useful info with us.Please keep us informed like this. Thanks for sharing.
Hello, i read your blog occasionally and i own a similar one and i was just curious if you get a lot of spam feedback? If so how do you stop it, any plugin or anything you can recommend? I get so much lately it’s driving me insane so any help is very much appreciated.
Wow, marvelous weblog structure! How long have you ever been running a blog for? you make running a blog glance easy. The overall look of your web site is wonderful, as smartly as the content material! http://www.kayswell.com
It’s a pity you don’t have a donate button! I’d definitely donate to this fantastic blog! I guess for now i’ll settle for bookmarking and adding your RSS feed to my Google account. I look forward to new updates and will share this blog with my Facebook group. Talk soon! http://www.kayswell.com
Hi, i think that i saw you visited my weblog so i came to “return the favor”.I am trying to find things to enhance my site!I suppose its ok to use some of your ideas!! http://www.kayswell.com
Greate article. Keep posting such kind of info on your site. Im really impressed by your site. Hi there, You have done an excellent job. I’ll definitely digg it and individually suggest to my friends. I am sure they will be benefited from this web site. http://www.ifashionstyles.com
We’re a group of volunteers and starting a new scheme in our community. Your website offered us with helpful information to work on. You’ve done a formidable task and our whole community will be thankful to you. http://www.ifashionstyles.com
You should be a part of a contest for one of the finest blogs on the net. I’m going to highly recommend this blog!
Pretty section of content. I just stumbled upon your site and in accession capital to assert that I get in fact enjoyed account your blog posts. Any way I抣l be subscribing to your feeds and even I achievement you access consistently rapidly.
Hey there! Would you mind if I share your blog with my myspace group? There’s a lot of people that I think would really enjoy your content. Please let me know. Thanks
generally lost just trying to figure out how to begin. Any ideas or tips? http://www.kayswell.com
Hi there, just became alert to your blog through Google,and found that it is truly informative. I am gonna watch outfor brussels. I’ll be grateful if you continue this in future.Lots of people will be benefited from your writing.Cheers! http://www.kayswell.com
Hi to every body, it’s my first pay a visit of this weblog; this weblog contains remarkable and genuinely excellent material designed for readers.
Fantastic blog! Do you have any tips for aspiring writers? I’m planning to start my own website soon but I’m a little lost on everything. Would you suggest starting with a free platform like WordPress or go for a paid option? There are so many options out there that I’m totally confused .. Any ideas?
Hello, i read your blog occasionally and i own a similar one and i was just curious if you get a lot of spam feedback? If so how do you stop it, any plugin or anything you can recommend? I get so much lately it’s driving me insane so any help is very much appreciated.
This is a topic that’s near to my heart… Many thanks! Where are your contact details though?
What’s Going down i’m new to this, I stumbled upon this I have discovered It absolutely useful and it has aided me out loads. I am hoping to give a contribution & assist other users like its helped me. Great job.
What i do not understood is actually how you’re no longer really much more well-preferred than you may be now. You’re very intelligent. You know thus significantly in terms of this subject, made me personally believe it from a lot of numerous angles. http://www.ifashionstyles.com Its like men and women aren’t interested unless it’s something to do with Girl gaga! Your individual stuffs great. At all times deal with it up!
Superb post however , I was wanting to know if you could write a litte more on this subject? I’d be very grateful if you could elaborate a little bit further.
These are actually great ideas in about blogging. You have touched some pleasant things here. Any way keep up wrinting.
Hello very nice web site!! Man .. Beautiful .. Amazing .. I will bookmark your site and take the feeds also? I am satisfied to seek out so many useful information here in the put up, we want work out extra techniques on this regard, thank you for sharing.
What’s up i am kavin, its my first time to commenting anywhere, when i read this paragraph i thought i could also make comment due to this sensible post. http://www.kayswell.com
Great post. I was checking constantly this blog and I am impressed! Extremely useful information specifically the last part 🙂 I care for such information a lot. I was seeking this certain info for a long time. Thank you and good luck. http://www.ifashionstyles.com
Thanks , I’ve just been looking for information approximately this topic for a while and yours is the greatest I’ve found out so far. But, what about the conclusion? Are you certain about the supply? http://www.ifashionstyles.com
Attractive portion of content. I simply stumbled upon your website and in accession capital to assert that I get actually loved account your weblog posts. Anyway I will be subscribing to your augment and even I fulfillment you get right of entry to consistently rapidly.
Thank you for the auspicious writeup. It in fact was a amusement account it. Look advanced to far added agreeable from you! By the way, how could we communicate?
Hi there to every one, since I am really eager of reading this blog’s post to be updated on a regular basis. It includes fastidious data. http://www.kayswell.com
Thank you for another great article. Where else may just anybody get that kind of information in such an ideal means of writing? I have a presentation next week, and I’m on the look for such information.