function FileData_Pairs(x) { x.t("example","application"); x.t("four","round"); x.t("statements","improve"); x.t("statements","cached"); x.t("statements","wait"); x.t("statements","cursor"); x.t("min","pool"); x.t("ignore","value"); x.t("sqlnumresultcols","forth"); x.t("degrade","performance"); x.t("enabling","attribute"); x.t("considerations","oracle"); x.t("considerations","performance"); x.t("considerations","following"); x.t("available","rather"); x.t("available","oracle"); x.t("available","maximum"); x.t("available","setting"); x.t("columns","(defaultlongdatabufflen)"); x.t("columns","data"); x.t("synonym","information"); x.t("(connectionpooling)","enable"); x.t("method","encryptionmethod"); x.t("(0)","return"); x.t("provide","tremendous"); x.t("improvements","significantly"); x.t("trips","network"); x.t("200","rows"); x.t("rather","creating"); x.t("rather","created"); x.t("improved","performance"); x.t("improved","case"); x.t("balance","timeout"); x.t("sqlcolattribute","(s)"); x.t("locked","user"); x.t("locked","data"); x.t("procedureretresults","attribute"); x.t("retrieving","synonym"); x.t("retrieving","long"); x.t("retrieving","comments/remarks"); x.t("oversized","buffer"); x.t("within","specific"); x.t("needs","access"); x.t("needs","handle"); x.t("workload","oracle"); x.t("workload","assigned"); x.t("workload","therefore"); x.t("refer","chapter"); x.t("description","cached"); x.t("description","retrieved"); x.t("description","limit"); x.t("description","catalog"); x.t("description","query"); x.t("trade-off","consider"); x.t("static","keyset"); x.t("static","cursors"); x.t("encryptionmethod","data"); x.t("failover","mode"); x.t("table","server"); x.t("keep","connections"); x.t("timespan","exceeds"); x.t("binary","data"); x.t("instance","request"); x.t("disabling","option"); x.t("required","encrypt"); x.t("dbms_session","value"); x.t("improve","performance"); x.t("(cachedcursorlimit)","improve"); x.t("(enablebulkload)","application"); x.t("performs","bulk"); x.t("action","sets"); x.t("action","column"); x.t("locking","prevents"); x.t("descriptions","select"); x.t("descriptions","include"); x.t("exact-text","match"); x.t("tables","modified"); x.t("tables","performance"); x.t("enabled","however"); x.t("enabled","oracle"); x.t("enabled","attribute"); x.t("enabled","option"); x.t("enabled","result"); x.t("enabled","application"); x.t("enabled","driver"); x.t("current","user"); x.t("current","time"); x.t("current","schema"); x.t("destroyed","min"); x.t("prepared","statement"); x.t("user","oracle"); x.t("user","performance"); x.t("user","sets"); x.t("user","executing"); x.t("logon","used"); x.t("coordinate","database"); x.t("coordinate","operations"); x.t("cache","available"); x.t("cache","rather"); x.t("cache","description"); x.t("cache","descriptions"); x.t("cache","cursor"); x.t("last","used"); x.t("uses","static"); x.t("(scrollable)","cursors"); x.t("program","sets"); x.t("program","value"); x.t("platforms","additional"); x.t("errors","driver"); x.t("statement","increase"); x.t("statement","contains"); x.t("modified","without"); x.t("mode","(failovermode)"); x.t("administrator","determine"); x.t("serve","application"); x.t("open","select"); x.t("type","(servertype)"); x.t("type","length"); x.t("(defaultlongdatabufflen)","improve"); x.t("times","improve"); x.t("classify","work"); x.t("tremendous","performance"); x.t("batch","environment"); x.t("calls","catalog"); x.t("calls","different"); x.t("calls","following"); x.t("time","timespan"); x.t("time","instance"); x.t("time","connection"); x.t("time","during"); x.t("time","network"); x.t("time","wasted"); x.t("reset","resetting"); x.t("scrollable","cursors"); x.t("connection","destroyed"); x.t("connection","last"); x.t("connection","reset"); x.t("connection","disconnect"); x.t("connection","become"); x.t("connection","pooling"); x.t("connection","closed"); x.t("connection","string"); x.t("connection","options"); x.t("connection","unique"); x.t("connection","initial"); x.t("connection","identifier"); x.t("connection","issue"); x.t("connection","made"); x.t("connection","schemaname"); x.t("connection","pool"); x.t("connection","server"); x.t("cached","description"); x.t("cached","cursor"); x.t("cached","case"); x.t("multiple","times"); x.t("however","degrade"); x.t("however","needs"); x.t("execution","keeps"); x.t("needed","driver"); x.t("sqlcolumns","return"); x.t("sqlcolumns","result"); x.t("exceeds","value"); x.t("resetting","re-used"); x.t("default","buffer"); x.t("text","binary"); x.t("require","result"); x.t("lock","timeouts"); x.t("lock","timeout"); x.t("lock","released"); x.t("automatically","adjusts"); x.t("usecurrentschema","attribute"); x.t("details","application"); x.t("retrieved","cache"); x.t("retrieved","otherwise"); x.t("retrieved","server"); x.t("new","cached"); x.t("new","result"); x.t("access","database"); x.t("access","comments/remarks"); x.t("low","cause"); x.t("bulk","loading"); x.t("bulk","load"); x.t("(servertype)","using"); x.t("disconnect","process"); x.t("servers","thread"); x.t("servers","running"); x.t("objects","owned"); x.t("size","connection"); x.t("size","large"); x.t("size","specified"); x.t("size","option"); x.t("size","accommodate"); x.t("size","long/lob"); x.t("size","data"); x.t("size","(arraysize)"); x.t("size","setting"); x.t("size","increased"); x.t("(catalogincludessynonyms)","standard"); x.t("amounts","data"); x.t("resultset","caching"); x.t("adversely","affect"); x.t("appropriately","driver"); x.t("need","access"); x.t("need","return"); x.t("(catalogoptions)","application"); x.t("cpu","memory"); x.t("cpu","usage"); x.t("indefinitely","lock"); x.t("indefinitely","continuing"); x.t("info","sets"); x.t("during","four"); x.t("cachedcursorlimit","attribute"); x.t("benefit","waiting"); x.t("machine","value"); x.t("network","example"); x.t("network","cached"); x.t("network","traffic"); x.t("network","retrieve"); x.t("normally","retrieves"); x.t("exceed","load"); x.t("images","pictures"); x.t("increase","performance"); x.t("(failovermode)","although"); x.t("timeouts","properly"); x.t("timeouts","deadlocks"); x.t("results","(procedureretresults)"); x.t("results","case"); x.t("(usecurrentschema)","application"); x.t("become","available"); x.t("large","amounts"); x.t("large","enough"); x.t("traffic","application"); x.t("sqlexecute","prepared"); x.t("configuring","driver"); x.t("availability","replays"); x.t("locks","although"); x.t("pooling","(connectionpooling)"); x.t("pooling","additional"); x.t("high","availability"); x.t("high","wastes"); x.t("specified","connection"); x.t("requires","extra"); x.t("constraints","enableserverresultcache"); x.t("handle","lock"); x.t("directly","application"); x.t("creating","new"); x.t("union","subquery"); x.t("settings","impacts"); x.t("connects","oracle"); x.t("connects","database"); x.t("functionality","instead"); x.t("functionality","bypass"); x.t("stored","procedures"); x.t("stored","client"); x.t("wait","indefinitely"); x.t("name","sets"); x.t("performance","considerations"); x.t("performance","improvements"); x.t("performance","retrieving"); x.t("performance","disabling"); x.t("performance","descriptions"); x.t("performance","configuring"); x.t("performance","reduced"); x.t("performance","optimization"); x.t("performance","attribute"); x.t("performance","tied"); x.t("performance","odbc"); x.t("performance","catalogincludessynonyms"); x.t("performance","enhance"); x.t("performance","application's"); x.t("performance","consider"); x.t("performance","additional"); x.t("performance","accounting"); x.t("performance","application"); x.t("performance","efficient"); x.t("performance","either"); x.t("performance","using"); x.t("performance","load"); x.t("performance","negatively"); x.t("performance","increased"); x.t("oracle","servers"); x.t("oracle","provides"); x.t("oracle","wire"); x.t("oracle","feature"); x.t("oracle","stores"); x.t("oracle","database"); x.t("oracle","executes"); x.t("oracle","applications"); x.t("oracle","server"); x.t("oracle","resources"); x.t("identifiers","cached"); x.t("identifiers","cachedcursorlimit"); x.t("identifiers","closed"); x.t("closed","cache"); x.t("closed","connection"); x.t("populated","connections"); x.t("retains","number"); x.t("limit","(cachedcursorlimit)"); x.t("limit","(cacheddesclimit)"); x.t("sqlstatistics","sqlprocedurecolumns"); x.t("accordingly","describe"); x.t("sqldescribecol","sqlnumresultcols"); x.t("argument","catalog"); x.t("synonyms","(catalogincludessynonyms)"); x.t("synonyms","result"); x.t("synonyms","using"); x.t("reduced","transferring"); x.t("provides","three"); x.t("provides","increased"); x.t("datadirect","connect"); x.t("standard","odbc"); x.t("transferring","large"); x.t("keyset","(scrollable)"); x.t("determine","setting"); x.t("client_identifier","value"); x.t("optimized","grouping"); x.t("loading","data"); x.t("adjusts","server"); x.t("allows","application"); x.t("away","socket"); x.t("wire","protocol"); x.t("optimization","datadirect"); x.t("coordinates","concurrent"); x.t("concurrent","open"); x.t("concurrent","select"); x.t("concurrent","database"); x.t("array","size"); x.t("array","binding"); x.t("string","connects"); x.t("string","attribute"); x.t("(cacheddesclimit)","driver"); x.t("integrity","constraints"); x.t("entire","result"); x.t("attempt","select"); x.t("(procedureretresults)","driver"); x.t("sets","dbms_session"); x.t("sets","action"); x.t("sets","machine"); x.t("sets","client_identifier"); x.t("sets","osuser"); x.t("sets","process"); x.t("sets","client_info"); x.t("attribute","enabled"); x.t("attribute","appropriately"); x.t("attribute","equivalent"); x.t("attribute","disabled"); x.t("attribute","appropriate"); x.t("round","trips"); x.t("column_def","catalog"); x.t("contain","low"); x.t("extra","network"); x.t("three","options"); x.t("procedures","return"); x.t("thread","oracle"); x.t("thread","windows"); x.t("resource","usage"); x.t("sharing","oracle"); x.t("retrieves","200"); x.t("retrieves","images"); x.t("retrieves","data"); x.t("functions","calls"); x.t("functions","optimized"); x.t("functions","sqltables"); x.t("functions","include"); x.t("functions","sqlprocedures"); x.t("functions","driver"); x.t("request","information"); x.t("enableserverresultcache","application"); x.t("(locktimeout)","sometimes"); x.t("queries","enabling"); x.t("queries","throughout"); x.t("queries","failure"); x.t("commands","server"); x.t("sometimes","users"); x.t("error","lock"); x.t("error","immediately"); x.t("equivalent","passing"); x.t("catalog","functions"); x.t("catalog","options"); x.t("catalog","function"); x.t("decrypt","data"); x.t("know","database"); x.t("options","(catalogoptions)"); x.t("options","affects"); x.t("options","accessing"); x.t("options","affect"); x.t("options","enhance"); x.t("reason","coordinate"); x.t("select","statements"); x.t("select","data"); x.t("select","update"); x.t("issues","fixed"); x.t("fixed","sql"); x.t("life","application"); x.t("long","keep"); x.t("long","text"); x.t("long","data"); x.t("first","connection"); x.t("minimum","pool"); x.t("feature","classify"); x.t("feature","automatically"); x.t("feature","server-side"); x.t("(enablescrollablecursors)","enable"); x.t("replays","queries"); x.t("affects","performance"); x.t("executing","catalog"); x.t("number","columns"); x.t("number","high"); x.t("number","concurrent"); x.t("number","round"); x.t("number","connections"); x.t("number","seconds"); x.t("cause","delays"); x.t("cause","connections"); x.t("re-used","connection"); x.t("underlying","tables"); x.t("processing","time"); x.t("processing","capacity"); x.t("design","refer"); x.t("retrieve","200"); x.t("retrieve","long"); x.t("retrieve","rows"); x.t("length","scale"); x.t("function","sqlcolumns"); x.t("max","pool"); x.t("maximum","size"); x.t("maximum","number"); x.t("maximum","amount"); x.t("maximum","load"); x.t("enough","accommodate"); x.t("continuing","execution"); x.t("tied","workload"); x.t("ultimately","service"); x.t("v$session","table"); x.t("chapter","designing"); x.t("different","threads"); x.t("cannot","cache"); x.t("sqltables","sqlcolumns"); x.t("define","long"); x.t("unique","connection"); x.t("pictures","long"); x.t("enablescrollablecursors","attribute"); x.t("may","adversely"); x.t("may","benefit"); x.t("odbc","calls"); x.t("odbc","reference"); x.t("odbc","application"); x.t("odbc","applications"); x.t("odbc","behavior"); x.t("instead","database"); x.t("stores","result"); x.t("accessing","locked"); x.t("hanging","application"); x.t("application\u2019s","performance"); x.t("unix","servers"); x.t("unix","thread"); x.t("degraded","sharing"); x.t("applicationusingthreads","attribute"); x.t("match","clause"); x.t("returned","database"); x.t("encrypt","decrypt"); x.t("properly","appropriate"); x.t("handling","lock"); x.t("osuser","value"); x.t("socket","connection"); x.t("cursor","identifiers"); x.t("cursor","limit"); x.t("cursor","identifier"); x.t("catalogincludessynonyms","attribute"); x.t("initial","configuration"); x.t("calling","sqlexecute"); x.t("assigned","ultimately"); x.t("capacity","memory"); x.t("reference","details"); x.t("enable","static"); x.t("enable","scrollable"); x.t("enable","bulk"); x.t("enable","application"); x.t("enable","driver"); x.t("rows","time"); x.t("rows","efficient"); x.t("identifier","needed"); x.t("identifier","retrieved"); x.t("reduces","performance"); x.t("prepare","time"); x.t("prepare","describeatprepare"); x.t("forth","calling"); x.t("system's","bulk"); x.t("client","improve"); x.t("client","user"); x.t("client","sets"); x.t("client","information"); x.t("client","host"); x.t("dedicated","server"); x.t("excess","processing"); x.t("designing","odbc"); x.t("designing","application"); x.t("disabled","retrieving"); x.t("disabled","catalog"); x.t("disabled","client"); x.t("disabled","note"); x.t("return","results"); x.t("return","synonyms"); x.t("return","error"); x.t("return","actual"); x.t("database","tables"); x.t("database","program"); x.t("database","administrator"); x.t("database","objects"); x.t("database","array"); x.t("database","system's"); x.t("database","memory"); x.t("database","environment"); x.t("database","used"); x.t("database","operations"); x.t("database","pool"); x.t("option","available"); x.t("option","connection"); x.t("option","requires"); x.t("option","array"); x.t("option","cause"); x.t("option","enable"); x.t("option","(dedicated)"); x.t("option","procedure"); x.t("throughout","life"); x.t("affect","performance"); x.t("issue","additional"); x.t("accommodate","maximum"); x.t("server-side","resultset"); x.t("memory","available"); x.t("memory","underlying"); x.t("memory","based"); x.t("memory","subsequent"); x.t("environment","client"); x.t("environment","lower"); x.t("lower","numbers"); x.t("schema","sqlprocedures"); x.t("enhance","performance"); x.t("enhance","driver"); x.t("(applicationusingthreads)","driver"); x.t("actual","values"); x.t("enter","number"); x.t("enter","value"); x.t("application's","stored"); x.t("acquiring","locks"); x.t("compared","current"); x.t("consider","improved"); x.t("consider","designing"); x.t("encryption","method"); x.t("encryption","may"); x.t("(-1)","return"); x.t("windows","platforms"); x.t("windows","created"); x.t("made","directly"); x.t("less","option"); x.t("include","synonyms"); x.t("include","number"); x.t("configuration","settings"); x.t("long/lob","columns"); x.t("amount","data"); x.t("failure","provides"); x.t("keeps","application"); x.t("wasted","handling"); x.t("additional","resource"); x.t("additional","commands"); x.t("additional","options"); x.t("additional","overhead"); x.t("value","connection"); x.t("value","default"); x.t("value","v$session"); x.t("value","option"); x.t("value","database"); x.t("value","otherwise"); x.t("value","load"); x.t("usage","required"); x.t("usage","server"); x.t("running","windows"); x.t("sqlprocedurecolumns","retrieving"); x.t("delays","waiting"); x.t("bypass","data"); x.t("specific","number"); x.t("schemaname","argument"); x.t("connections","ignore"); x.t("connections","exceed"); x.t("connections","oracle"); x.t("connections","minimum"); x.t("connections","pool"); x.t("connections","even"); x.t("waiting","connection"); x.t("waiting","indefinitely"); x.t("executions","query"); x.t("process","provide"); x.t("process","type"); x.t("process","away"); x.t("process","unix"); x.t("process","value"); x.t("process","query"); x.t("accounting","info"); x.t("although","locking"); x.t("although","high"); x.t("takes","cache"); x.t("subquery","driver"); x.t("(s)","sqldescribecol"); x.t("tuned","improved"); x.t("remarks","catalog"); x.t("impacts","performance"); x.t("cursors","entire"); x.t("cursors","(enablescrollablecursors)"); x.t("cursors","long"); x.t("cursors","enablescrollablecursors"); x.t("cursors","encryption"); x.t("cursors","enablestaticcursorsforlongdata"); x.t("query","cached"); x.t("query","multiple"); x.t("query","result"); x.t("query","formulate"); x.t("data","locked"); x.t("data","oversized"); x.t("data","static"); x.t("data","failover"); x.t("data","improve"); x.t("data","type"); x.t("data","retrieved"); x.t("data","integrity"); x.t("data","select"); x.t("data","encryption"); x.t("data","using"); x.t("data","forward-only"); x.t("data","enablestaticcursorsforlongdata"); x.t("data","buffer"); x.t("information","coordinate"); x.t("information","oracle"); x.t("information","feature"); x.t("information","prepare"); x.t("information","client"); x.t("information","degrades"); x.t("information","result"); x.t("overhead","lock"); x.t("overhead","mainly"); x.t("client_info","value"); x.t("host","name"); x.t("module","sets"); x.t("decreases","performance"); x.t("(arraysize)","connection"); x.t("appropriate","number"); x.t("appropriate","timeout"); x.t("result","calls"); x.t("result","stored"); x.t("result","returned"); x.t("result","enable"); x.t("result","database"); x.t("result","information"); x.t("result","column"); x.t("result","caching"); x.t("result","using"); x.t("degrades","performance"); x.t("catalogoptions","attribute"); x.t("timeout","(locktimeout)"); x.t("timeout","define"); x.t("timeout","option"); x.t("timeout","value"); x.t("protection","adversely"); x.t("application","improved"); x.t("application","needs"); x.t("application","description"); x.t("application","performs"); x.t("application","uses"); x.t("application","however"); x.t("application","connection"); x.t("application","require"); x.t("application","need"); x.t("application","normally"); x.t("application","connects"); x.t("application","name"); x.t("application","retrieves"); x.t("application","issues"); x.t("application","design"); x.t("application","retrieve"); x.t("application","odbc"); x.t("application","hanging"); x.t("application","degraded"); x.t("application","enable"); x.t("application","client"); x.t("application","dedicated"); x.t("application","reducing"); x.t("application","executes"); x.t("application","using"); x.t("application","therefore"); x.t("application","fetches"); x.t("case","procedureretresults"); x.t("case","usecurrentschema"); x.t("case","applicationusingthreads"); x.t("case","cursor"); x.t("case","catalogoptions"); x.t("scale","column"); x.t("values","connection"); x.t("significantly","less"); x.t("significantly","resources"); x.t("(dedicated)","batch"); x.t("efficient","application"); x.t("efficient","driver"); x.t("reducing","number"); x.t("procedure","returns"); x.t("owned","current"); x.t("protocol","driver"); x.t("note","option"); x.t("note","using"); x.t("executes","concurrent"); x.t("executes","query"); x.t("column","column_def"); x.t("column","v$session"); x.t("column","remarks"); x.t("column","matching"); x.t("done","exact-text"); x.t("comments/remarks","database"); x.t("comments/remarks","degrades"); x.t("otherwise","performance"); x.t("otherwise","processing"); x.t("users","attempt"); x.t("deadlocks","undetected"); x.t("applications","current"); x.t("applications","performance"); x.t("applications","may"); x.t("prevents","errors"); x.t("based","service"); x.t("work","know"); x.t("created","serve"); x.t("created","connection"); x.t("created","first"); x.t("sqlprocedures","(usecurrentschema)"); x.t("sqlprocedures","sqlstatistics"); x.t("immediately","(0)"); x.t("numbers","connections"); x.t("following","connection"); x.t("following","catalog"); x.t("following","options"); x.t("multi-threaded","application"); x.t("clause","statement"); x.t("used","connection"); x.t("used","client"); x.t("used","compared"); x.t("caching","enabled"); x.t("caching","server"); x.t("undetected","improve"); x.t("either","enter"); x.t("service","class"); x.t("performance-sensitive","application"); x.t("connect","series"); x.t("using","sqlcolattribute"); x.t("using","static"); x.t("using","bulk"); x.t("using","oracle"); x.t("using","catalog"); x.t("using","dedicated"); x.t("using","multi-threaded"); x.t("using","threads"); x.t("setting","number"); x.t("setting","maximum"); x.t("setting","following"); x.t("mainly","cpu"); x.t("class","associated"); x.t("series","odbc"); x.t("wastes","resources"); x.t("subsequent","executions"); x.t("levels","protection"); x.t("returns","results"); x.t("returns","database"); x.t("grouping","queries"); x.t("driver","improve"); x.t("driver","cache"); x.t("driver","connection"); x.t("driver","performance"); x.t("driver","allows"); x.t("driver","coordinates"); x.t("driver","reason"); x.t("driver","retrieve"); x.t("driver","cannot"); x.t("driver","database"); x.t("driver","takes"); x.t("driver","tuned"); x.t("driver","decreases"); x.t("driver","returns"); x.t("operations","different"); x.t("operations","case"); x.t("operations","operations"); x.t("therefore","application\u2019s"); x.t("therefore","application"); x.t("sql","queries"); x.t("behavior","include"); x.t("load","balance"); x.t("load","(enablebulkload)"); x.t("load","functionality"); x.t("load","performance-sensitive"); x.t("negatively","connection"); x.t("without","result"); x.t("forward-only","cursors"); x.t("associated","workload"); x.t("describe","prepare"); x.t("describeatprepare","enabled"); x.t("enablestaticcursorsforlongdata","attribute"); x.t("enablestaticcursorsforlongdata","application"); x.t("released","within"); x.t("released","(-1)"); x.t("passing","logon"); x.t("pool","time"); x.t("pool","size"); x.t("pool","populated"); x.t("pool","retains"); x.t("pool","contain"); x.t("pool","created"); x.t("even","connections"); x.t("buffer","size"); x.t("buffer","application"); x.t("fetches","images"); x.t("increased","accordingly"); x.t("increased","overhead"); x.t("increased","levels"); x.t("threads","option"); x.t("threads","(applicationusingthreads)"); x.t("threads","acquiring"); x.t("threads","driver"); x.t("server","action"); x.t("server","program"); x.t("server","connection"); x.t("server","max"); x.t("server","reduces"); x.t("server","client"); x.t("server","excess"); x.t("server","process"); x.t("server","module"); x.t("server","application"); x.t("server","significantly"); x.t("server","resources"); x.t("server","server"); x.t("matching","done"); x.t("contains","union"); x.t("resources","min"); x.t("resources","cpu"); x.t("resources","unix"); x.t("resources","applications"); x.t("binding","trade-off"); x.t("formulate","new"); x.t("update","statements"); x.t("seconds","enter"); x.t("seconds","note"); x.t("seconds","seconds"); }