April 5, 2016 archive

Apr 05

V$SQL_SHARED_CURSOR TOP_LEVEL_RPI_CURSOR

I was working with an individual on a question in the MOSC forums recently where they asked about the TOP_LEVEL_RPI_CURSOR column of the V$SQL_SHARED_CURSOR view. There is little documentation on what this column is trying to tell the DBA. All the Oracle docs say is that this column contains “(Y|N) Is top level RPI cursor”. So …

Continue reading