Database Tuning (MOSC)

MOSC Banner

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

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