In your database, you want to ensure that idle sessions that are blocking active are automatically
terminated after a specified period of time.
How would you accomplish this?
A.
Setting a metric threshold
B.
Implementing Database Resource Manager
C.
Enabling resumable timeout for user sessions
D.
Decreasing the value of the IDLE_TIME resource limit in the default profile
Explanation:
An Oracle session is sniped when you set the idle_time parameter to disconnect
inactive sessions. (It’s only like sniping on ebay in that a time is set for an action to occur.)Oracle has several ways to disconnect inactive or idle sessions, both from within SQL*Plus via
resources profiles (connect_time, idle_time), and with the SQL*net expire time parameter. Here
are two ways to disconnect an idle session:
Set the idle_time parameter in the user profile
Set the sqlnet.ora parameter expire_time
In my opinion D.Decreasing the value of the IDLE_TIME resource limit in the default profile
D
B Correct
IDEL_TIME is about generic idle time limit, not specifically blocking sessions. But question is about idle sessions blocking other sessions
http://docs.oracle.com/database/121/ADMIN/dbrm.htm#ADMIN11844
Limit the amount of time that a session can be idle. This can be further defined to mean only sessions that are blocking other sessions.
Willing is correct .
B is the right answer
D is incorrect as the parameter is MAX_IDLE_BLOCKER_TIME. So B is correct.
B
I think B is correct.
Database Resource Manager:
Idle Time: You can direct that a user’s session be terminated after it has been idle for a specified period of time. You can also specify that only idle sessions blocking other sessions be terminated.
Answer: B
I’m sure – D.
B Is correct.
Limit the amount of time that a session can be idle. This can be further defined to mean only sessions that are blocking other sessions.
http://docs.oracle.com/cd/B19306_01/server.102/b14231/dbrm.htm
Answer is B.
With the Resource Manager, you can:
Limit the amount of time that a session can be idle. This can be further defined to mean only sessions that are blocking other sessions.
B – with resource plan directive: MAX_IDLE_BLOCKER_TIME
D: Oracle documentation:
If a user exceeds the CONNECT_TIME or IDLE_TIME session resource limit, then the database rolls back the current transaction and ends the session. When the user process next issues a call, the database returns an error.
http://docs.oracle.com/database/121/SQLRF/statements_6012.htm#SQLRF01310
D does not stood valid for “blocking sessions”.
B is the answer.
https://docs.oracle.com/database/121/ADMIN/dbrm.htm#ADMIN027
Limit the amount of time that a session can be idle. This can be further defined to mean only sessions that are blocking other sessions.
Idle Time Limit
You can specify an amount of time that a session can be idle, after which it is terminated. You can also specify a more stringent idle time limit that applies to sessions that are idle and blocking other sessions
One of our guests recently suggested the following website.
usually posts some extremely fascinating stuff like this. If youre new to this site
one of our visitors a short while ago suggested the following website
we prefer to honor several other world wide web web sites around the internet, even though they arent linked to us, by linking to them. Below are some webpages worth checking out
Here are some of the websites we recommend for our visitors
very handful of websites that transpire to become comprehensive beneath, from our point of view are undoubtedly very well really worth checking out
Sites of interest we have a link to.
very few web-sites that happen to be comprehensive below, from our point of view are undoubtedly effectively really worth checking out
below youll discover the link to some sites that we assume you must visit
Every as soon as in a while we pick blogs that we study. Listed beneath would be the newest web-sites that we opt for
very couple of sites that take place to become detailed beneath, from our point of view are undoubtedly very well really worth checking out
usually posts some pretty interesting stuff like this. If you are new to this site
here are some links to sites that we link to for the reason that we assume they are really worth visiting
Here is a great Weblog You may Uncover Exciting that we Encourage You
just beneath, are a lot of absolutely not related web pages to ours, having said that, they may be certainly really worth going over
one of our visitors lately recommended the following website
just beneath, are several totally not associated internet sites to ours, however, they are certainly worth going over
Here is a great Blog You might Locate Fascinating that we Encourage You
very few websites that occur to be detailed beneath, from our point of view are undoubtedly properly really worth checking out
Here is an excellent Blog You might Come across Exciting that we Encourage You
B is correct, because the question is about “idle sessions that are blocking active” and this case is managed by resource manager, using MAX_IDLE_BLOCKER_TIME parameter of CREATE_PLAN_DIRECTIVE
That is really fascinating, You are an overly professional blogger. I have joined your rss feed and look ahead to searching for extra of your fantastic post. Also, I have shared your site in my social networks!
I and also my buddies were checking the good tips found on the blog and so immediately I got an awful suspicion I had not thanked the blog owner for those techniques. Those guys were as a result warmed to study all of them and have in reality been enjoying them. Appreciate your turning out to be very kind as well as for getting such very good things millions of individuals are really wanting to discover. Our own sincere apologies for not saying thanks to you earlier.