SQL Performance (MOSC)

MOSC Banner

ORA-01400: cannot insert NULL into ("SYS"."WRI$_SQLSET_PLAN_LINES"."CON_DBID")

edited Dec 18, 2020 10:00PM in SQL Performance (MOSC) 2 commentsAnswered

Hello All,

When trying to Capture STS from Cursor Cache below error is seen.

Please advice.

Env:

AIX 7.1

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit

SQL> set timing on

SQL> set serveroutput on

SQL> prompt

SQL> prompt Creating STS for Cursor Cache

STS for Cursor Cache

SQL> prompt

SQL> prompt

SQL> prompt

SQL>

SQL>

SQL> BEGIN

  2  SYS.DBMS_SQLTUNE.CREATE_SQLSET (

  3  sqlset_name => 'STS_Upg_Cache',

  4  description => 'Plans before DB upgrade');

  5  END;

  6  /

PL/SQL procedure successfully completed.

Elapsed: 00:00:00.30

SQL> prompt

SQL> prompt Capturing STS from Cursor Cache

Capturing STS from Cursor Cache

SQL> prompt

SQL> prompt

SQL> prompt

SQL>

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center