Database security scan, sweep out several hard parse SQL,
According to the experience of others, after restart the database service, v $SQL dynamic table is empty,

Restart the database service until the next scan, tool does not use a database connection and database operation, and no start the web application service,
But security scan again swept out hard parse records, and part of the SQL application of SQL,

Consult a great god, why do these SQL will be scanned again, next to empty the database record of these hard parse

CodePudding user response:

Security scanning also do it...

CodePudding user response:

reference 1st floor minsic78 response:

Security scanning also do it...

Haven't seen these before, is no solution

CodePudding user response:

SQL executed for the first time, will be a hard parse, this is nothing wrong,
What kind of statement, it doesn't matter, don't affect safety,



PS: security scan, also tube hard parse, did a bit offside, the original poster to reconfirm, whether for the SQL injection,

CodePudding user response:

The

reference 3 floor selling fruit net reply:

SQL executed for the first time, it would be hard parse, this is nothing wrong,
What kind of statement, it doesn't matter, don't affect safety,



PS: security scan, also tube hard parse, did a bit offside, the original poster to reconfirm, whether for the SQL injection,

Hard parse more than two times, is indeed a SQL injection, but after the restart the database service, these records are not automatically removed, application service has stopped why will come out, and questions appear here

CodePudding user response:

Describe the wrong, just look at the, is launched before the database automatically check report

CodePudding user response:

This problem has been solved, plan is as follows: