Result_cache_remote_expiration

This is a discussion on Result_cache_remote_expiration within the Oracle FAQ forums in Oracle Database category; Type:Integer Default:0 Modify:ALTER SESSION, ALTER SYSTEM Range:0 to operating system-dependent Basic:No Notes:RESULT_CACHE_REMOTE_EXPIRATION specifies the number of minutes that a result using a remote object is allowed to remain valid. Setting this parameter to 0 implies that results using remote objects should not be cached. Ssetting this parameter to a nonzero value can produce stale answers (for example, if the remote table used by a result is modified at the remote database)....

Go Back   Database Forum > Oracle Database > Oracle FAQ

Database Forums

Register FAQ Calendar Search Today's Posts Mark Forums Read
  #1  
Old 02-04-2008, 07:01 AM
Post Result_cache_remote_expiration

Type:Integer
Default:0
Modify:ALTER SESSION, ALTER SYSTEM
Range:0 to operating system-dependent
Basic:No
Notes:RESULT_CACHE_REMOTE_EXPIRATION specifies the number of minutes that a result using a remote object is allowed to remain valid. Setting this parameter to 0 implies that results using remote objects should not be cached. Ssetting this parameter to a nonzero value can produce stale answers (for example, if the remote table used by a
result is modified at the remote database).
Reply With Quote
Reply


Thread Tools
Display Modes



All times are GMT -4. The time now is 06:12 PM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Integrated by bbpixel2008 :: jvbPlugin R1013.368.1

Search Engine Friendly URLs by vBSEO 3.1.0
vB Ad Management by =RedTyger=
In an effort to better serve ads to our visitors, cookies are used on Mydatabasesupport.com. For more information, check out our Privacy Policy.