{"id":294,"date":"2008-01-21T12:46:37","date_gmt":"2008-01-21T16:46:37","guid":{"rendered":"http:\/\/onlineappsdba.com\/index.php\/2008\/01\/21\/tables-used-by-purge-concurrent-request-concurrent-program\/"},"modified":"2008-01-21T12:53:56","modified_gmt":"2008-01-21T16:53:56","slug":"tables-used-by-purge-concurrent-request-concurrent-program","status":"publish","type":"post","link":"https:\/\/onlineappsdba.com\/index.php\/2008\/01\/21\/tables-used-by-purge-concurrent-request-concurrent-program\/","title":{"rendered":"Tables Used by Purge Concurrent Request Concurrent Program"},"content":{"rendered":"

\u00a0Source: Oracle Documentations<\/font>\u00a0<\/p>\n

Log and Output files retention policy can be controlled by you at o\/s level. Once you decide the retention policy for these logs and output files, the Purge Concurrent Request Concurrent Program or the Manager Data Concurrent Program will act, based on the information located in the database tables to determine which files it can safely purge and which it needs to retain. The retention policy for these log and output files needs to be determined by your Applications users. Archiving policy needs to be determined by the Internal Project Management staff. These policies can then be implemented, in part, through these concurrent requests. You can maintain statistics on concurrent requests, even after they have been purged from the system, by setting the Concurrent: Collect Request Statistics profile option to yes. These statistics can help you determine where best to start tuning long running or time-intensive concurrent requests.<\/font>\u00a0<\/font><\/p>\n

Purge Concurrent Request Concurrent Program Use the following tables:<\/font>\u00a0<\/font><\/p>\n

1) FND_CONCURRENT_REQUESTS:<\/font>\u00a0<\/font>Contains a complete history of all concurrent requests (both past history and those scheduled to run in the future).<\/font>\u00a0<\/font><\/p>\n

2) FND_RUN_REQUESTS:<\/font>\u00a0<\/font>Stores information about the reports in a report set that a user submits including the report set’s parameter values.<\/font>\u00a0<\/font><\/p>\n

3) FND_CONC_REQUEST_ARGUMENTS:<\/font>\u00a0<\/font>Records all arguments passed by Concurrent Managers to concurrent requests as those requests are running.<\/font><\/p>\n

\u00a0<\/font>4) FND_DUAL:<\/font>\u00a0<\/font>Records when a request does not update any database tables.<\/font>\u00a0<\/font><\/p>\n

5) FND_CONCURRENT_PROCESSES:<\/font>\u00a0<\/font>Records information about Oracle Applications processes and OS processes.<\/font>\u00a0<\/font><\/p>\n

6) FND_CONC_STAT_LIST:<\/font>\u00a0<\/font>\u00a0Collects runtime performance statistics for concurrent requests.<\/font>\u00a0<\/font><\/p>\n

7) FND_CONC_STAT_SUMMARY:<\/font>\u00a0<\/font>Contains Concurrent Program performance statistics generated by the Purge Concurrent Request program or the manager data program. These programs use the data in FND_CONC_STAT_LIST to compute these statistics.<\/font><\/p>\n

\u00a0<\/font>Note: Ref Oracle E-Business Documentations for Parameters accepted by the\u00a0Purge.<\/font>\u00a0<\/font><\/p>\n","protected":false},"excerpt":{"rendered":"

