Oracle AWR - High SQL Parse Calls, but 0 Executions

Question

I am trying to understand what causes an open query in an Oracle database (10).

In AWR, it shows a very large number of parsing calls (for example, 15,000+ in 1 hour), but 0 executions.

How can it execute the query, but then it is parsed 15,000 times?

Call Parses: 15,000+

Executions: 0

SQL text: select * from AVIEW

Answer 1

* in SQL explains repeated parsing. You must replace it with a list of field names.

Answer 2

Oracle 11, java, jdbc 11.2.0.3

The problem arises when you get a sequence from an insert like this

PreparedStatement ps = connection.prepareStatement(QUERY, new String[] { "student_id" });

, jdbc "SELECT * FROM" . .

T4CConnection.doDescribeTable

T4CStatement localT4CStatement = new T4CStatement(this, -1, -1);
localT4CStatement.open();
String str1 = paramAutoKeyInfo.getTableName();
String str2 = new StringBuilder().append("SELECT * FROM ").append(str1).toString();
localT4CStatement.sqlObject.initialize(str2);

Oracle "*", .

Answer 3

Zero executions , AWR

Answer 4

, :

select col1, col2, col3 from table

. , .

StatementCreatorUtils # setNull spring-jdbc. 4.2.7 :

insert into table (col1, col2, col3) values (val1, null, null)

.