c<\/em>R2 full documentation is not yet available, but you can test this on the Exadata Express Cloud Service.<\/p>\nI set the invalidation period to 5 seconds instead of 5 hours to show the behavior without waiting<\/p>\n
\n17:43:52 SQL> alter system set \"_optimizer_invalidation_period\"=5;\nSystem altered.\n<\/code><\/pre>\nI’ll run a statement with dbms_sql in order to separate parse and execute phases<\/p>\n
\n17:43:53 SQL> variable c number\n17:43:53 SQL> exec :c := dbms_sql.open_cursor;\nPL\/SQL procedure successfully completed.\n17:43:53 SQL> exec dbms_sql.parse(:c, 'select (cast(sys_extract_utc(current_timestamp) as date)-date''1970-01-01'')*24*3600 from DEMO' , dbms_sql.native );\nPL\/SQL procedure successfully completed.\n<\/code><\/pre>\nHere is the cursor from V$SQL including the new IS_ROLLING_INVALID column:<\/p>\n
\n17:43:53 SQL> select invalidations,loads,parse_calls,executions,first_load_time,last_load_time,last_active_time,is_rolling_invalid from v$sql where sql_id='61x2h0y9zv0r6';\n \nINVALIDATIONS LOADS PARSE_CALLS EXECUTIONS FIRST_LOAD_TIME LAST_LOAD_TIME LAST_ACTIVE_TIME IS_ROLLING_INVALID\n------------- ---------- ----------- ---------- ------------------- ------------------- ------------------ ------------------\n 0 1 1 0 2016-09-25\/17:43:53 2016-09-25\/17:43:53 25-SEP-16 17:43:52 N\n<\/code><\/pre>\nStatement is parsed (one parse call + load) but IS_ROLLING_INVALID is N<\/p>\n
Now I execute it:<\/p>\n
\n17:43:53 SQL> exec dbms_output.put_line( dbms_sql.execute(:c) );\n0\nPL\/SQL procedure successfully completed.\n \n17:43:53 SQL> select invalidations,loads,parse_calls,executions,first_load_time,last_load_time,last_active_time,is_rolling_invalid from v$sql where sql_id='61x2h0y9zv0r6';\n \nINVALIDATIONS LOADS PARSE_CALLS EXECUTIONS FIRST_LOAD_TIME LAST_LOAD_TIME LAST_ACTIVE_TIME IS_ROLLING_INVALID\n------------- ---------- ----------- ---------- ------------------- ------------------- ------------------ ------------------\n 0 1 1 1 2016-09-25\/17:43:53 2016-09-25\/17:43:53 25-SEP-16 17:43:52 N\n<\/code><\/pre>\nStatement has one execution.<\/p>\n
I’m now gathering statistics with default rolling invalidation:<\/p>\n
\n17:43:53 SQL> exec dbms_stats.gather_table_stats(user,'DEMO');\nPL\/SQL procedure successfully completed.\n \n17:43:53 SQL> select invalidations,loads,parse_calls,executions,first_load_time,last_load_time,last_active_time,is_rolling_invalid from v$sql where sql_id='61x2h0y9zv0r6';\n \nINVALIDATIONS LOADS PARSE_CALLS EXECUTIONS FIRST_LOAD_TIME LAST_LOAD_TIME LAST_ACTIVE_TIME IS_ROLLING_INVALID\n------------- ---------- ----------- ---------- ------------------- ------------------- ------------------ ------------------\n 0 1 1 1 2016-09-25\/17:43:53 2016-09-25\/17:43:53 25-SEP-16 17:43:52 Y\n<\/code><\/pre>\nThe cursor is now marked as rolling invalid (IS_ROLLING_INVALID=”Y”) but wait, this is not a “Y”\/”N” boolean, there’s another possible value.<\/p>\n
I execute the statement again (no parse call, only execution):<\/p>\n
\n17:43:53 SQL> exec dbms_output.put_line( dbms_sql.execute(:c) );\n0\nPL\/SQL procedure successfully completed.\n \n17:43:53 SQL> select invalidations,loads,parse_calls,executions,first_load_time,last_load_time,last_active_time,is_rolling_invalid from v$sql where sql_id='61x2h0y9zv0r6';\n \nINVALIDATIONS LOADS PARSE_CALLS EXECUTIONS FIRST_LOAD_TIME LAST_LOAD_TIME LAST_ACTIVE_TIME IS_ROLLING_INVALID\n------------- ---------- ----------- ---------- ------------------- ------------------- ------------------ ------------------\n 0 1 1 2 2016-09-25\/17:43:53 2016-09-25\/17:43:53 25-SEP-16 17:43:52 X\n<\/code><\/pre>\nCursor is now marked as rolling invalid executed (“X”) and this is where the rolling window starts (which I’ve set to 5 seconds instead of 5 hours)<\/p>\n
I wait 5 seconds and the cursor has not changed:<\/p>\n
\n17:43:58 SQL> select invalidations,loads,parse_calls,executions,first_load_time,last_load_time,last_active_time,is_rolling_invalid from v$sql where sql_id='61x2h0y9zv0r6';\n \nINVALIDATIONS LOADS PARSE_CALLS EXECUTIONS FIRST_LOAD_TIME LAST_LOAD_TIME LAST_ACTIVE_TIME IS_ROLLING_INVALID\n------------- ---------- ----------- ---------- ------------------- ------------------- ------------------ ------------------\n 0 1 1 2 2016-09-25\/17:43:53 2016-09-25\/17:43:53 25-SEP-16 17:43:52 X\n \n<\/code><\/pre>\nI execute it again (no parse call, only re-execute the cursor):<\/p>\n
\n17:43:58 SQL> exec dbms_output.put_line( dbms_sql.execute(:c) );\n0\nPL\/SQL procedure successfully completed.\n<\/code><\/pre>\nFor this execution, a new child has been created:<\/p>\n
\n17:43:58 SQL> select invalidations,loads,parse_calls,executions,first_load_time,last_load_time,last_active_time,is_rolling_invalid from v$sql where sql_id='61x2h0y9zv0r6';\n \nINVALIDATIONS LOADS PARSE_CALLS EXECUTIONS FIRST_LOAD_TIME LAST_LOAD_TIME LAST_ACTIVE_TIME IS_ROLLING_INVALID\n------------- ---------- ----------- ---------- ------------------- ------------------- ------------------ ------------------\n 0 1 1 2 2016-09-25\/17:43:53 2016-09-25\/17:43:53 25-SEP-16 17:43:52 X\n 0 1 0 1 2016-09-25\/17:43:53 2016-09-25\/17:43:57 25-SEP-16 17:43:57 N\n<\/code><\/pre>\nSo rolling invalidation do not require a parse call. Execution can start the rolling window and set the invalidation timestamp, and first execution after this timestamp creates a new child cursor.<\/p>\n
I’ll now test what happens with parse calls only.<\/p>\n
I set a longer rolling window (2 minutes) here:<\/p>\n
\n17:43:58 SQL> exec dbms_stats.gather_table_stats(user,'DEMO');\nPL\/SQL procedure successfully completed.\n \n17:43:58 SQL> alter system set \"_optimizer_invalidation_period\"=120;\nSystem altered.\n<\/code><\/pre>\nThe last child has been marked as rolling invalid but not yet executed in this state:<\/p>\n
\n17:43:58 SQL> select invalidations,loads,parse_calls,executions,first_load_time,last_load_time,last_active_time,is_rolling_invalid from v$sql where sql_id='61x2h0y9zv0r6';\n \nINVALIDATIONS LOADS PARSE_CALLS EXECUTIONS FIRST_LOAD_TIME LAST_LOAD_TIME LAST_ACTIVE_TIME IS_ROLLING_INVALID\n------------- ---------- ----------- ---------- ------------------- ------------------- ------------------ ------------------\n 0 1 1 2 2016-09-25\/17:43:53 2016-09-25\/17:43:53 25-SEP-16 17:43:52 X\n 0 1 0 1 2016-09-25\/17:43:53 2016-09-25\/17:43:57 25-SEP-16 17:43:57 Y\n<\/code><\/pre>\nFrom a new session I open another cursor:<\/p>\n
\n17:43:58 SQL> connect &_user.\/demo@&_connect_identifier\nConnected.\n17:43:58 SQL> exec :c := dbms_sql.open_cursor;\nPL\/SQL procedure successfully completed.\n<\/code><\/pre>\nAnd run several parse calls without execute, one every 10 seconds:<\/p>\n
\n17:43:58 SQL> exec for i in 1..12 loop dbms_sql.parse(:c, 'select (cast(sys_extract_utc(current_timestamp) as date)-date''1970-01-01'')*24*3600 from DEMO' , dbms_sql.native ); dbms_lock.sleep(10); end loop;\nPL\/SQL procedure successfully completed.\n<\/code><\/pre>\nSo two minutes later I see that I have a new child created during the rolling window:<\/p>\n
\n17:45:58 SQL> select invalidations,loads,parse_calls,executions,first_load_time,last_load_time,last_active_time,is_rolling_invalid from v$sql where sql_id='61x2h0y9zv0r6';\n \nINVALIDATIONS LOADS PARSE_CALLS EXECUTIONS FIRST_LOAD_TIME LAST_LOAD_TIME LAST_ACTI IS_ROLLING_INVALID\n------------- ---------- ----------- ---------- ------------------- ------------------- --------- ------------------\n 0 1 1 2 2016-09-25\/17:43:53 2016-09-25\/17:43:53 25-SEP-16 X\n 0 1 3 1 2016-09-25\/17:43:53 2016-09-25\/17:43:57 25-SEP-16 Y\n 0 1 9 0 2016-09-25\/17:43:53 2016-09-25\/17:44:27 25-SEP-16 N\n<\/code><\/pre>\nHere, at the third parse call (17:44:27) during the invalidation window, a new child cursor has been created. The old one is still marked as rolling invalid (“Y”), but not ‘rolling invalid executed’ (“X”) because it has not been executed.<\/p>\n
So it seems that both parse or execute are triggering the rolling invalidation, and the IS_ROLLING_INVALID displays which one.<\/p>\n
An execute will now execute the new cursor:<\/p>\n
\n17:45:58 SQL> exec dbms_output.put_line( dbms_sql.execute(:c) );\n \nPL\/SQL procedure successfully completed.\n \n17:45:58 SQL> select invalidations,loads,parse_calls,executions,first_load_time,last_load_time,last_active_time,is_rolling_invalid from v$sql where sql_id='61x2h0y9zv0r6';\n \nINVALIDATIONS LOADS PARSE_CALLS EXECUTIONS FIRST_LOAD_TIME LAST_LOAD_TIME LAST_ACTI IS_ROLLING_INVALID\n------------- ---------- ----------- ---------- ------------------- ------------------- --------- ------------------\n 0 1 1 2 2016-09-25\/17:43:53 2016-09-25\/17:43:53 25-SEP-16 X\n 0 1 3 1 2016-09-25\/17:43:53 2016-09-25\/17:43:57 25-SEP-16 Y\n 0 1 9 1 2016-09-25\/17:43:53 2016-09-25\/17:44:27 25-SEP-16 N\n<\/code><\/pre>\nOf course, when new cursors have been created we can see the reason in V$SQL_SHARED_CURSOR:<\/p>\n
\n17:45:58 SQL> select child_number,reason from v$sql_shared_cursor where sql_id='61x2h0y9zv0r6';\n \nCHILD_NUMBER REASON\n------------ --------------------------------------------------------------------------------\n 0 <ChildNode><ChildNumber>0<\/ChildNumber><ID>33<\/ID><reason>Rolling Invalidate Win\n dow Exceeded(2)<\/reason><size>0x0<\/size><details>already_processed<\/details><\/Ch\n ildNode><ChildNode><ChildNumber>0<\/ChildNumber><ID>33<\/ID><reason>Rolling Invali\n date Window Exceeded(3)<\/reason><size>2x4<\/size><invalidation_window>1472658232<\n \/invalidation_window><ksugctm>1472658237<\/ksugctm><\/ChildNode>\n \n 1 <ChildNode><ChildNumber>1<\/ChildNumber><ID>33<\/ID><reason>Rolling Invalidate Win\n dow Exceeded(2)<\/reason><size>0x0<\/size><details>already_processed<\/details><\/Ch\n ildNode><ChildNode><ChildNumber>1<\/ChildNumber><ID>33<\/ID><reason>Rolling Invali\n date Window Exceeded(3)<\/reason><size>2x4<\/size><invalidation_window>1472658266<\n \/invalidation_window><ksugctm>1472658268<\/ksugctm><\/ChildNode>\n \n 2\n<\/code><\/pre>\nThe last child cursor has been created at 5:44:28 (invalidation_window=1472658268) because invalidation timestamp (ksugctm=1472658266)<\/p>\n
So what?<\/h3>\n
We love Oracle because it’s not a black box. And it’s good to see that they continue in this way by exposing in V$ views information that can be helpful for troubleshooting. <\/p>\n
Rolling invalidation has been introduced for dbms_stats because we have to gather statistics and we don’t want hard parse storms after that.
\nBut remember that invalidation can also occur with DDL such as create, alter, drop, comment, grant, revoke.<\/p>\n
You should avoid running DDL when application is running. However, we may have to do some of those operations online. It would be nice to have the same rolling invalidation mechanisms and it seems that it will be possible: <\/p>\n
\nSQL> show parameter invalid\n \nNAME TYPE VALUE\n------------------------------------ ----------- ------------------------------\ncursor_invalidation string IMMEDIATE\n \nSQL> alter session set cursor_invalidation=XXX;\nERROR:\nORA-00096: invalid value XXX for parameter cursor_invalidation, must be from among IMMEDIATE, DEFERRED\n<\/code><\/pre>\nThat’s interesting. I’ll explain which DDL can use that in a future blog post.<\/p>\n","protected":false},"excerpt":{"rendered":"
By Franck Pachot . In a previous post I published a test case to show when a cursor is not shared anymore after a rolling invalidation. Basically the dbms_stats marks the cursor as ‘rolling invalid’ and the next execution marks it as ‘rolling invalid executed’. Looking at 12cR2 there is a little enhancement in V$SQL […]<\/p>\n","protected":false},"author":27,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229],"tags":[656,906,209],"type_dbi":[],"class_list":["post-8803","post","type-post","status-publish","format-standard","hentry","category-database-administration-monitoring","tag-12-2","tag-invalidation","tag-oracle-12c"],"acf":[],"yoast_head":"\n
Oracle 12cR2: IS_ROLLING_INVALID in V$SQL - dbi Blog<\/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:\/\/www.dbi-services.com\/blog\/oracle-12cr2-is_rolling_invalid-in-vsql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle 12cR2: IS_ROLLING_INVALID in V$SQL\" \/>\n<meta property=\"og:description\" content=\"By Franck Pachot . In a previous post I published a test case to show when a cursor is not shared anymore after a rolling invalidation. Basically the dbms_stats marks the cursor as ‘rolling invalid’ and the next execution marks it as ‘rolling invalid executed’. Looking at 12cR2 there is a little enhancement in V$SQL […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-is_rolling_invalid-in-vsql\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2016-09-25T14:51:17+00:00\" \/>\n<meta name=\"author\" content=\"Oracle Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Oracle Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-is_rolling_invalid-in-vsql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-is_rolling_invalid-in-vsql\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"Oracle 12cR2: IS_ROLLING_INVALID in V$SQL\",\"datePublished\":\"2016-09-25T14:51:17+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-is_rolling_invalid-in-vsql\/\"},\"wordCount\":590,\"commentCount\":0,\"keywords\":[\"12.2\",\"invalidation\",\"Oracle 12c\"],\"articleSection\":[\"Database Administration & Monitoring\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-is_rolling_invalid-in-vsql\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-is_rolling_invalid-in-vsql\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-is_rolling_invalid-in-vsql\/\",\"name\":\"Oracle 12cR2: IS_ROLLING_INVALID in V$SQL - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2016-09-25T14:51:17+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-is_rolling_invalid-in-vsql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-is_rolling_invalid-in-vsql\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-is_rolling_invalid-in-vsql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle 12cR2: IS_ROLLING_INVALID in V$SQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\",\"name\":\"Oracle Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"caption\":\"Oracle Team\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Oracle 12cR2: IS_ROLLING_INVALID in V$SQL - dbi Blog","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:\/\/www.dbi-services.com\/blog\/oracle-12cr2-is_rolling_invalid-in-vsql\/","og_locale":"en_US","og_type":"article","og_title":"Oracle 12cR2: IS_ROLLING_INVALID in V$SQL","og_description":"By Franck Pachot . In a previous post I published a test case to show when a cursor is not shared anymore after a rolling invalidation. Basically the dbms_stats marks the cursor as ‘rolling invalid’ and the next execution marks it as ‘rolling invalid executed’. Looking at 12cR2 there is a little enhancement in V$SQL […]","og_url":"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-is_rolling_invalid-in-vsql\/","og_site_name":"dbi Blog","article_published_time":"2016-09-25T14:51:17+00:00","author":"Oracle Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Oracle Team","Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-is_rolling_invalid-in-vsql\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-is_rolling_invalid-in-vsql\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"Oracle 12cR2: IS_ROLLING_INVALID in V$SQL","datePublished":"2016-09-25T14:51:17+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-is_rolling_invalid-in-vsql\/"},"wordCount":590,"commentCount":0,"keywords":["12.2","invalidation","Oracle 12c"],"articleSection":["Database Administration & Monitoring"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-is_rolling_invalid-in-vsql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-is_rolling_invalid-in-vsql\/","url":"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-is_rolling_invalid-in-vsql\/","name":"Oracle 12cR2: IS_ROLLING_INVALID in V$SQL - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2016-09-25T14:51:17+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-is_rolling_invalid-in-vsql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-is_rolling_invalid-in-vsql\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-is_rolling_invalid-in-vsql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Oracle 12cR2: IS_ROLLING_INVALID in V$SQL"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee","name":"Oracle Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","caption":"Oracle Team"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/8803","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/27"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=8803"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/8803\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=8803"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=8803"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=8803"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=8803"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}