\u00a0Source: Oracle Documentations\u00a0 Log and Output files retention policy can be controlled by you at o\/s level. Once you decide […]<\/p>\n","protected":false},"author":115,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[1],"tags":[],"class_list":["post-294","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"\nTables Used by Purge Concurrent Request Concurrent Program -<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/onlineappsdba.com\/index.php\/2008\/01\/21\/tables-used-by-purge-concurrent-request-concurrent-program\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Tables Used by Purge Concurrent Request Concurrent Program -\" \/>\n<meta property=\"og:description\" content=\"\u00a0Source: Oracle Documentations\u00a0 Log and Output files retention policy can be controlled by you at o\/s level. Once you decide […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/onlineappsdba.com\/index.php\/2008\/01\/21\/tables-used-by-purge-concurrent-request-concurrent-program\/\" \/>\n<meta property=\"article:published_time\" content=\"2008-01-21T16:46:37+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2008-01-21T16:53:56+00:00\" \/>\n<meta name=\"author\" content=\"Masroof Ahmad\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Masroof Ahmad\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2008\/01\/21\/tables-used-by-purge-concurrent-request-concurrent-program\/\",\"url\":\"https:\/\/onlineappsdba.com\/index.php\/2008\/01\/21\/tables-used-by-purge-concurrent-request-concurrent-program\/\",\"name\":\"Tables Used by Purge Concurrent Request Concurrent Program -\",\"isPartOf\":{\"@id\":\"https:\/\/onlineappsdba.com\/#website\"},\"datePublished\":\"2008-01-21T16:46:37+00:00\",\"dateModified\":\"2008-01-21T16:53:56+00:00\",\"author\":{\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb\"},\"breadcrumb\":{\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2008\/01\/21\/tables-used-by-purge-concurrent-request-concurrent-program\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/onlineappsdba.com\/index.php\/2008\/01\/21\/tables-used-by-purge-concurrent-request-concurrent-program\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2008\/01\/21\/tables-used-by-purge-concurrent-request-concurrent-program\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/onlineappsdba.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Tables Used by Purge Concurrent Request Concurrent Program\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/onlineappsdba.com\/#website\",\"url\":\"https:\/\/onlineappsdba.com\/\",\"name\":\"\",\"description\":\"Oracle Implementation & Training Experts\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/onlineappsdba.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb\",\"name\":\"Masroof Ahmad\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g\",\"caption\":\"Masroof Ahmad\"},\"url\":\"https:\/\/onlineappsdba.com\/index.php\/author\/masroof\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Tables Used by Purge Concurrent Request Concurrent Program -","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/onlineappsdba.com\/index.php\/2008\/01\/21\/tables-used-by-purge-concurrent-request-concurrent-program\/","og_locale":"en_US","og_type":"article","og_title":"Tables Used by Purge Concurrent Request Concurrent Program -","og_description":"\u00a0Source: Oracle Documentations\u00a0 Log and Output files retention policy can be controlled by you at o\/s level. Once you decide […]","og_url":"https:\/\/onlineappsdba.com\/index.php\/2008\/01\/21\/tables-used-by-purge-concurrent-request-concurrent-program\/","article_published_time":"2008-01-21T16:46:37+00:00","article_modified_time":"2008-01-21T16:53:56+00:00","author":"Masroof Ahmad","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Masroof Ahmad","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/onlineappsdba.com\/index.php\/2008\/01\/21\/tables-used-by-purge-concurrent-request-concurrent-program\/","url":"https:\/\/onlineappsdba.com\/index.php\/2008\/01\/21\/tables-used-by-purge-concurrent-request-concurrent-program\/","name":"Tables Used by Purge Concurrent Request Concurrent Program -","isPartOf":{"@id":"https:\/\/onlineappsdba.com\/#website"},"datePublished":"2008-01-21T16:46:37+00:00","dateModified":"2008-01-21T16:53:56+00:00","author":{"@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb"},"breadcrumb":{"@id":"https:\/\/onlineappsdba.com\/index.php\/2008\/01\/21\/tables-used-by-purge-concurrent-request-concurrent-program\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/onlineappsdba.com\/index.php\/2008\/01\/21\/tables-used-by-purge-concurrent-request-concurrent-program\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/onlineappsdba.com\/index.php\/2008\/01\/21\/tables-used-by-purge-concurrent-request-concurrent-program\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/onlineappsdba.com\/"},{"@type":"ListItem","position":2,"name":"Tables Used by Purge Concurrent Request Concurrent Program"}]},{"@type":"WebSite","@id":"https:\/\/onlineappsdba.com\/#website","url":"https:\/\/onlineappsdba.com\/","name":"","description":"Oracle Implementation & Training Experts","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/onlineappsdba.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb","name":"Masroof Ahmad","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g","caption":"Masroof Ahmad"},"url":"https:\/\/onlineappsdba.com\/index.php\/author\/masroof\/"}]}},"_links":{"self":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts\/294","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/users\/115"}],"replies":[{"embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/comments?post=294"}],"version-history":[{"count":0,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts\/294\/revisions"}],"wp:attachment":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/media?parent=294"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/categories?post=294"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/tags?post=294"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}