During some scheduled maintenance activities, oracle apps database administrator would require to keep the Pending Jobs on Hold before bounce and release them after the scheduled activity.
This process help to bring down Concurrent Manager quickly and the pending jobs are preserved for running after the maintenance is complete.
This process help to bring down Concurrent Manager quickly and the pending jobs are preserved for running after the maintenance is complete.
1) Create table apps.conc_req_on_hold as select * from fnd_Concurrent_requests where PHASE_CODE=’P’ and hold_flag=’N’;
2) select count(*) from apps.conc_req_on_hold
3) update fnd_Concurrent_requests set hold_flag=’Y’ where PHASE_CODE=’P’ and hold_flag=’N’ and request_id in (select request_id from apps.conc_req_on_hold);
NOTE: You have to commit if select & update are same number of records. Otherwise rollback and try again till the numbers are same
4) Commit;
To Release hold on Concurrent Requests patching, run the below sql :
5) update fnd_Concurrent_requests set hold_flag=’N’ where request_id in (select request_id from apps.conc_req_on_hold);
6)Commit the changes
commit;
Iam so thrilled because of finding your alluring website here.Actually i was searching for Oracle RAC.Your blog is so astounding and informative too..Iam very happy to find such a creative blog. Iam also find another one by mistake while am searching the same topicOracle SQL.Thank you soo much..
Good info. Lucky me I recently found your blog by chance (stumbleupon).
I’ve book-marked it for later!
Review my web blog; nordvpn coupons inspiresensation (Wall.sh)
Very quickly this web page will be famous among all blog visitors, due to it’s
pleasant content
Here is my site :: nordvpn coupons inspiresensation – http://t.co/,
Hello my friend! I wish to say that this post is awesome, great written and come with almost all vital infos.
I would like to see more posts like this .
my website – nordvpn coupons inspiresensation (ur.link)
Have you ever thought about writing an e-book or guest authoring on other websites?
I have a blog based on the same topics you discuss and would love to have
you share some stories/information. I know my visitors would
value your work. If you are even remotely interested, feel free to send me an email.
My blog post – nordvpn coupons inspiresensation
350fairfax nordvpn code
you are truly a just right webmaster. The site loading speed is incredible.
It seems that you’re doing any unique trick. Moreover, The contents are
masterwork. you’ve done a magnificent activity in this topic!
I do believe all of the ideas you have offered to
your post. They are very convincing and can certainly work.
Nonetheless, the posts are too brief for novices. May you please
lengthen them a little from next time? Thanks
for the post.
My homepage – Eharmony Special Coupon Code 2025
Very good information. Lucky me I recently found your blog by accident (stumbleupon).
I have saved as a favorite for later!
my homepage – vpn
You’re so awesome! I don’t believe I have read a single thing like that before. So great to find someone with some original thoughts on this topic. Really.. thank you for starting this up. This website is something that is needed on the internet, someone with a little originality!
Awesome! Its genuinely remarkable post, I have got much clear idea regarding from this post
I’m often to blogging and i really appreciate your content. The article has actually peaks my interest. I’m going to bookmark your web site and maintain checking for brand spanking new information.
Hello There. I found your blog using msn. This is a very well written article.
I’ll make sure to bookmark it and come back to read extra of your helpful info.
Thank you for the post. I will definitely return. https://tinyurl.com/24dyn2m6 what vpn means
This helped me a lot, thank you.
An impressive share! I’ve just forwarded this onto a colleague who had been doing a little research on this.
And he in fact ordered me lunch due to the fact that I found
it for him… lol. So allow me to reword this….
Thanks for the meal!! But yeah, thanks for spending some time to
discuss this subject here on your internet site.
I want to to thank you for this wonderful read!! I certainly enjoyed every bit of it.
I have you saved as a favorite to look at new things you post…
It was a pleasure reading this.
Bookmarking this for later.
For the reason that the admin of this site is working, no uncertainty very quickly it will be renowned, due to its quality contents.
Thank you for your articles. They are very helpful to me. May I ask you a question? http://www.kayswell.com
You helped me a lot by posting this article and I love what I’m learning. http://www.kayswell.com
Great beat ! I would like to apprentice while you amend your web site, http://www.kayswell.com how could i subscribe for a blog site? The account helped me a acceptable deal. I had been a little bit acquainted of this your broadcast provided bright clear concept
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.
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. http://www.kayswell.com
Good post however , I was wanting to know if you could write a litte more on this topic? I’d be very thankful if you could elaborate a little bit more. Thank you! http://www.kayswell.com
I used to be able to find good advice from your blog articles. http://www.kayswell.com
I am not sure where you are getting your info, but good topic. I needs to spend some time learning more or understanding more. Thanks for excellent info I was looking for this information for my mission. http://www.kayswell.com