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
B ???
Agree with Lee. B seems correct. D is about generic idle time limit, not specifically blocking sessions. But question is about idle sessions blocking other sessions.
Lookup MAX_IDLE_BLOCKER_TIME which is part of the resource manager – http://docs.oracle.com/database/121/ADMIN/dbrm.htm#ADMIN11868
MAX_IDLE_BLOCKER_TIME sounds better option than Idle_time in profile. So answer should be B.
Agree with Lee & noname B correct
No the answer is D
http://www.dba-oracle.com/t_connect_time_idle_expire_timeout.htm
Sites of interest we have a link to.
The data mentioned inside the post are a few of the very best obtainable.
Here is a great Blog You may Come across Intriguing that we encourage you to visit.
One of our visitors not too long ago proposed the following website.
Sites of interest we have a link to
That may be the finish of this write-up. Here youll uncover some websites that we think youll value, just click the hyperlinks.
please check out the web-sites we follow, like this one, because it represents our picks through the web
we prefer to honor many other online web pages around the internet, even though they arent linked to us, by linking to them. Below are some webpages worth checking out
Every when in a while we pick blogs that we read. Listed beneath are the most up-to-date websites that we select
we like to honor many other world-wide-web internet sites around the web, even though they arent linked to us, by linking to them. Underneath are some webpages worth checking out
just beneath, are various absolutely not related websites to ours, even so, they may be certainly really worth going over
Every the moment inside a even though we choose blogs that we read. Listed beneath are the latest web pages that we pick
Sites of interest we have a link to
although web sites we backlink to below are considerably not connected to ours, we really feel they may be in fact worth a go by means of, so have a look
always a large fan of linking to bloggers that I appreciate but really don’t get a great deal of link appreciate from
one of our visitors not too long ago encouraged the following website
always a big fan of linking to bloggers that I really like but do not get a good deal of link adore from
just beneath, are many entirely not related web-sites to ours, even so, they are surely worth going over
Here are several of the web pages we advise for our visitors
Downpaod new Madden 17 Coin Glitch and Generator game!
Best Madden NFL 17 Coin Glitch and Generator for unlimied Cash and Coins!
DOWNLOAD LINK : Madden NFL 17 Coin Glich and Generator;
articletraderpro.com,
B