Sql hint to disable statement from being saved to shared_pool
Hi
Oracle 19.14
I was wondering, is there a hint to make certain query not appearing into shared_pool..?
The reason I am asking is, we want to migrate audit records out of the database with quite small interval, like for example minutely.
The problem, we are using logstash for that, and its query is using literal values, so these statements are going to thrash my database shared_pool quite badly.
The select statement is very simple, and since each statement is also unique, then I am not going to benefit from parsing anyway.
Regards
Raul